SSRS 2008 Sub reports

Question

SSRS 2008 Sub reports

rkaria

Ten Centuries

Points: 1363
More actions
January 12, 2011 at 7:23 am

#230284

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

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

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 Ten Centuries Points: 1363 More actions · Answer 2

sorry forgot to include the error message again 🙂

" error subreport can not be displayed"

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

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 :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 Ten Centuries Points: 1363 More actions · Answer 4

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 SSC Guru Points: 294069 More actions · Answer 5

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 Ten Centuries Points: 1363 More actions · Answer 6

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 Ten Centuries Points: 1363 More actions · Answer 7

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 Ten Centuries Points: 1363 More actions · Answer 8

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 Newbie Points: 7 More actions · Answer 9

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

iram.younis SSC Rookie Points: 41 More actions · Answer 10

Just incase anyone is still looking at this.

I had the same problem as above.

I then created a shared data source and created my main report and subreport so they were using the same shared data source.

It seemed to fix the problem for me.