Question Re: Reporting Services - No reports in Additional Q&A

Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 14:31:45 GMT

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

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 14:54:05 GMT

Hi!

I hope you havent lost anything

Please look on the server where they used to be.

go to

\BPC\Data\Webfolders\NAMEOFYOURAPPSET\finance\Eexcel\

Assuming you had docs into the Finance application, then all of them shoudl be there.

Please back them up!

And put them back manually on the Excel folders...

Do not forget to restore the datamanager if you had data in there...

It should do it!

Nic

Edited by: Nicolas Argente on Jul 18, 2008 3:55 PM

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 15:00:04 GMT

It's the reporting services .rdl reports that I don't see through the reporting services interface that are in question, not excel reports. All the .rdl files are in the ApShell\reports folder or in the AdminTemplates folder where they should be. Reporting Services just isn't seeing them. It's like they weren't deployed or something. Should they be visible through the Reporting Services UI? I would think so, no?

McP

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 19:32:46 GMT

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

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 19:47:29 GMT

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

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 21:37:23 GMT

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

Re: Reporting Services - No reports

Former Member — Fri, 18 Jul 2008 22:20:54 GMT

I've used these reports in a similar configuration without issue. I'm not sure why you would be running into a problem.

This might be a silly question but have you set up MS SQL server reporting services? is it properly configured for your environment?

The reports you are refering to use reporting services, if you don't have it set up, these reports will not run.

Re: Reporting Services - No reports

Former Member — Mon, 21 Jul 2008 12:50:44 GMT

Yes, Reporting Services is installed... Had you read through everything I've done so far you would have noticed that.

Thanks Alwin - creating a new app set based on ApShell created all the reports that were missing. ApShell still doesn't have them, but my new ApShell1 does and that's good enough.

Thanks for your help.

McP