Reporting Services - No reports

[Former Member]

I have a two server configuration - DB/Analysis Services on one server, App/Reporting/File on another.

I configured reporting services on the app server with default settings AFAIK. I installed BPC without issue and have patched to 5.0.501.

If I go to the http://localhost/reports or http://localhost/reportserver on the reporting services machine I do not see any reports. If I try to run a report, like a security report for a user, I get back an error from reporting services stating that the report item was not found (as I suppose should be expected since I don't see any reports in there.

So, my question is why the reports aren't there (both admin and ApShell) and how do I fix this problem.

Thanks,

McP

[Former Member · Accepted solution]

Michael,

I do not know why they are missing: but could you please try to save the application in question of which the reports are missing (in administration; select the application, select modify application, select all selectionboxes and continue).

If this doesn't help, you could try to add them manually to reporting services:

- in internet explorer go to the adress: http://<servername>/reports/Pages/Folder.aspx

- click on the <appset> name

- click on u201CUpload fileu201D

- browse to the directory where the .rdl files are (Webfolders\<appset>\Report

- add all .rdl files following this procedure (all reports starting with SEC are the security reports)

- please test it now

Hope this helps,

Alwin

[Former Member · Accepted solution]

OK - I think we are just about there. Doing the Modfiy Application and selecting the checkboxes created the ApShell folder, some shared data connections and then folders for each of the applications (I did all 5 in ApShell) with their respective reports.

What is still missing are the AdminTemplates reports that have all the security ones and others. Outside of manually uploading every report (oh my that would be tedious) is that some way, similar to the modify application approach, to get them all where they need to be?

In case it wasn't clear - prior to running the modify application step I did not have an ApShell within the reporting services UI. Once I ran it for one of the applications I got the ApShell folder and the application folder within it, just not the admin reports.

I tried uploading the SEC_LIST_USER.rdl report through the reporting services UI and got this error message displayed in the browser:

The Value expression for the textbox u2018tbLinku2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online HelpThe Value expression for the textbox u2018txtReportLabelu2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

The Value expression for the textbox u2018textbox1u2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

The Value expression for the textbox u2018textbox2u2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

The Value expression for the textbox u2018textbox10u2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

The Value expression for the textbox u2018textbox6u2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

The Value expression for the textbox u2018textbox4u2019 contains an error: [BC30037] Character is not valid. (rsCompilerErrorInExpression) Get Online Help

Thanks,

McP

Edited by: Michael Pelletier on Jul 18, 2008 2:49 PM

Edited by: Michael Pelletier on Jul 18, 2008 2:52 PM

[Former Member · Accepted solution]

Hi Michael,

I have done some testing myself and encountered the same problem that you have.

The Apshell application doesn't contain the security reports after a software upgrade (in my case to 5.0.502).

But the good news is (at least in my case and I hope in yours too) is that I was able to get them back.

Just copy the apshell application to a new appset using the option in administration called 'ad a new application set'. During the copy, the security reports are created correctly and automatically in the new appset. And I was able to use them.

the only difference between your case and my case is that I am on version 502 and you on 501 but I have the feeling that this solution will work for you to.

Hope this helps,

Alwin