| Author |
Message |
Bill13
Newbie
Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
|
  
Topic: 30 days report in CR4E 10 days data on each page
Posted: 25 Apr 2013 at 4:40am |
|
Hi Experts I am using Crystal Report for Enterprise.
I need to make a report in which it is showing data for 30 days. I got 1 query
Dimensions and Day1 to Day 30 Measures
Report lay out should be
First Page 10 records of dimensions and day 1 to day 10
2nd Page 10 Records of dimensions and day 11 to day 20
3rd Page 10 Records of dimensions and day 21 to day 30
4th page next 10 records of dimensions and day 1 to day 10
5th page next 10 records of dimensions and day 11 to day 20
6th page next 10 records of dimensions and day 21 to day 30
………
Any ideas??? Or Solution
Thanks in Advance
|
|
Bill
|
 IP Logged |
|
|
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
|
Posted: 25 Apr 2013 at 4:51am |
|
I would try something like:
in the Group Expert for the section you want to page break.
In the Page Break Before x-1 button:
shared numbervar lastPage;
local booleanvar newPage := false;
local numbervar i := CINT({table.dayField}/10);
if i > lastPage Then(
if i > 2 Then
lastPage := 0
else
lastPage := i;
newPage := true
);
newPage
If I could use a stored proc, I would just put a grouping value in the return set, and just force a page break on the the grouping value.
HTH
|
| IP Logged |
|
Bill13
Newbie
Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
|
Posted: 25 Apr 2013 at 5:13am |
|
Hi
Thank you for your quick reply just one more quick thing my data is in columns
State Day1 Day2 ..........Day30
NY 10 20 40
NJ 20 30 50
DE 30 40 10
Data is in columns and requirement is to show
Page 1
State Day1 Day2 ..........Day10
NY 10 20 40
NJ 20 30 50
DE 30 40 10
Page2
State Day11 Day12 ..........Day20
NY 60 20 2
NJ 70 10 19
DE 80 30 10
Page3
State Day21 Day22 ..........Day30
NY 1 12 17
NJ 2 11 16
DE 3 14 15
Do you still think the solution you have provide will break my results in above format.
|
|
Bill
|
| IP Logged |
|
Sastry
Moderator
Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
|
Posted: 26 Apr 2013 at 12:57am |
|
Hi
I think you are creating a cross tab report to display the results.
Do the following :
Create a formula like :
@group
If {DayField} in ['DAY1','DAY2','DAY3',....,'DAY10'] Then
"page1"
Else
If {DayField} in ['DAY11','DAY12','DAY13',....,'DAY20'] Then
"page2"
.
.
.
.
.
.
"Page10"
Now Insert a group on the above formula and place your cross tab in group header.
After that go in Section expert and paging click on new page after on group header.
|
|
Thanks,
Sastry
|
| IP Logged |
|
|
|
