Wrox Programmer Forums
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 13th, 2004, 10:36 AM
Authorized User
 
Join Date: Aug 2004
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default split section

I am trying to print phone # list fname,lname,phone number in detail section (database driven). I want cell number and pager number to printed on right side of detail section. How can I do that?

example:
detail section divided into two
partFname Lname Phone # cell #
                                   Fname Lname Cell #

                                   Pager #
                                    Fname Lname Cell #



 
Old October 14th, 2004, 10:59 AM
Authorized User
 
Join Date: Oct 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If I'm understanding this properly, you want the left side of the detail to have only the Name and a main phone number, then the right side to have any cell or pager number.

I'm not certain why you can't just insert the fields into these locations, unless you have a table where you have a phone type and then phone number for each type. If that's the case, you could make a formula where

{@CellNumber}
If PhoneType = "cell" then PhoneNumber

... and insert that into the right side of the report. You could do the same for Pager number and the names as well.

I don't know if I'm fully understanding your question...

 
Old October 15th, 2004, 11:45 AM
Authorized User
 
Join Date: Aug 2004
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have two tables. Employee table and pagers table. I get phone number and cell phone number from employe table. Every employee does not have a cell phone number. I want to display all cellnumber on left side of detail section using (select statement). want to display cell number (using different select statement and subreport)on right side of phone number. same thing with pagernumber (select statement and subreport) on right side of phone number below cell phone number.

 
Old October 15th, 2004, 05:04 PM
Authorized User
 
Join Date: Oct 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Seems like it might be cleaner to pull this off with one query between the two tables using an inner join where the employee table is the main table. If you do that and insert the fields into the areas where you want them, they should have no problem displaying. You can then conditionally format to suppress printing on blank sections.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a CDATA section; add nodeset to CDATA section kssudhish XSLT 3 January 3rd, 2008 07:13 AM
split() darkhalf Javascript 1 October 21st, 2005 11:34 AM
Question on section 2.4 owenjgo23 BOOK: Beginning Visual C++ 6 1 July 11th, 2005 05:03 PM
CDATA section kai77 Beginning VB 6 0 October 31st, 2004 04:50 PM
Section formatting cankalu Crystal Reports 1 May 31st, 2004 07:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.