hide some details

[timida]

Hello,

I have a tricky problem. My report (Impromptu 7.0) contains products, which are sorted and grouped by productgroups.

e.g.:
product 1   price1
product 2   price2
product 3   price3
-----------
footer: group A    total price(1-3)

product 4   price4
product 5   price5
product 6   price6
-----------
footer: group B    total price(4-6)

product 7   price7
product 8   price8
product 9   price9
-----------
footer: group C    total price(7-9)

Now I want to have a prompt (Yes/No) for showing details of group C. If the user choose "No" the details for group C (only for this group!!) should not be displayed - the footer with the sum of the price and some other columns should be displayed. And there should be no space between the two footers:

e.g.:
product 1   price1
product 2   price2
product 3   price3
-----------
footer: group A    total price(1-3)

product 4   price4
product 5   price5
product 6   price6
-----------
footer: group B    total price (4-6)
-----------
footer: group C    total price (7-9)

I know that it is possible to hide all details, but I only want to hide the details of this group. Is there a possibility to do this?

Kind regards,
Timida

 

[drlex]

Conditional formatting on the detail level ought to work:
(?Show group C = 'N') and (Product no. between 7 and 9) : Hidden
lex


soi la, soi carre

 

[timida]

drlex,

thanks for the tip!... shame on me - I already tried to do this with conditional formatting but I forgot to apply the format for all relevant columns.

thanks again
timida

 

[Jontility]

timida:
can you tell me how you imported that your "code" window in here....thanks in advance



John Organ
MIS

 

[timida]

Hi John!

That's quite simple. Write your reply or question and then press the button "preview post", below the preview text there are some editing tips.

Among other things the line:
"Note: When posting programming code, surround the code with the

tags. This will aid in formatting your programming code correctly."

Hope, that this answers your question

kind regards,
timida