Subreport display 1

[Crystaluser66]

I have 4 columns and data is like this

customer customer salesrep
account Name code type

4845667343 frank 667 Adjournal1
leone Adjournal2 Detailsa

----------
Insert1
Insert2 Detailsb

2343556778 John 931 Adjournal7 Detailsa
Wright
-----------
Detailsb

6733223456 Sean 543 Detailsa
Rimmer
------------
Insert7 Detailsb
Insert8


Type could be ads or inserts.for ads there is a subreport in details sectiona and also a subreport for inserts in details sectionb.
Both subreports are linked to salesrepcode.
each of the subreports can have one,none or many values.
The problem is that when there is no Adtype,the subreport is going to display a blank value for the customer account,customer name and salesrepcode and then start displaying insert type in the nest line.
So if there is no adtype,insert type should be displayed on the same line as customer account,customer name and salesrepcode.

Thanks

 

[Madawc]

If you have Crystal 9 or higher, you can put subreports in their own section and suppress it when blank.

If you use Shared Variables you can pass back an indicator that can be read in a later section. You should be able to have a section that does the display you want when the subreport is blank.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Crystaluser66]

I am using 11,not using shared variables,But I want to display Ads and inserts in 1 column and not in 2 columns.
Thank you

 

[lbass]

Assuming that the account, customer name, and salesrepcode are in the main report, insert a group on account, and then place those three fields in the group header. Format the group header to underlay following sections, and format the subreports to "suppress blank subreport" and format both detail sections to "suppress blank section".

-LB