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

x
?
Solved

Profit and Loss Statement - Question in Crystal Reports -

Posted on 2012-03-21
1
Medium Priority
?
806 Views
Last Modified: 2012-03-21
Balances.rptI want to do some basic math and put it in my report.  I created the formula and got to it work but I only want that field to be visible in a certain area and hide it in all the other places.  

Michael or James if you are out there....... I want to do some calculations to my Group 1 but I only want it to show in that particular section.  For instance I want to calculate my total sales and show that under INCOME but I don't want this to show under COST OF GOODS SOLD, SELLING EXPENSES, OTHER INCOME, etc.    I will then have a different calculation for each of those individually.  

Again, I'm trying to make this report similar to the Excel version I will attach.
January-2012-P-and-L-Statement.xls
0
Comment
Question by:ITworks
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 37749327
You can have a formula on the report and conditionally suppress it based on a field name.

Put the INCOME formula on the report
Right click it
Click FORMAT FORMULA
CLick the COMMON tab
Click the formula buttonto the right of SUPPRESS
{GroupNameField} <> 'INCOME'

Similarly for the other formulas

mlmcc
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

872 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