Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ID with front and back templete in Crystal Report

Status
Not open for further replies.

mitchikoy15

IS-IT--Management
May 24, 2011
7
PH
I have only 6 records in my table(maximum), i have 9 columns which is [id], [chapaNum], [Name], [sssNo], [TINno], [PagIBigNo], [prsonToContact], [PrsonContactNo], [PrsonAddress]. I have to get the specific details of each row to make my desired ID output. the id output must have the front and back layout.. And it i requires to print 6 person's IDs in A4 bond paper. Please help me... Thank you in advance
 
Templates in Crystal are used for applying a style to an existing report than offering a standard starting point. Useful if there is some fancy 'house style' that the report needs to conform to after you have got it working. But not if everyone accepts the basic layout that you'd get using the 'Expert' functions. Not like a 'template' in MS Word etc.

As far as I know, you can only apply one template, though it could have a 'front' and 'back'.

If you want to print details of each ID on two pages, right-click on the 'Section' in the left-hand margin and choose 'Section Expert'. Options include 'New Page Before' and 'New Page After', and you can make them conditional using OnFirstRecord and OnLastRecord.

This is based on Crystal 11. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
I never tried the Options 'New Page Before and New Page After'. Thank You for the reply. I will try that.

But for now , i decided to made 2 report printing. One for Front layout and another for back. The problem is, when i extracted data from database in FrontID.rpt and I used the 'Format with multiple Columns' and set it to 'Down then Across' printing of details, and set also the BackID.rpt layout like the front, it will never meet the person who owns the detail...

for example:
frontID:
name1 name4
name2 name5
name3 name6

BackID
Address1 Address4
Address2 Address5
Address3 Address6

..You would realize when you print first the Front on a pc of paper, then print again the back at the same paper at the back, the Address1, Address2, Address3...Address6 will be printed at the back of name4, name5, and name6...name1...

I wish you understand my explanation. Thank you...
I don't know how to make it perfect....
thank you so much =))

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top