Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Same report print 3 times in single page Post Reply Post New Topic
Author Message
murthysundara
Newbie
Newbie


Joined: 09 Mar 2010
Location: India
Online Status: Offline
Posts: 5
Quote murthysundara Replybullet Topic: Same report print 3 times in single page
     Posted: 09 Mar 2010 at 3:49am
How to design crystal for printing same invoice 3 times in a single page
 
Advance thanks,
 
regards,
SUNDARA MURTHY S
IP IP Logged
razzak
Newbie
Newbie
Avatar

Joined: 03 Mar 2010
Location: India
Online Status: Offline
Posts: 34
Quote razzak Replybullet Posted: 09 Mar 2010 at 9:15pm

create one subreport invoice and put this invoice report three times in main report.

 
plz let me know whether this helpped you??
 
Razzak Sayyed
IP IP Logged
murthysundara
Newbie
Newbie


Joined: 09 Mar 2010
Location: India
Online Status: Offline
Posts: 5
Quote murthysundara Replybullet Posted: 09 Mar 2010 at 11:57pm
Thanks for your reply.
 
For all sub report, i have used same query..........
 
how to assign sub report links.
 
Thanks,
 
regards,
SUNDARA MURTHY S
IP IP Logged
razzak
Newbie
Newbie
Avatar

Joined: 03 Mar 2010
Location: India
Online Status: Offline
Posts: 34
Quote razzak Replybullet Posted: 10 Mar 2010 at 1:12am
In Main report, right click on subreport-select change subreport links..--then select field (on this field ur subreport will get filterd) click on > button then in "subreport parameter to use " select your subreports parameter click on ok.
 
 


Edited by razzak - 10 Mar 2010 at 1:15am
Razzak Sayyed
IP IP Logged
murthysundara
Newbie
Newbie


Joined: 09 Mar 2010
Location: India
Online Status: Offline
Posts: 5
Quote murthysundara Replybullet Posted: 10 Mar 2010 at 1:37am

All three subreports are same primary key. hence how subreport will get filtered..........

Thanks for your reply.
 
Thanks,
SUNDARA MURTHY S
IP IP Logged
razzak
Newbie
Newbie
Avatar

Joined: 03 Mar 2010
Location: India
Online Status: Offline
Posts: 34
Quote razzak Replybullet Posted: 10 Mar 2010 at 1:45am

how many subreport you have created? i told you to create only one subreport.that subreport will take inv_no as parameter. then pass inv_no from your main report to subreport. it will filter according to inv_no
Razzak Sayyed
IP IP Logged
murthysundara
Newbie
Newbie


Joined: 09 Mar 2010
Location: India
Online Status: Offline
Posts: 5
Quote murthysundara Replybullet Posted: 10 Mar 2010 at 3:04am
In my Main report my Query is
 
SELECT Sys_Inv_Num, Inv_Num, Inv_Date, Cmpny_Name, Addr1, Addr2, Addr3, Part_Code, Part_Desc, Qty FROM tableMain
 
Sys_Inv_Num is Primary Key
 
In my SubReport also using the above query only.
 
How Subreport can filtered on Sys_inv_num
 
Thanks,
 
SUNDARA MURTHY S
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.