Reporting services question

Hi,
I created aspx page with reprotviewer. Report runs fine and I exported it to
excel. (Windows 2000 Professional and MS Office 2002). When I try to open r
eport with excel it gives me "Problem during load" message box with message:
"Missing file: c:\styleshe
et.css". When I opened excel file with notepad, I found following line "<lin
k rel=3DStylesheet href=3D"file:///c:\stylesheet.css">". I removed line and
when I opened excel file again, file opened without message box.
What should I do to make sure that line mentioned above doesn't appear in fi
le in the first place?
Thanks,
VcitorI have to assume that the stylesheet link is being placed in there from =
your aspx page or the report viewer. Can you see any way to not use =
this stylesheet (or any other style sheet for that matter)?
On a side note, I would be interested in seeing the code. I am =
beginning to use Reporting Services and it would be interesting to see =
how you were able to render reports within the web pages using the =
report viewer. Are you willing to post your code here or to a location =
like http://www.gotdotnet.com/ ?
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:84995B62-2670-47E8-B563-9904A0C466DE@.microsoft.com...
> Hi,
>=20
> I created aspx page with reprotviewer. Report runs fine and I exported =
it to excel. (Windows 2000 Professional and MS Office 2002). When I try =
to open report with excel it gives me "Problem during load" message box =
with message: "Missing file: c:\stylesheet.css". When I opened excel =
file with notepad, I found following line "<link rel=3D3DStylesheet =
href=3D3D"file:///c:\stylesheet.css">". I removed line and when I opened =
excel file again, file opened without message box.
> What should I do to make sure that line mentioned above doesn't appear =
in file in the first place?
>=20
> Thanks,
> Vcitor|||I exported again to excel format and its working fine now. Reporting service
s have some issues which hopefully will be resolved in Service Pack 1.
Following is C# code which executed in code behind on button click:
protected Microsoft.Samples.ReportingServices.ReportViewer reprotViewer;
private void btnView_Click(object sender, System.EventArgs e){
string _dateFormat = "yyyy-MM-dd";
string _zeroTime = "+00%3a00%3a00";
string _fromDate = Convert.ToDateTime(lblFromDatetxt.Text).ToString(_dateFor
mat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).ToString(_
dateFormat) + _zeroTime;
string _reportName = "";
string _merchant = "";
reprotViewer.Visible = true;
if(ddlCIMSreports.SelectedItem.Text == "Summary"){
_reportName = "SalesSummary";
}
else{
_reportName = "SalesByMerchantDetail";
//Following assigns Vendor from dropdown list box
_merchant = "&vendor=" + ddlVendor.SelectedItem.Text.Replace(" ", "+");
}
reprotViewer.ServerUrl = "http://localhost/ReportServer";
//Following assigns report name and 3 parameters expected by report
reprotViewer.ReportPath = "%2MerchantSales%2f" + _reportName + _merchant + "
&dateFrom=" + _fromDate + "&dateTo=" +_toDate;
}
I hope its helpfull.
Victor|||Nice article:
http://odetocode.com/Articles/128.aspx|||good info. thanks
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:9FF0148B-33D9-4FAB-933D-1FC357A0E774@.microsoft.com...
> Nice article:
>=20
> http://odetocode.com/Articles/128.aspx