Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!

*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.

Students Click Here

Report has prompt to select Report Name

Report has prompt to select Report Name

Report has prompt to select Report Name

Starting with SAP BO Crystal Reports for Enterprise.

Please give me idea how to update existing report in the way the client wants. The client wants to have a report prompt where the user will choose Name1 report or Name2 report to be displayed. Name1 is the existing report. Name2 is the existing report without one column.

I think that I should create two sub reports. One of the sub reports would be a copy of the main report (Name1 in prompt). Another is the copy of the main report without a column as requested (Name2 in prompt). I assume that the main report should be suppressed.

Give me idea please how to "connect" these two sub reports to the prompt.
Thank you.

RE: Report has prompt to select Report Name

You could instead conditionally suppress the column and its heading for Name2 using the prompt {?WhichReport}, which would have two options: Name1 and Name2.

Select the column/heading and right click->format field->suppress->x+2 and enter:

{?WhichReport}=“Name2” //replace my quotes with your own quotes if copying

If the issue is that you need to change the column layout for the desired view, you still don’t need a subreport. You can add an additional page header section and an additional detail section. Then copy the fields from the original report and paste into the new sections and rearrange them. Then conditionally suppress the sections by going into the section expert and using formulas like the above to suppress conditionally suppress the Name1 sections and the Name2 sections.


RE: Report has prompt to select Report Name

Dear Lbass,
Smart simple solution, it works well.
Thank you very much! Great to hear from you in five years here. :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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! Already a Member? Login

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