Reporting Services Returned Data

Hey guys :)

I am not sure i have titled this post correctly or even if i have posted it in the correct forums, so please accept my apologies if i have done either wrong.

Does anyone know of a way to return the underlying data that produces a report from within c#

I am using the report viewer component and the Reporting Services SOAP service.

I am currently using the GetReportDefinition(string ReportPath) function to return the entire xml definition of the report and then parsing out the CommandText and ConnStr fields and the running these as you normally would to return a DataSet :), but obviously this means double the processing time on the server if the user firstly runs the report and i dont really want to have to do this.

Any help would be much appreciated :)

oops i failed to mention, not all the reports use shared data sources :( so i cant use them.

Merry Christmas

Scott Blood

you can tie the returned xml directly to a datagrid and then display the data on the grid and then print the same or you can also tied the data to a data grid and then use response object to display the same data on the excel.

|||

abdulbq:

you can tie the returned xml directly to a datagrid and then display the data on the grid and then print the same or you can also tied the data to a data grid and then use response object to display the same data on the excel.

Abdul,

Thanks for replying to this question. However i am not sure how to access the returned xml of a report. Can you point me in the right direction on how to get this data.

Thanking you in advance.

Reporting Services parameters not in correct order

Hi,

SQL Server Reporting Services 2005.

I have 13 parameters, ordered correctly within the Report Parameter screen.

When displayed in the Preview tab they are all ordered correctly, but when viewed in the application the first 4 are at the top but ordered incorrectly. The remainder are ordered correctly.

I have tried reordering, saving, deploying, viewing and then doing the same but in the correct order without any success.

Please can someone suggest how I can get the parameters to appear in the correct order within the application?

Thanking you,

dwemh

dwemh

Do you mean the alignment of report parameters within ReportViewer

control parameters area? If so, may be custom control for parameters

setting is worth developing. As I know, GetReportParameters() web method returns parameter collection, saving original order.

|||

The parameters are displayed in the order they appear on the report parameters page in the report designer tool. If you have previously published the report, you may need to delete it and replublish for any order changes to be reflected on the server.

Other than that, parameters are always layed out left to right, top to bottom by default (this adapts to your globalization settings). If that doesn't meet you needs, you'll need to follow Anatoly's advice and provide a custom application to display them how you want them.

-Lukasz

|||

Well. this bring me closer to a question I had since days.. Can we have more than 2 parameters displayed in a single row on report (when browsed ). The parameters by default - seems to be lined up in an array of 2 columns, ad N rows - which is frustrating because so much of space is left blank (space just left of <View Report> button.

How did you managed to get 4 parameters in one single row ?

Thanks for ideas.

|||

Yup, can only have 2 columns in our UI and we don't expose a property to set the number of columns. I've added a design change request to our internal system to try to get this addressed.

Right now, the only way you can get more parameters is to build a custom UI.

-Lukasz

sql

reporting services error

Reporting Service is installed and working correctly. However, if I disconnect from the network (laptop computer), I receive an error when attempting to access the localhost/reports page. If I reconnect to my home, office, or other network (doesnâ't matter which), I donâ't receive the error. What can cause this error?Please post this to microsoft.public.sqlserver.reportingsvcs
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"rhawkins" <rhawkins@.gapac.com> wrote in message
news:E45023D0-796A-45A7-A165-D77837844560@.microsoft.com...
> Reporting Service is installed and working correctly. However, if I
disconnect from the network (laptop computer), I receive an error when
attempting to access the localhost/reports page. If I reconnect to my home,
office, or other network (doesn't matter which), I don't receive the error.
What can cause this error?|||The newsgroup you have suggested is not a "managed" newsgroup. Thanks for trying to help. Microsoft may need to add a managed newsgroup for SQL Server Reporting Services now that it has become a core technology.|||You could have a look at the RS logfile to try to get more info. Without
seeing the error message text it is difficult to say what the issue is, but
as far as I know there are at least 2 potential dependencies on Windows
authentication:
the connection used to connect to the report server database,
the account values used for unattended report processing.
These values exist in RSReportServer.config and can be changed to sql
authentication using rsconfig.
I'd do this so there are no longer any obvious dependencies.
HTH,
Paul Ibison

reporting services error

Reporting Service is installed and working correctly. However, if I disconn
ect from the network (laptop computer), I receive an error when attempting t
o access the localhost/reports page. If I reconnect to my home, office, or
other network (doesn’t ma
tter which), I don’t receive the error. What can cause this error?Please post this to microsoft.public.sqlserver.reportingsvcs
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"rhawkins" <rhawkins@.gapac.com> wrote in message
news:E45023D0-796A-45A7-A165-D77837844560@.microsoft.com...
> Reporting Service is installed and working correctly. However, if I
disconnect from the network (laptop computer), I receive an error when
attempting to access the localhost/reports page. If I reconnect to my home,
office, or other network (doesn't matter which), I don't receive the error.
What can cause this error?|||The newsgroup you have suggested is not a "managed" newsgroup. Thanks for t
rying to help. Microsoft may need to add a managed newsgroup for SQL Server
Reporting Services now that it has become a core technology.|||You could have a look at the RS logfile to try to get more info. Without
seeing the error message text it is difficult to say what the issue is, but
as far as I know there are at least 2 potential dependencies on Windows
authentication:
the connection used to connect to the report server database,
the account values used for unattended report processing.
These values exist in RSReportServer.config and can be changed to sql
authentication using rsconfig.
I'd do this so there are no longer any obvious dependencies.
HTH,
Paul Ibison

reporting services error

Reporting Service is installed and working correctly. However, if I disconnect from the network (laptop computer), I receive an error when attempting to access the localhost/reports page. If I reconnect to my home, office, or other network (doesn’t ma
tter which), I don’t receive the error. What can cause this error?
Please post this to microsoft.public.sqlserver.reportingsvcs
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"rhawkins" <rhawkins@.gapac.com> wrote in message
news:E45023D0-796A-45A7-A165-D77837844560@.microsoft.com...
> Reporting Service is installed and working correctly. However, if I
disconnect from the network (laptop computer), I receive an error when
attempting to access the localhost/reports page. If I reconnect to my home,
office, or other network (doesn't matter which), I don't receive the error.
What can cause this error?
|||The newsgroup you have suggested is not a "managed" newsgroup. Thanks for trying to help. Microsoft may need to add a managed newsgroup for SQL Server Reporting Services now that it has become a core technology.
|||You could have a look at the RS logfile to try to get more info. Without
seeing the error message text it is difficult to say what the issue is, but
as far as I know there are at least 2 potential dependencies on Windows
authentication:
the connection used to connect to the report server database,
the account values used for unattended report processing.
These values exist in RSReportServer.config and can be changed to sql
authentication using rsconfig.
I'd do this so there are no longer any obvious dependencies.
HTH,
Paul Ibison

Reporting Services Error

Hello. I Do a report with a matrix, the report until the preview work
correctly, but when I publish it show me the next error
JIT debugging failed with the following error: Access Denied
JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
red'.
Check the documentation index for 'Just-in-time debugging, errors' for more
information.
htp://go.microsoft.com/fwlink/events.asp
I make the report again, publish it after every small change and I find that
it fail after I put a groups of rows in the matrix, but in the preview, it
dont show me any warning or errors, only fail after I publish it.
for better reference: the report use a shared data source and is publised in
a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
2000, and .NET 2003Are you using any custom .dll files in this report? What else is it
referencing? It is clear that you have a permissions/security issue. The
designer will bypass code level security checks so it is not good for testing
this.. that would explain why you only get the error on deployed reports.
Bret Updegraff
http://bretup.spaces.live.com/
"UsuarioNovato" wrote:
> Hello. I Do a report with a matrix, the report until the preview work
> correctly, but when I publish it show me the next error
> JIT debugging failed with the following error: Access Denied
> JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
> red'.
> Check the documentation index for 'Just-in-time debugging, errors' for more
> information.
> htp://go.microsoft.com/fwlink/events.asp
>
> I make the report again, publish it after every small change and I find that
> it fail after I put a groups of rows in the matrix, but in the preview, it
> dont show me any warning or errors, only fail after I publish it.
> for better reference: the report use a shared data source and is publised in
> a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
> 2000, and .NET 2003
>
>