Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSRS 2008 Sub reports Expand / Collapse
Author
Message
Posted Wednesday, January 12, 2011 7:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
Hi,

Im new to BIDS and I have create a main report, I have then created another report and added this report as a subreport.

I have linked the subreport to the main report by right clicking on the sub and properties and then adding the parameters that the main report has.

Is this correct? As when I run the report it is saying error.

The subreport on its own runs fine.

Thanks
R
Post #1046473
Posted Wednesday, January 12, 2011 7:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
What's the error message (sorry but I can't help without that)?

It should be posted in the output list when you run the report... and ususally google helps me figure this out quite easily with that.
Post #1046481
Posted Wednesday, January 12, 2011 7:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
sorry forgot to include the error message again :)

" error subreport can not be displayed"
Post #1046484
Posted Wednesday, January 12, 2011 7:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
rkaria (1/12/2011)
sorry forgot to include the error message again :)

" error subreport can not be displayed"



Wow, looks like an MS Access message got left over in SSRS... I wish it were more vague .


What happens if you run the sub-report only (as if it were a normal report)?


Once that work, maybe we can go back to looking at the link between the 2 reports.
Post #1046486
Posted Wednesday, January 12, 2011 7:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
Thanks for the quick repsonse.

I alerady mentioned in the first post that the sub report runs fine on its own, the field one the subreport returns values.

Im new to BIDS so Im not sure where I am doing something wrong
Post #1046488
Posted Wednesday, January 12, 2011 7:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:44 AM
Points: 21,405, Visits: 9,617
I have to run to a meeting, but I think this can give you some pointers in the mean time...

http://www.velocityreviews.com/forums/t509239-error-subreport-could-not-be-shown.html
Post #1046492
Posted Wednesday, January 12, 2011 7:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
rkaria (1/12/2011)
Thanks for the quick repsonse.

I alerady mentioned in the first post that the sub report runs fine on its own, the field one the subreport returns values.

Im new to BIDS so Im not sure where I am doing something wrong


the parameters on the main report are year, period and bank

So when I right click on subreport and properties, i go to the parameters and put the below

Name Value
Year [@year]
Period [@period]
Bank [@bank]

Is that correct? I've also tried with the brackets but makes no difference.

Thanks

Post #1046494
Posted Wednesday, January 12, 2011 7:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
Thanks, looking at that link you gave me, I added the subreport to another report with no parameter and it worked fine!

So its looks like there is something wrong with the parameters??
Post #1046497
Posted Wednesday, January 12, 2011 7:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:56 AM
Points: 93, Visits: 193
sorry another update, I just deleted the parameters of the subreport and now it is not giving me an error but a value.

But I dont feel this is right when there is no links between the main report and sub report. I will have to do some testings because at the moment it is just giving me 0.00 value.

Ill be back
Post #1046500
Posted Thursday, September 22, 2011 11:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 29, 2011 9:17 AM
Points: 1, Visits: 15
I had the same issue. It only happend in the preview with me, when i deployed the problem is gone.
Try deploying both the reports
Post #1179627
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse