Print Page | Close Window

Crystal Report Issue

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14727
Printed Date: 30 Apr 2024 at 6:28am


Topic: Crystal Report Issue
Posted By: Naveed_786
Subject: Crystal Report Issue
Date Posted: 20 Oct 2011 at 8:17am
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.


-------------
Some Thing is Better Than Nothing


Replies:
Posted By: DBlank
Date Posted: 20 Oct 2011 at 8:24am
if your 'instructions' is just text, insert the text/instructions into a group footer (if you want instructions more than once) or the a report footer (if you only want instructions once per report)
In the section expert check the 'new page before' option in either the group footer or the report footer depedning on where you put the instructions

Posted By: Naveed_786
Date Posted: 20 Oct 2011 at 8:32am
Yes my Instructions are in Text format

Actually these instructions are stored in When i enter the Item Code and run the report the first page would display the record and against this item some instructions are stored these instructions should be on next page.

Note: Every item has its own instructions so i can't put it in footer.

So what method should i adopt to achieve this goal.


-------------
Some Thing is Better Than Nothing

Posted By: DBlank
Date Posted: 20 Oct 2011 at 8:36am
so you want all isntructinos for all items printed on that page?

Posted By: Naveed_786
Date Posted: 20 Oct 2011 at 8:39am
Yes When i call one item specifically its own instruction should be printed on next page.

i.e when i call Item1 its instruction should be on next page

and when i call item2 then its instructions should be on next page.


-------------
Some Thing is Better Than Nothing

Posted By: DBlank
Date Posted: 20 Oct 2011 at 9:05am
sorry but you have to be very clear here...so if you call 2 items do you get 4 pages?

Posted By: Naveed_786
Date Posted: 21 Oct 2011 at 7:25am
No no you didn't understand me
Let me clear I have designed a report which have only one page in designer i want to create second page for Instructions.

On second page i should be able to draw a text field. is it possible????


-------------
Some Thing is Better Than Nothing

Posted By: DBlank
Date Posted: 21 Oct 2011 at 12:03pm
If you only have one row per item stick the instructions in a detail b section and make it as a new page before detail b

Or

Do as I said before and group on the item and place the instructions in group footer, new page before set on group footer

Posted By: Naveed_786
Date Posted: 22 Oct 2011 at 12:41am
"If you only have one row per item stick the instructions in a detail b section and make it as a new page before detail b"


Yes this is my requirement can you tell me any link from there  i can study.





-------------
Some Thing is Better Than Nothing

Posted By: Naveed_786
Date Posted: 28 Oct 2011 at 5:07pm
No body has idea about this problem

-------------
Some Thing is Better Than Nothing

Posted By: Robotacha
Date Posted: 29 Oct 2011 at 2:33am
"If you only have one row per item stick the instructions in a detail b section and make it as a new page before detail b"
 
Follow this idea.
 
in design view, RIGHT CLICK on the where it says 'DETAILS' and select 'insert new section'
 
then go to SECTION EXPERT, select details b, and make the sure the 'NEW PAGE BEFORE' is 'checked'
 
 


-------------
Regards,

Michael Jones

Posted By: Naveed_786
Date Posted: 29 Oct 2011 at 6:30pm
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 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



-------------
Some Thing is Better Than Nothing


Print Page | Close Window