SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2008 Sub reports


SSRS 2008 Sub reports

Author
Message
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28841 Visits: 9671
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.
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 193
sorry forgot to include the error message again Smile

" error subreport can not be displayed"
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28841 Visits: 9671
rkaria (1/12/2011)
sorry forgot to include the error message again Smile

" error subreport can not be displayed"



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


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.
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28841 Visits: 9671
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
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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??
rkaria
rkaria
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 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
Sunil Chitrapu
Sunil Chitrapu
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search