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
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
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.
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
