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!

grouping by date

Status
Not open for further replies.

crystalbeginner15

Programmer
Sep 6, 2005
76
US
I wrote a report which groups by date

I am passing date as a parameter. When I pass date range
only for one day I get the summary for that date correctly
but when I pass a date range more than one day I get the summary wrong. Example

Date volume1 volume2
01/01 10 10

volume1 - Thats the summary for that date

when I select date range more than a day i get wrong numbers for eg.I should get volume1 as 10 for 01/01 but I get some other numbers .I don't the pattern how I get those numbers
Date volume1 volume2
01/01 20 20
02/01 30 30

Struggling a lot. May be I am missing something. Please help.

Thank you.
 
Posting basic technical information will help a lot, such as:

Crystal verison
Database/connectivity used
Example data
Expected output

Try Grouping by the date, suppress the details section, place the field(s) to summarize in the details section, right click them and select Insert->Summary->Sum and seledct for each group and select the date grouping.

-k
 
Thank you. I got it I was grouping by date by each week that why I was getting wrong number instead I did each day.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top