Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Solved
Shared Variable from Subreport to Main report
Posted on 2008-10-15
I have a report with about 5 details sections which are for the most part subreports. I have created a subreport which is retreiving survey information for incidents. The survey report displays the results of the survey in a summarized format as there are multiple questions. I created a shared variable in the subreport as follows:
WhilePrintingRecords;
Shared numberVar TotalYes1 := {@Sum Comment1}
I then created a formula in the main report with the following details
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1
I placed this formula in a details section that I added below the details section that has the subreport. The problem I am getting is that the shared variable (likely the first one evaluated) is appearing in the details section of the report however it is appearing for every detail record that appears even if there are no subreport results?
Any help is appreciated.
WhilePrintingRecords;
Shared numberVar TotalYes1 := {@Sum Comment1}
I then created a formula in the main report with the following details
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1
I placed this formula in a details section that I added below the details section that has the subreport. The problem I am getting is that the shared variable (likely the first one evaluated) is appearing in the details section of the report however it is appearing for every detail record that appears even if there are no subreport results?
Any help is appreciated.
2
3 Comments
Active today
You need to conditionally suppress the value.
You could suppress if 0 - check the FORMAT FIELD --> Number
Custom format
Another way would be to reset the value before the subreport to say -1 then you suppress if it is still negative.
In the first detail sectiion before the subreport
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1 := -1;
''
Conditionally suppress the display formula
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1 = -1
mlmcc
You could suppress if 0 - check the FORMAT FIELD --> Number
Custom format
Another way would be to reset the value before the subreport to say -1 then you suppress if it is still negative.
In the first detail sectiion before the subreport
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1 := -1;
''
Conditionally suppress the display formula
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1 = -1
mlmcc
Why would i need to supress the value? If the subreport is empty, would it not pass an empty string or not do anything?
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Crystal Reports: 5 Tests for Top Performance
It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.
…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …
Suggested Courses
Course of the Month3 days, 21 hours left to enroll
589 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.