Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Error:Subreport could not be shown
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

ntswakisto
Starting Member

South Africa
33 Posts

Posted - 07/16/2009 :  06:44:39  Show Profile  Reply with Quote
hi

I am trying to add a SubReport to the Main Report,,it's my first timr doing this so I am not sure how to add data or make report work..

I went to design view of main report and clicked subreport from Toolbox and dragged the subreport to the design view... then clicked subreport properties for report name and don't know what to do next on parameters.

when i preview the report ..under Subreport I get Error:SubReport could not be shown....

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 07/16/2009 :  13:44:54  Show Profile  Reply with Quote
have you tried viewing the report that you're refering in main report first? is that report rendering correct? also what are its poarameters and default values? you need to give this in subreport properties of main report
Go to Top of Page

ntswakisto
Starting Member

South Africa
33 Posts

Posted - 07/17/2009 :  06:01:44  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

have you tried viewing the report that you're refering in main report first? is that report rendering correct? also what are its poarameters and default values? you need to give this in subreport properties of main report



Hi

My query for main report looks like this is a pivot query.....

Select PackingSlipDate,Units,[Bag],[BoxAA],[BoxFX],[EmptyStand],[FullStand],[Other],
[PullFrame],[Rods],[StandComp],[TpPullFrame],[Tracks]

From
(
SELECT HHCT.ContainerType,
convert(varchar(10),JMPSH.CreateDate,111) + ' ' + '(' + Datename(Weekday,convert(varchar(10),JMPSH.CreateDate,111))+ ')' as PackingSlipDate,
Count(JMPSH.pkPackingSlipID) AS Total,Sum(Sum(JMPSH.Items)) Over (Partition By convert(varchar(10),JMPSH.CreateDate,111) + ' ' + '(' + Datename(Weekday,convert(varchar(10),JMPSH.CreateDate,111))+ ')' ) as Units

FROM Cetus.dbo.JMPackSlipHeader as JMPSH

INNER JOIN Cetus.dbo.HHContainerType as HHCT ON JMPSH.fkContainerType = HHCT.pkContainerTypeID

INNER JOIN usCustomers.dbo.Customers As C ON JMPSH.CustomerID = C.CustomerID

Where JMPSH.CreateDate >=@startdate AND JMPSH.CreateDate < dateadd(day, 1,'2009/06/10')

and C.MerchPreference = 'Y'

GROUP BY HHCT.ContainerType,convert(varchar(10),JMPSH.CreateDate,111) + ' ' + '(' + Datename(Weekday,convert(varchar(10),JMPSH.CreateDate,111))+ ')'

) AS S

PIVOT

(
Sum(Total)
FOR ContainerType IN ([Bag],[BoxAA],[BoxFX],[EmptyStand],[FullStand],[Other],[PullFrame],[Rods],[StandComp],[TpPullFrame],[Tracks])
) AS P
ORDER BY PackingSlipDate


In the Subreport I need to show sum ot total Pivoted columns...
do I use the same parameters as the ones in the main report and do I need to create a new dataset for the Subreport?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 07/17/2009 :  14:17:36  Show Profile  Reply with Quote
you need to create a report first to display for subreport and then call this from subreport tool of parent report. the parameters passed depends on parameters you created for report.
Go to Top of Page

ntswakisto
Starting Member

South Africa
33 Posts

Posted - 07/21/2009 :  08:56:44  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

you need to create a report first to display for subreport and then call this from subreport tool of parent report. the parameters passed depends on parameters you created for report.



Help....please.
I have created a report for subreport but when I add the report to the main report it doesn't want to show still....How do I add parameter values or make the report display?
Go to Top of Page

ntswakisto
Starting Member

South Africa
33 Posts

Posted - 07/22/2009 :  06:01:09  Show Profile  Reply with Quote
quote:
Originally posted by ntswakisto

quote:
Originally posted by visakh16

you need to create a report first to display for subreport and then call this from subreport tool of parent report. the parameters passed depends on parameters you created for report.



Help....please.
I have created a report for subreport but when I add the report to the main report it doesn't want to show still....How do I add parameter values or make the report display?




I managed to add parameter values to subreport and it is showing in the main report ...thanks.....
Go to Top of Page

tahseenm
Yak Posting Veteran

USA
63 Posts

Posted - 08/07/2009 :  13:08:02  Show Profile  Reply with Quote
What I did is that I create a new report which is actually a subreport and name it and save it in the same project. Then click on the subreport you created and drag and drop in to your main report. Before you drop the subreport create a table from the toolbox and put this subreport in to this table. Once you drop the subreport in to the table any field then click on the report and right click/properties/name the report/click parameters/select the primary key or id#/click ok and you are done. Click preview on your report and see it works. Let me know if this works. Thanks!



I am trying to add a SubReport to the Main Report,,it's my first timr doing this so I am not sure how to add data or make report work..

I went to design view of main report and clicked subreport from Toolbox and dragged the subreport to the design view... then clicked subreport properties for report name and don't know what to do next on parameters.

when i preview the report ..under Subreport I get Error:SubReport could not be shown....
[/quote]

moetahsen
Go to Top of Page

tahseenm
Yak Posting Veteran

USA
63 Posts

Posted - 01/04/2017 :  13:30:11  Show Profile  Reply with Quote
I am trying to run this stored procedure manually to output a csv file, but its running for ever. Normally it takes about from 30 sec to 1min 30 sec the max. I am having this issue since 3 weeks and my finance dept. cant have any csv reports to get. I am not getting any errors. We are using SQL 2005 server. Can anyone let me know what to do to fix this issue. Any help is appreciated. Thanks and this site is awesome and always my issues get resolved. Thanks a lot.

moetahsen
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000