Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: 30 days report in CR4E 10 days data on each page Post Reply Post New Topic
Author Message
Bill13
Newbie
Newbie
Avatar

Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
Quote Bill13 Replybullet 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 IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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 IP Logged
Bill13
Newbie
Newbie
Avatar

Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
Quote Bill13 Replybullet 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 IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet 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 IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.