<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
SSRS 2008 Sub reports
11 posts, Page 1 of 2
1
2
»»
SSRS 2008 Sub reports
Rate Topic
Display Mode
Topic Options
Author
Message
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:23 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, January 12, 2011 7:32 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376,
Visits: 9,584
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
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:34 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
sorry forgot to include the error message again :)
" error subreport can not be displayed"
Post #1046484
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, January 12, 2011 7:39 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376,
Visits: 9,584
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
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:47 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, January 12, 2011 7:52 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376,
Visits: 9,584
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
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:53 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
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
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:57 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
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
rkaria
rkaria
Posted Wednesday, January 12, 2011 7:59 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 25, 2013 7:15 AM
Points: 88,
Visits: 186
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
Sunil Chitrapu
Sunil Chitrapu
Posted Thursday, September 22, 2011 11:24 AM
Forum 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 »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
