Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : Newbie question: Drillthrough links not working after publishing



Crandaddy
7/25/2005 1:41:07 PM
I've published my first three reports from VS.NET 2K3 to my local Web site,
and the drillthrough links do not work when I view them through the Report
Manager. The links work fine in Preview mode.

When I view the first report and use the drillthrough links to the
second-level report, I get the following message:

The item '/ClientDemo/Activity Summary By Transaction Type' cannot be found.
(rsItemNotFound)

Also, on a (probably) unrelated note, if I select any report and
If I navigate directly to the second-level report and try the drillthrough
links to the third-level report, I don't get any error, but the resulting
page comes up mostly blank. I get the Header listing the report name and the
gray bar with the up-arrows on the right, but no filters and no report
content.

Each of the reports look fine when I navigate directly to them from the
Report Manager.

Also, on an (probably) unrelated note, if I select any object (report or
data source) in the report manager, and go to the Properties tab, I get the
following message:

Unable to generate a temporary class (result=1). error CS1514: { expected
error CS1001: Identifier expected error CS1031: Type expected error CS1519:
Invalid token '{' in class, struct, or interface member declaration error
CS1514: { expected error CS1001: Identifier expected error CS1031: Type
expected error CS1519: Invalid token '{' in class, struct, or interface
member declaration

Any help would be appreciated!
Robert Bruckner [MSFT]
7/25/2005 8:06:53 PM
Please check this KB article which applies to the error related to the
temporary classes error:
http://support.microsoft.com/?kbid=895242&SD=tech


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.



[quoted text, click to view]

Crandaddy
7/26/2005 8:56:08 AM
Thanks for the information about the temporary classes error--that fixed that
problem.

I still cannot figure out why the drill-through links do not work. The URL
of the link comes out like this, which I can't make heads or tails of:

http://localhost/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fusboscrandall2%2fReportServer%3f%252fClientDemo%252fActivity%2bSummary%2bBy%2bTransaction%2bType%26pFund%3d%255bFund%255d.%255bAll%2bFund%255d.%255bFund2%255d%26pTimePeriod%3d%255bTime%255d.%255bAll%2bTime%255d%26pTransactionType%3d%255bLedger%255d.%255bAll%2bLedger%255d.%255bGeneral%2bExpenses%255d%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252flocalhost%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d

--Crandaddy

[quoted text, click to view]
AddThis Social Bookmark Button