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 report 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 "<link 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 file in the first place?
Thanks,
Vcitor
I 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 services 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(_ dateFormat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).T oString(_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

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

Reporting Services Parameters

I have a report set up in SQL reporting services which I need to pass two values: fundingRef and mRef from another aspx page which I have managed to get working using the following code:

string param = "&fundingRef=2" + "&mRef=25";
ReportViewer1.ReportPath = Global.ReportPath + reportPath + param;

Both the parameters have been set up in the SQL report designer in VS2003.NET and will contain several values using the SQL IN statement. My sql statement is to a structure as follows:

SELECT [field names] FROM [table] WHERE (fundingRef in(@.fundingRef )) AND (mastercourseRef in(@.mRef))

When I pass single values, it works fine but when I try to send values e.g. 14, 25, 3, 4, 28, 2, 1, 6, 5. I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot read the next data row for the data set TTP. (rsErrorReadingNextDataRow) Get Online Help Error converting data type nvarchar to bigint.

I have tried declaring the variable as a varchar but although it returns no error, it also returns no records. Please can someone enlighten me as to how I can this to work. Cheers.

Are you using "," as value seperators?

D.|||Yes|||This should work with RS 2005 as it support multiple param selections.

I'm guessing this is the reason it's not working now.|||Try using a table function & large varchar parameter if your report can accomodate.
See this article on parsing tokens...|||Cool, thanks for the information wavesmash. I hope this should fix my problem. I'll let you know how I get on.

Cheers again

Reporting Services Parameters

I have a report set up in SQL reporting services which I need to pass two values: fundingRef and mRef from another aspx page which I have managed to get working using the following code:

string param = "&fundingRef=2" + "&mRef=25";
ReportViewer1.ReportPath = Global.ReportPath + reportPath + param;

Both the parameters have been set up in the SQL report designer in VS2003.NET and will contain several values using the SQL IN statement. My sql statement is to a structure as follows:

SELECT [field names] FROM [table] WHERE (fundingRef in(@.fundingRef )) AND (mastercourseRef in(@.mRef))

When I pass single values, it works fine but when I try to send values e.g. 14, 25, 3, 4, 28, 2, 1, 6, 5. I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot read the next data row for the data set TTP. (rsErrorReadingNextDataRow) Get Online Help Error converting data type nvarchar to bigint.

I have tried declaring the variable as a varchar but although it returns no error, it also returns no records. Please can someone enlighten me as to how I can this to work. Cheers.

Are you using "," as value seperators?

D.|||Yes|||This should work with RS 2005 as it support multiple param selections.

I'm guessing this is the reason it's not working now.|||Try using a table function & large varchar parameter if your report can accomodate.
See this article on parsing tokens...|||Cool, thanks for the information wavesmash. I hope this should fix my problem. I'll let you know how I get on.

Cheers again

Reporting Services Error

Hi Friends,
When I am browse http://localhost/ReportServer/Pages/ReportViewer.aspx , I
get this type error below.
Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Exception of type 'System.Web.HttpUnhandledException' was thrown.
The source of the report definition has not been specified
----
SQL Server Reporting ServicesHi, Alex!
It seems to me that something bad is with your datasource. Either with the
reportserver database itself or the datasources of your reports are badly
configured. Can you specify more details?
"Alex Smith" wrote:
> Hi Friends,
> When I am browse http://localhost/ReportServer/Pages/ReportViewer.aspx , I
> get this type error below.
>
> Reporting Services Error
> ----
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Exception of type 'System.Web.HttpUnhandledException' was thrown.
> The source of the report definition has not been specified
> ----
> SQL Server Reporting Services
>
>
>