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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress subreport printing but keep the data 1

Status
Not open for further replies.
PhilDean

PhilDean

IS-IT--Management
Dec 6, 2005
8
US
Anyone know how I can retrieve data in a subreport and pass it to the main report and yet supress the printing of a line on the report? I have tried all of the suppress and hide options. And the smallest height acceptible is .04.
thanks,
 
Sort by date Sort by votes
Dear Phil,

You do not provide enough information.

What is the purpose of the subreport (does it run for each row, the entire report, a group ...

What version of Crystal?

ro

Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762
 
Upvote 0 Downvote
Thanks Rosemary...
Crystal v9. The subreport is in the group3 level and provides data for the accummulation of totals for the group. The totals are printed in the group2 footer.
 
Upvote 0 Downvote
Dear Phil,

The subreport doesn't have to be on a line on it's own, you could try making it a small "box" that you place in the left of where the retrieved data is required.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762
 
Upvote 0 Downvote
Thanks again, Rosemary.
I have made the box as small as possible. What do you mean by "to the left of the required data"? I have tried in the subreport to place the data to the right of the "box" with no success. Do you mean in the group footer? I haven't tried that yet...
 
Upvote 0 Downvote
Dear Phil,

Yes in the group footer.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762
 
Upvote 0 Downvote
Hi Rosemary,
I don't think I can place the subreport box in the group footer because I need the accumulations that it performs in the detail line for the totals I am then printing in the footer. The subreport retrieves data from another file which is shared with the main report detail section and is totaled for each group and the entire report.

This may further confuse the issue...
Thanks anyway for your interest.
phil
 
Upvote 0 Downvote
Change the color of all the fields in the subreport to white!

Daniela
 
Upvote 0 Downvote
Dear Phil,

I misunderstood. I thought you said the subreport was in the group section.

So you have the subreport in the detail section. Did you create a section and put it there?

Why don't you show a little of the layout of the report, location of the subreport, and what you want to happen. I am a little confused.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762
 
Upvote 0 Downvote
ro,
Sorry, I do have the subreport in a group header. Maybe this will help...

RH
PH
GH1
GH2 - (initialize group2 footer totals)
GH3 - Subreport to retrieve shared data (only need totals)
D - to print detail of data retrieved
GF3 - empty
GF2 - print subtotals of accumulated data for this group
GF1 - print subtotals of accumulated data for this group
RF - print grandtotals of accumulated data

thanks again,
phil
 
Upvote 0 Downvote
Daniela,
Tried that and still creates white space in the report for each access to the subreport.
thanks,
phil
 
Upvote 0 Downvote
Try suppressing all sections within the subreport. Then go to the section expert->section the sub is in->check "suppress blank section". Also go to format->subreport->subreport tab->suppress blank subreport.

-LB
 
Upvote 0 Downvote
LB,
Thanks much. The "suppress blank section" in the section expert for the group header containing the subreport was my problem.
Phil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
199
hilfy
hilfy
Cpreston
  • Locked
  • Question
Printing Slower with added text box 1
Replies
5
Views
216
kray4660
kray4660
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
191
anandm19
anandm19
NBVC
  • Locked
  • Question
Group header on second page not printing when sending to printer, but ok in preview.
Replies
0
Views
94
NBVC
NBVC
elly00
  • Locked
  • Question
printing code 128 barcode
Replies
0
Views
93
elly00
elly00

Part and Inventory Search

Sponsor

Back
Top