Hide Blank Rows

[LynnCR]

I have a report with various grouping levels and detail sections. The problem is that I have blank rows in the detail section. The report looks something like:

Record Label 1 Record Label 2
record1 record1
record2
record3
record2
record3

The report should look like:
Record Label 1 Record Label 2
record1 record1
record2 record2
record3 record3

I have played with the groupings and tried moving the fields to the various groups, but the only way to get all of the data to return is by putting it in the detail section. I can't use a subreport because the report runs too slow.

FYI, I am conditionally hiding some of the data because the report is written from a flat file. The data that is being hidden is creating the blank rows or spaces.

 

[Reebo99]

Unfortunately, I think this is something that can't be solved easily, due to the way you are accessing the data.

When you display information in the detail, it is for each line of data, and if you are hiding data then you will always get blank fields.

If you create a number of detail sections, you can conditionally suppress them so only the correct data shows, but this won't help put different lines of data on the same line.

I'll ponder this one for a bit.....watch this space. Reebo
Scotland (Going mad in the mist!)

 

[LynnCR]

I am playing with the grouping again since you indicated I may not be able to eliminate the blank rows in the detail section.

I have the data being returned correctly but I have the same problem with blank spaces. Is this basically the same problem or can I hide blank rows easier at a group level.

I have suppress blank section checked on each group which eliminated some of the white space but not all.

Now the report is as follows:

Group1
Group2
Group3
Group4

Group 3 Data Group4 Data
record1 record1
record2
record3
record2
record3

I need to eliminate Group 3 blank rows.

Thanks!

 

[Reebo99]

Unfortunately I don't know if what you want to do is possible. It would be more accurate if you showed your example as I think it is being displayed :

Group 3 Data Group 4 Data
record1 record1
record2 (hidden field) record2
record3 (hidden field) record3
record4 record4 (hidden field)
record5 record5 (hidden field)

The problem is, the value in (Group 3 Data.record4) has no right to be displayed in the space left by (Group 3 Data.record2 (hidden field)) as it is not part of record2 data item.

Sorry, but unless anyone else out there can come up with an answer, I think you might have to play with the data outside Crystal Reports then produce the report on the "clean" data.

Reebo
Scotland (Going mad in the mist!)

 

[LynnCR]

OK another question if you don't mind. I can get the formatting and data to return correctly if I insert Group 3 data via a subreport. Problem as I stated before is the speed at which the report runs.

Does anyone know why a simple subreport slows down the report so much. The subreport does not return that much data so I don't understand why there are so many performance issues with using subreports. The main report does return alot of information.

 

[Reebo99]

When you creat a sub report which is linked to the main report, the sub report is evaluated for every change in that link.

Therefore, if you have say 20 results from a group and then the subreport is evaluated 20 times. Reebo
Scotland (Going mad in the mist!)

 

[Reebo99]

Sorry about my severe lack of grammer and spelling, but I think you get the picture.

Reebo
Scotland (Going mad in the mist!)

 

[LynnCR]

Yep, completely understand.

Is there a way though to call the data via a formula through a get statement rather than a subreport.

Something like find the ID of the main record in table or query and return a specific field.

 

[Reebo99]

I haven't found a way yet, but believe me if anyone knows of a better way to returns values without using subreports, I would be very grateful!

Sorry I couldn't give you the answer you wanted.

Enjoy. Reebo
Scotland (Going mad in the mist!)

 

[stevefah]

As far as displaying, try going to your group expert and using "underlay following sections" for the details; if you have
record 1
record 2
record 3
record 4

should return
record 1 record 3
record 2 record 4

See if that helps.

 

[lbass]

Is this a cross-tab report? I'm confused by the horizontal display of group information--whether you are displaying two different groups (3 and 4) or whether you are displaying two instances of the same group (e.g., record label).

But setting aside the grouping for a moment, if you were working with two different fields instead, like
{ice_cream} and {toppings} you could create detail_a for instances of {ice_cream} and detail_b for instances of {toppings} and then for detail_a, use stevefah's suggestion and check "underlay" following section. Separating into two detail sections should allow suppression of the blank sections.

-LB