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

Cross -tab subreport 1

Status
Not open for further replies.

crystalbeginner15

Programmer
Sep 6, 2005
76
US
Hi,
I am new to Crystal Reports.I am working on a report. I was able to create the main report using cross tab but I am not sure how to create the subreport(may be a cross tab). Some help will be appreciated. Here are the details - We are collecting volume data for all 30 days for 24 hours each day. I got the report for each hour every day and the total also using cross tab.
but for the subreport i need to calculate the the number of Sudays,Mondays........Saturday and the total and average volume for each week day.

Date Day Beginning Hour Total
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
12/12 M
12/13 T
12/14 W
12/15 R
12/16 F
12/17 S
12/18 S
12/19 M
12/20 T
12/21 W
12/22 R
12/23 F
Total

This is the subreport -
Sun Mon Tue Wed Thr Fri Sat
Daily Total
# of Days
Daily Average
 
Insert->group->select the formula.

You could learn a lot by using the CR help files. I have.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top