473,505 Members | 15,381 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to suppress CrystalReport group section base on summary value

72 New Member
Hi there,

I have records in the form of scorecards. Each scorecard has fields "type" and "score".

eg
typeA 2.3
typeB 3.3
typeA 2.0
typeC 1.9
typeB 1.1
etc

In the CrystalReport I have a group section where I show the average score of each type. I suppress the detail section and put the "average (running total)" ( Average ({ScoreCardTbl.Score}, {@card}) )in the group footer section.

Using the above example the report would show

typeA 2.15
typeB 2.2
typeC 1.9

This much is working already.

How can I suppress an instance of a group if the average score falls outside a range value?? So if I want averages greater than 2 then I don't want "typeC 1.9" to appear.

In the report section suppress fomula I have tried putting eg

Average ({ScoreCardTbl.Score}, {@cardtype}) > 2.0

but it does not work

Can anyone help? Thanks

PS, when posting a question in this forum how can I highlight a block of text, say in a different colour?
Nov 17 '09 #1
0 1687

Sign in to post your reply or Sign up for a free account.

Similar topics

0
5271
by: Matt | last post by:
I am running CR 8.5 from a (large) SQL Server db. My aim is to use crystal enterprise so end users in our sales team can access reports on demand for a given date range and client so I am trying...
0
298
by: Gonzo | last post by:
I have the following code. When I serialize the DriverCollection I would like to get both the Driver Collection and the DeletedItems collection. I end up with only the Driver collection. I have...
2
7136
by: Galina | last post by:
Hello I have a report, which lists records. Each record has money paid field. Money paid can be 0 or not 0. I calculate and print summary of money for a group in the group footer, as well as...
3
1911
by: John M | last post by:
Hi, I must be missing something blindingly obvious. If I don't want a page header to appear on a report header I set 'Not with Rpt Hdr/Ftr' in the report. But I don't want the Page Header...
4
2808
by: Robert | last post by:
Is there some way to suppress the automatic line feed in the detail section of a report in Access? I would like the detail to print out to the right of the existing one. The next line would be...
2
8465
by: Don Wash | last post by:
Hi All! I've been searching everywhere for a simple sample of producing a bar graph using CrystalReport by specifying SQL Query, and I've found none of it! I find so many complex samples with so...
1
4727
by: Eych | last post by:
I have a field which I do not want to put in the Group Header, but keep in the Details section. I selected 'Suppress if duplicated', but it still duplicates. Here's an example: What I want to...
5
1987
by: Chris Szabo | last post by:
Good afternoon everyone. I'm running into a problem deserializing a stream using the XmlSerializer. A stored procedure returns the following from SQL Server: <Student StudentId="1" Status="1"...
1
4323
by: Roshan | last post by:
Hi, I wanted a reliable way of detecting if a given NTAccount object represents a user account or group account. I was using SecurityIdentifier.IsAccountSid() method but this doesn't work as I...
0
7216
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7098
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7303
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7018
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7471
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4699
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3187
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1528
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
754
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.