I have a report in which I used the details section to classify my group. I classified the group based on some selection and sorting formulas. I now want to know how many of each type of group that I have based on the classification that I determined. I tried using three running formulas that evaluated only a certain value, but the running total counts the information in the details section so I end up with inflated numbers.
My data is set up like so:
Group Name Group Classification based on detail
So it looks like this with data
case_ID Type A
Case_ID 2 Type B
Case_ID3 Type C
So my goal would be to have a total that tells me that I have one of each type of group. My running totals though are giving me a total of 1 for group A, 1 for group C, but 3 for group B.
Can I do what I want to do here? This has plagued me for sometime and I am at a complete mental block so I am open to any suggestions. I just need to get rid of my inflated numbers and make sure that each case_id (i.e. each group) is only counted once. The difference is about 200 records and it is really messing up my statistics.
Also I have an intermediate level of crystal experience so very explicit instructions in any suggestions would be most appreciated.
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.
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…
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…