Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Have to Split a Columns into two pages Post Reply Post New Topic
Author Message
Karty
Newbie
Newbie
Avatar

Joined: 07 Aug 2012
Location: India
Online Status: Offline
Posts: 7
Quote Karty Replybullet Topic: Have to Split a Columns into two pages
     Posted: 21 Nov 2012 at 11:38pm
Hi All,
 
I am Working with Crystal reports XI,
I have multiple columns in my report, I want to split those columns in two pages which is from same table.
 
 Example:
Page1:
UserID  Name      Mail          Phone    Address
100     Karty      xxx@ur.in 12345    YYYYYY
101     Ramesh    rrr@al.in 54321    ZZZZ
102     Vivi          vvv@gl.in 87978    GGG
 
Page2:
UserID  orderID  Amount
100     AR302    1250.00
101     PR222    1788.50
102     QT123    1135.00

I got my output by using supress with mod options:
 
Page1:
UserID    Name      Mail        Phone    Address
100         Karty     xxx@ur.in   12345    YYYYYY
101        Ramesh  rrr@al.in   54321    ZZZZ
102        Vivi        vvv@gl.in   87978    GGG
 
Page2:
UserID  orderID    Amount
103     AAR302     21250.00
104     APR222     11788.50
105     AQT123     21135.00
 
Any idea to solve this...
 
Thanks in Advance
 

Thanks
Karty
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 22 Nov 2012 at 12:03am
Hi
 
Only way to print this is using sub report.
 
Insert the same report as sub report and link your sub report with UserID and display the report in report footer.
 
 
Thanks,
Sastry
IP IP Logged
Karty
Newbie
Newbie
Avatar

Joined: 07 Aug 2012
Location: India
Online Status: Offline
Posts: 7
Quote Karty Replybullet Posted: 23 Nov 2012 at 12:14am
Hi Sastry,
 
Thanks for your  valuable reply..
 
Actually I tried using subreport also but it prints entrie value of details section following that prints subreport values placed in report footer.
 
but i need to print the record's in alternate page as follows
 
Example:
Page1:
UserID  Name      Mail          Phone    Address
100     Karty      xxx@ur.in 12345    YYYYYY
101     Ramesh    rrr@al.in 54321    ZZZZ
102     Vivi          vvv@gl.in 87978    GGG
 
Page2:
UserID  orderID  Amount
100     AR302    1250.00
101     PR222    1788.50
102     QT123    1135.00

Page3:
UserID  Name          Mail                       Phone    Address
103     Kartyjhg       nabsxxx@ur.in    12345     YYYYYY
104     Rameshgh    dfgrrr@al.in         54321     ZZZZ
105     Vivihjg          dvvv@gl.in           87978     GGG

 
Page4:
UserID  orderID  Amount
103     AR302    41250.00
104     PR222    14788.50
105     QT123    10135.00


Thanks
Karty
IP IP Logged
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