Hi, I am new to crystal reports and have two parameter field set to Y or N. I want to give user the option to (1)View Section Details (2)Print Section Details. I have went to Section Expert and entered the following code in the section I want to hide conditionally. I don't know what I'm doing wrong, the only thing it will do is suppress on the ?PrintTotals value at the end of the statement. I thought that would only evaluate while printing with the WhilePrintingRecords statement.. If anyone could help I'd appreciate it. I know this is probably something simple but I'm pretty new....
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I guess I'm confused, why is that expression being evaluated before printing then. This code is in Section Expert in the formula section next to Suppress. All's I want it to do is "Only" evaluate when printing. That way the section will be suppressed and not show up while printing.... Right now, it is ignoring WhilePrintingRecords and evaulating prior to printing.. Maybe section expert doesn't recognize this command?
>>> why is that expression being evaluated before printing then
Although the keyword is named "WhilePrintingRecords", it would be more aptly named "WhileRenderingReport". It doesn't matter if you're viewing on screen or on a printed sheet of paper, the results will be same. Sounds like you believe that this is dependent on hitting the PRINT button but that simply isn't how it works.
For what you want to accomplish you just need a single parameter to conditionally suppress. If it's suppressed and you want it printed you'll have to refresh the report and change the parameter value before printing.
Business Accounts
Answer for Membership
by: dougvargaPosted on 2009-02-06 at 12:20:42ID: 23573814
WhilePrintingRecords doens't actually effect what gets 'printed'. "PrintingRecords" is a pass in the crystal reports record evaluation process. Basically, Records get Read into memory and then Printed to the report canvas. Crystal allows the developer to specify if a formula should be evaluated before records get read, while they are read, or while they are printed to the report canvas.
So, if someone is viewing a section on the screen, it is going to get printed. There isn't a way to distinguish via parameter as you are trying to do above.
In your formula, the {?PrintTotals} is controlling what is displayed becuase it is the last statement evaluated in the formula.