[RESOLVED] Crystal Report Help

[Naveed_786]

Dear All,

I am new to this forum i have a problem and posting here may be someone would be able to help me.


My problem is this when i want to make a report which has one page for record and second page for instruction.

i have made a report when i run it has one page for records but how to get second page for instruction when designing crystal reports.

[jggtz]

Welcome to CodeGuru Forums !

Would you post the tables' design from where you extract the data, the 'record' and the 'instruction'

[Naveed_786]

I can't see the second page to make headings on it like title ect here is the structure of my table is it possible in crystal report designer so that i could be able to design the second page as i design the first page.


SQL> DESC WO;
Name Null? Type
----------------------------------------- -------- ----------------------------
DISCRIPTION VARCHAR2(200)
REQ_DATE DATE
WO_T VARCHAR2(30)
TASK_PER VARCHAR2(50)
ORIGINATOR VARCHAR2(70)
REQ_DEPT VARCHAR2(70)
EXTENSION NUMBER(10)
CRAFT VARCHAR2(50)
TASK_ASSG_TO VARCHAR2(70)
SCHEDULED_DATE DATE
SCHEDULED_FINISH_DATE DATE
COMPLETION_DATE DATE
ESTIMATED_HRS VARCHAR2(30)
REQ_TYPE VARCHAR2(50)
PRIORITY NUMBER(2)
ITEM_CODE NUMBER(30)
LOCATION VARCHAR2(70)
SUB_LOC VARCHAR2(70)
ADDED_DATE DATE
QTY NUMBER(30)
DONE_BY VARCHAR2(70)
EMP_ID NUMBER(20)
COMP_DU VARCHAR2(20)
COMMENTS VARCHAR2(2000)
PREP_BY VARCHAR2(50)
WO_USER VARCHAR2(30)
WO_NO NOT NULL NUMBER(25)
ITEM_NAME VARCHAR2(100)
REC_COPIED VARCHAR2(15)
REC_ST VARCHAR2(30)
REC_STATE VARCHAR2(30)
INSTRUCTIONS LONG

[jggtz]

Try the next :
Using the Section Expert:
Add another Details Section
You have now 2 Details Sections : 'details a' and 'details b'
In 'details a' you will place all the record's fields except 'Instruction'
In 'details b' you will place only the field 'Instruction'
Using the Section Expert:
Select 'details a' and check 'New Page After'
Select 'details b' and check 'New Page After'

[Naveed_786]

Okay Fine now i have required New Page header before detail section is it possible

I didn't want to print the headings of page header section a???

[jggtz]

As each record is in a single page you can enlarge the sections vertically and add your headers in the same details a & b sections before the data

details a
---------------------------------------
headers here
record fields here
-------------------------------------

details b
---------------------------------------
headers here
instruction field here
-------------------------------------

[Naveed_786]

I have tried but same result can you show some sample Please.

[jggtz]

Say your Crystal Reports' version

[Naveed_786]

I am using Visual Studio 2008 and Crystal are built in visual studio 2008.............

[jggtz]

I'm attaching an example (rpt & mdb)
it's in Crystal Reports 10, I hope that you don't have problems to open

[Naveed_786]

Thanks a lot it worked

I have another problem with connection, when i am trying to connect crystal report with Oracle 9i it produces error please view the image for error detail can you help me please.

[Naveed_786]

Problem has been resolved here the link for the solution any way thanks for your grate help

http://www.oracle.com/technetwork/to...ot_resolve_the