Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report has prompt to select Report Name 1

Status
Not open for further replies.
Corres

Corres

Technical User
Jun 13, 2006
87
CA
Hello,
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.
 
Sort by date Sort by votes
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.

-LB
 
Upvote 0 Downvote
Dear Lbass,
Smart simple solution, it works well.
Thank you very much! Great to hear from you in five years here. :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
168
DjangMan
DjangMan
D
  • Locked
  • Question
Open a report into Design mode
Replies
0
Views
210
drb1980
D
Kennymc
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
92
Kennymc
Kennymc
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
577
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
483
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top