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!

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

Formatting cross-tab

Status
Not open for further replies.

pl1101

Programmer
Dec 5, 2009
46
I have a report where I only need to display the summary of a part number by date. I created a crosstab using the part number for the row the date for the column and sum(qty) in the summarized section. When I suppress the date label, the report still shows the white space where the date would ordinarily appear. How can I eliminate that white space when I run the report???
Any suggestions would be appreciated!

Thank you in Advance...

Example:
Currently looks like: (Between the lines are what is displayed in the section)
__________________________________________
Part# 1/1 1/2 1/3 (suppressed)
123 5 7 8
336 9 2 4
234 1 4 4
___________________________________________


Need it to look like:

Part# 1/1 1/2 1/3 (suppressed)
___________________________________________
123 5 7 8
336 9 2 4
234 1 4 4
____________________________________________
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top