Show subrepot 1 time! 1

[lutzs]

Hi,

i have a .net application with a crystal report.
There is one table dtt with this fields:
- customerID
- securities
- securitie_text
- others
- ID

The structure of the table is this for example:
customerID securities securtie_text others ID
1 55896 Aktie Prima -- SEC
1 89634 Aktie Super -- SEC
1 -- -- textblabla O
1 -- -- anothertext O
2 77315 Aktie Besser -- SEC
2 -- -- hierstehttext O

Now, i will represent the table with crystal reports.
I grouped the report by customerID.
Now I insert a subreport "securities" in Detail a.
I see the securites and securitie_text for each customer with ID = SEC (SELECT- Expert).
The problem is: There are 2 entries for customerID 1.
The subreport is also two times indicated.
How can I employ it that the subreport "securities" is only once indicated?

Thanks, Stephanie

 

[cmpgeek]

have you tried putting the subreport in the group footer? i think that is what solved the problem i was having last week...

hoep that helps ShannonLea

 

[lutzs]

Thank you! It works fine.

But now, I have a lot of blank sections.
For example: there are 5 emtpy sites and on page 6 is the
subreport.
I have activated the functions: "suppress blank sections" in the section expert and "suppress blank subreport" in the subreport properties.

What can I do?

Stephanie

 

[Madawc]

I'm not totally clear about your problem. If it's about supressing blank subreports, I know how to do this.

Crystal has its own unalterable sequence of actions. For a given section, it will do the 'suppress blank' tests before it processes the subreport. There is no way to stop it doing this.

A 'work-round' is to put a dummy version of the subreport in a higher section, such as the header. Left-click and use Format Field to suppress this dummy, but have it return a value that tells you whether the subreport will be blank.

In the section with the real subreport, do a conditional suppress based on the returned subreport. Madawc Williams
East Anglia
Great Britain

 

[cmpgeek]

when you say you have tried the suppress blank sections option - have you tried that on both the main report and within the subreport?... ShannonLea

 

[lutzs]

Thanks! It works fine.
When I suppress the details section there aren't blank sites.