No records message

[ekta22]

Hi All,

I am using Crystal 10 with SQL 2000 database. I want to display no records found message on my report. I read some posts on this topic but it doesn't seem to be working for me. I have a formula in my report which is total of other formula's on my report. It looks something like this

formula1 formula2 formula3 formula4
20---------7---------3--------10

Formula1 is the sum of formula2, 3 and 4. I want to display "No records found" message on my report if formula1 = 0. Right now crystal just skips it and moves on to next group. I would appreciate any help.

 

[GJParker]

You are goping to have to be more prtecise here on your report layout and grouping.

What do you mean by crystal just skips it ? is that a technical term ?

Please help us to help you.



Gary Parker
MIS Data Analyst
Manchester, England

 

[ekta22]

ok, I have 5 grouping on my report. Region, sector, interval, area and crewunit. Interval grouping is 2 kinds -Less than weekly and greater than weekly. I want to display "No records found" message for an interval if the value for formula1 for an area is 0. Here is some sample data.

Region: Central
Secotr: 11
Interval: Weekly or Greater (this is based on a formula)
Area: Area1

crewunit   Formula1 Formula2 Formula3 
AAA           2       0         2

----------------
Next page
Region: Central
Secotr: 11
Interval: Less than Weekly(this is based on a formula)
Area: Area2

crewunit   Formula1 Formula2 Formula3 
AAA          1         0         1
BBB          8         5         3
CCC          25        22        3

----------------
Next page
Region: Central
Secotr: 11
Interval: Weekly or Greater(this is based on a formula)
Area: Area3

****No records fouond****

Right now it doesn't display the above page for area3 at all and moves on to the next region, sector, interval etc. As i said above, formula1 is the sum of formula2 and formula3. Formula2 and formula3 again are formula's that sum up the number of records found in the database based on certain criteria.

 

[ekta22]

Anyone.

I placed "No records Found" text box in my area footer and then rightclick -Format Text -Supress x+2
not isnull({@Formula1})
but this doesn't seem to do anything. I would appreciate any help.