[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

2 Subreports sharing the same link to the main report

Posted on 2013-05-20
9
Medium Priority
?
384 Views
Last Modified: 2013-05-23
Previous topic answered : http://rdsrc.us/lCZiFR, and I want to ask if I have 2 subreports and want to share the same link - is this possible. Currently with on linking of the subreport 1 to a field in the main report gives the right value but when I add a second subreport and also share the same link to the same value in the main report my value changes.

Can this be done.
0
Comment
Question by:John-S Pretorius
  • 5
  • 2
  • 2
9 Comments
 

Author Comment

by:John-S Pretorius
ID: 39183252
I actually found by adding another Group Header and placing the second subreport in there and linking to another copy of the same field works without changing the data. Now that I have 2 subreport which I'm 'hiding'. This approach doesn't give me much 'cleanliness' with the spaces between Groups or even when I export to Excel - any suggestions how to make a report with subreport carrying over values look a little cleaner ?

Image
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39183301
Are the subreports blank when they display?
If so you can format them to suppress when blank.  You can also suppress the section when blank

mlmcc
0
 

Author Comment

by:John-S Pretorius
ID: 39184060
The subreports - not blank -  are being 'tweaked' text shrunk to smallest height then I change the color to white.

Suggestions with 'exporting' to excel ?
0
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 300 total points
ID: 39184253
You can't change the exporting to excel.

Why if you don't want the subreport to show anything do you have it display anything?
What is the subreport doing?

mlmcc
0
 

Author Comment

by:John-S Pretorius
ID: 39184270
If I hide the Subreport the values in the main report disappear - Previous question : http://rdsrc.us/lCZiFR - The subreport carry's values over into the main report header, I then have formulas which use these values from the subreport.

Am I doing something wrong maybe ?
0
 

Author Comment

by:John-S Pretorius
ID: 39184288
Below is 'work in progress', I would like to know if I'm maybe doing something wrong here - appreciated.

GALT-Folio-Raw-Local-Complete052.rpt
0
 
LVL 35

Accepted Solution

by:
James0628 earned 900 total points
ID: 39186907
If you're using a subreport just to set some shared variables and it's not producing any output that you need to see on the report, you can't just suppress the subreport, or the section that the subreport is in.  If you do that, the subreport won't be executed and any shared variables in the subreport don't get set.

 What you need to do is:

 Make the subreport not produce any visible output.  The simplest thing is to just suppress all of the sections in the subreport.  Any formulas in those sections should still be evaluated (so the variables should still be set).

 Back in the main report, right-click on that subreport and select "Format Subreport" and on the Subreport tab, check the "Suppress blank subreport" option.

 Go to the Section Expert for the section that the subreport is in and check the "Suppress Blank Section" option.

 If you do that, then the subreport is run and sets the shared variables, but it's blank, so the subreport is suppressed, and then the section is suppressed because it's blank.

 This is what mlmcc was referring to in his first post.

 Obviously, if you have more than one subreport in the same section, you'll need to do the first two steps for each subreport.  And if there are other fields in the same section as the subreport, they'll need to be suppressed, or not produce any visible output, so that the section is blank.

 James
0
 

Author Closing Comment

by:John-S Pretorius
ID: 39189436
Thank you guys, James your explanation describes mlmcc's suggestion perfectly.
0
 
LVL 35

Expert Comment

by:James0628
ID: 39190357
FWIW, I'd have probably given some points, if not most of them, to mlmcc's first post.  That had the basics.

 James
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question