Lantica User Forum - Question about reports and date ranges

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Question about reports and date ranges

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Send Topic

Question about reports and date ranges (Read 631 times)

dhopkins Member Offline Posts: 47 Joined: Aug 20^th, 2007	Question about reports and date ranges Oct 9^th, 2007 at 5:39pm	Print Post
	I'm sure the answer to this question is simple, but i'm at a loss. I have a report that lists all of the orders from a certain date. The report has multiple groups A simplified example of the format would be: --------- Daily Report for 10/07/2007 customer \| order Bob \| bob's 1st group of stuff Tom \| tom's 1st group of stuff ------------------------ customer \|order Bob \| bob's 2nd group of stuff Tom \| tom's 2nd group of stuff ------------------------ Simple. BUT, if I run the report for a range of dates by entering '10/01/2007..10/31/2007' into the date field, I get the same formatted report with all the correct entries, except the date printed in the header is the first one retrieved. Example: Daily Report for 10/07/2007 customer \| order Bob \| bob's 1st group of stuff Tom \| tom's 1st group of stuff Bill \| Bill's 1st group of stuff Jim \| Jim's 1st group of stuff ------------------------ customer \|order Bob \| bob's 2nd group of stuff Tom \| tom's 2nd group of stuff Bill \| Bill's 2nd group of stuff Jim \| Jim's 2nd group of stuff ------------------------ I want it to split the report based on the day, Daily Report for 10/07/2007 customer \| order Bob \| bob's 1st group of stuff Tom \| tom's 1st group of stuff ------------------------ customer \|order Bob \| bob's 2nd group of stuff Tom \| tom's 2nd group of stuff ------------------------ Daily Report for 10/13/2007 customer \| order Bill \| Bill's 1st group of stuff Jim \| Jim's 1st group of stuff ------------------------ customer \|order Bill \| Bill's 2nd group of stuff Jim \| Jim's 2nd group of stuff ------------------------ I'm pretty sure this is just a case of me overlooking a feature of Sesame. Does anyone have any ideas? Thanks, Derrick


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2483 Joined: Aug 20^th, 2003	Re: Question about reports and date ranges Reply #1 - Oct 9^th, 2007 at 5:59pm	Print Post
	Hello Derrick, If you have not already, You will want to make sure you attach a sort spec that sorts by the Date element. Which Group Header has the text "Daily Report for" in it? Which ever Group Header that is you will want to click on the title for that Group Header(where it says Group Header 1, Group Header 2, etc. over on the side). That will bring up the report section properties window. Where it says Break Element, choose your Date element. If you are in Sesame 1.X, you will leave the Break Value as 0 If you are in Sesame 2.0, you will set the Break Value as D Those settings will cause that group to break each time the date changes from one date to the next. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

dhopkins Member Offline Posts: 47 Joined: Aug 20^th, 2007	Re: Question about reports and date ranges Reply #2 - Oct 10^th, 2007 at 2:12pm	Print Post
	Hi Ray, Unfortunately, that didnt do what I need. It split the report, but it split them by group. I want it to split by the entire view. That way, all of the groups from a certain day would stay together. Day 1 � Group1 � Group2 Day2 � Group 1 � Group 2 Using the breaks like you suggested, I got Day 1 � Group1 Day 2 � Group 1 Day 1 � Group 2 Day 2 � Group 2 Derrick


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2483 Joined: Aug 20^th, 2003	Re: Question about reports and date ranges Reply #3 - Oct 10^th, 2007 at 2:16pm	Print Post
	Hello Derrick, Are you sure you set the break element to be the date element? It almost sounds like the break element is set to be the Group element. Also you want to be sure that you are sorting by Date first and then by Group second. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

dhopkins Member Offline Posts: 47 Joined: Aug 20^th, 2007	Re: Question about reports and date ranges Reply #4 - Oct 10^th, 2007 at 2:46pm	Print Post
	Since there are multiple groups, I added the break on each one and set it to the Date field in that group. Here's a pic of what I did http://tinyurl.com/2axfdp D


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2483 Joined: Aug 20^th, 2003	Re: Question about reports and date ranges Reply #5 - Oct 10^th, 2007 at 7:40pm	Print Post
	Hello Derrick, Could you send your DSR and DDT files into support@lantica.com so that I can look at the design of the report and see what is causing it to split the data like that? -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Pages: 1

Send Topic

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top