Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Jefftopia (Programmer) (OP)
6 Aug 02 17:41
I have a cross-tab which is either going to be populated with percentages or currency values (depending upon user selection).  When currency values are being loaded into the cross-tab I would like it to show row grand totals, but in those cases where percentage numbers are being loaded into the cross-tab I would like to suppress row grand totals. I have a field in the table the cross-tab is derived from which contains either a "N" for currency fields and a "P" for percentage fields.

IS THERE A WAY TO SUPPRESS ROW GRAND TOTALS AT RUN-TIME IN THOSE CASES WHICH THE USER IS LOADING PERCENTAGE NUMBERS INTO THE CROSS-TAB?
rogar (Programmer)
6 Aug 02 18:00
Make two cross-tabs in two sections and suppress one or the other based on the user selection
Jefftopia (Programmer) (OP)
6 Aug 02 18:04
I had considered that but I have no idea how to suppress a cross-tab based on users selection.  Wouldn't even know were to start.  Thx though.
rogar (Programmer)
6 Aug 02 18:29
Conditionally suppress the section. In the Section Expert, select the section and click the x-2 button next to "Suppress".  Enter a formula which evaluates to True for the condition that will suppress the section,
e.g. {?UserOption} = "Percentage"
Jefftopia (Programmer) (OP)
7 Aug 02 12:11
Thank you rogar.  Excellent solution.  Familiarized my with the whole x-2 button concept.

My subreports are supressing sections as they should but my main report shows an empty box where the subreport would go.  If you know a way around that, great, otherwise I may just eliminate the gridlines around the report.

thx again
rogar (Programmer)
7 Aug 02 16:05
To get rid of the box, right click on the subreport object (on the main report design) and select Borders; then set all borders to "None".  Make the subreport object and the section it is in as small as possible.  You can suppress all the sections of the subreport in the subreport design (if you don't want to see them), but if you suppress the section of the main report that holds the subreport, the subreport will not be executed. The best you can do is to make it as small as possible, or to select "Underlay following section" in Section Format.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close