How to show SUBREPORT when no data is returned.

I have a subreport within the details section of my main report. This is enclosed by a single group. When I preview the subreport alone, it diplays the subreport correctly with no data (meaning it still displays the header and footer without a detail section). When the subreport is run within the main report and no subreport data is returned the subreport does not show.

Based on other threads I understand that the default functionality is to display headers and footers when no data is returned. This appears accurate except on a subreport.

Would the "no rows"-property help you? there you can define a message that is shown when the subreport has no rows..|||

I fixed this by returning a row of nulls in my return dataset when no records where found. Works.

How to show SUBREPORT when no data is returned.

I have a subreport within the details section of my main report. This is enclosed by a single group. When I preview the subreport alone, it diplays the subreport correctly with no data (meaning it still displays the header and footer without a detail section). When the subreport is run within the main report and no subreport data is returned the subreport does not show.

Based on other threads I understand that the default functionality is to display headers and footers when no data is returned. This appears accurate except on a subreport.

Would the "no rows"-property help you? there you can define a message that is shown when the subreport has no rows..|||

I fixed this by returning a row of nulls in my return dataset when no records where found. Works.

How to show multiple main reports with their subreports one set by

Hi,
I have made a SQL Reporting Services report with the subreport. I need
my report to show multiple records with their subreport at the same time.
At now, I can generate multiple main reports altogether and then they are
followed by the subreport with multiple subreport details. It's just like
the following:
1st Page: 1st record in the Main report
2nd Page: 2nd record in the Main report
3rd Page: 1st Subreport detail (use Table object)
2nd Subreport detail (use Table object)
Inside the table of the 3rd page, it shows the 1st
Subreport details and then 2nd Subreport details.
What I actually need is I want my report to show one record in the main
report and then followed by the corresponding subreport details, then next
page for the next record in the main report and then followed by the
corresponding subreport details.
1st Page: 1st record in the Main report
2nd Page: 1st Subreport detail
3rd Page: 2nd record in the Main report
4th Page: 2nd Subreport detail
Is there anyone who can help me to solve this problem ?
Thanks in advance.
RogerHave you tried putting your subreport inside a table cell? The table could
contain your main rows and your subreports inside the same table as
repeating elements.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Roger" <Roger@.discussions.microsoft.com> wrote in message
news:17AC53EB-D966-476E-8B86-30B0864DE28B@.microsoft.com...
> Hi,
> I have made a SQL Reporting Services report with the subreport. I
> need
> my report to show multiple records with their subreport at the same time.
> At now, I can generate multiple main reports altogether and then they are
> followed by the subreport with multiple subreport details. It's just
> like
> the following:
> 1st Page: 1st record in the Main report
> 2nd Page: 2nd record in the Main report
> 3rd Page: 1st Subreport detail (use Table object)
> 2nd Subreport detail (use Table object)
> Inside the table of the 3rd page, it shows the 1st
> Subreport details and then 2nd Subreport details.
> What I actually need is I want my report to show one record in the
> main
> report and then followed by the corresponding subreport details, then next
> page for the next record in the main report and then followed by the
> corresponding subreport details.
> 1st Page: 1st record in the Main report
> 2nd Page: 1st Subreport detail
> 3rd Page: 2nd record in the Main report
> 4th Page: 2nd Subreport detail
> Is there anyone who can help me to solve this problem ?
> Thanks in advance.
> Roger
>

How to show data at the bottom with multiple section?

I have three report footer setion. The first two section has a subreport in it. The last section has the grand total of a amount to both of the subreports.

I want to be able to show all three of these report footer section at the bottom of the page.

I have try the PrintAtBottomOfPage properties. I set it to TRUE to all of the report footer section. When I run the report, each section just shown on it own page.

Is there is a way to have all three section onto one page and on top of each other, not overlaying each other or showing on it own page?HI,
PrintAtBottomOfPage prints on the each pages bottom, so when this works
it still shows inside the Subreports bottm, if u want to get a value from sub report to main report use

1. Have a SHARED Variable(s) in a formula(s) for each of u r subreport(s)
2. Place those above the subreport(s) in the main Rpt, preferabblyy in the main reports header
3. in side the Subreports use a formula to sum u r values using
WhilePrintingRecords function to a varible u have declared 4 that Rpt.
(do this to u r all sub reports), place this formula in u r detail line of records printing (supress it, coz u need only the final answer).
4. in the main report sum the variable of sub reports declared in the main
or show seperatly as u wish in u r footer of main.

Favaz.|||I just want all three of the report footer section to be shown on the bottom of the same report of the first page and the subreport has the ability to GROW if there is a lot of data.

I just want all of the three report footer section to be all in the same page with my DETAILS section and just one page will be printed out.

I will not be pulling any variable from the subreport.|||Ummm .... I'm also having the same problem as his. Does anyone know the answer to his question?

please reply!

How to Share Subreport Data with the Main Report

I'm having trouble passing a record from a subreport to the main report is CR X any help would be greatly appreciated.This can be done using shared variables.Same shared variable has to be declared in main as well as sub report and in sub report the variable can be assigned the value to be passed to main report which will be accessible in the variable after the sub report.

How to share parameter value between main and subreport?

Hi All,

I am really lousy when it comes to creating reports. So I am seeking your expert advise/experience.

I have a report that uses a stored-procedure as its data source. This procedure has a parameter. Within this report, I created a subreport which also sources to yet another stored-procedure that also has a parameter which expects the same value as the param of the main report.

When I run the report, say in preview mode, I do not want to be prompted with the parameter twice (i.e. once for the main report, and another for the subreport). How can I edit/modify subreport so that in its select or formula it will say something like:

{?@.ParamOfSubReport} = {?@.ParamOfMainReport}

Many thanks in advance.

_msd_You need to use shared variable and you can use it anywhere in the report|||Right click on your sub-report and choose "Change sub-report links".

Example:

"?parameter1" in the main report links to "?Pm-?parameter1" in the sub-report, then choose the field in the datasource that the parameter is tested against.

When you enter the parameter in your main report it will be passed to the sub-report preview also.|||How do I pass a value returned from the stored proc in the main report to the sub report. I'm getting an error "cannot link from stored procedure" when I pass the value from main report to subreport using subreport links.

Immediate response would be appreciated. Thanks.|||Assign value to shared variable and use that in Sub report|||Hi, I saw this old thread and I am working on the same issue. I'm working on a simple dumb shell of a report in Crystal 8.5 as a test for how to pass parameters into a sql server 2000 stored procedure via a subreport. I'd like to deliver this as straight Crystal without using vb or other shells to call the report from.

Eventually I need to modify a copy of a main report with data and about 8 subreports, all pulling from stored procedures using one parameter called ID. I am getting many requests for this ID parameter, for each subreport, even though I am linking the parameters via subreport links.

The subreport wants to link into the stored procedure using the parameter name from the stored procedure, which is @.ID. The main report only wants to give the subreport a subordinate link such as ?Pm-@.ID. I cannot name the stored procedure parameter with a name like ?Pm-@.ID because it violates the rules of transact-sql. It sees the hyphen as a subtraction. I can see the logic of using the same variable names, but how do I get rid of that bothersome hyphen?

I have also tried using shared variables and they connect to the subreport ok, but I'm still not closing the loop by linking into the stored procedure based on the shared variable.

I am trying to use the same information in multiple places without making the user enter the same information over and over again.

Has anyone had this problem before?sql