OraFAQ Forum: Reports & Discoverer » how to make a report manullay

Home » Developer & Programmer » Reports & Discoverer » how to make a report manullay (oracle 8i form 6.0 win xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to make a report manullay [message #288833]

Tue, 18 December 2007 21:40

orarep
Messages: 56
Registered: September 2007

Member

hello everyone

i made a simple query in report and then try to display it's result in report but how i should make it display as i can't use the report wizard

what i did.

1. creat a field mannualy and name it 'F_std_name'
2. give it's source as the column name in the query
3.then i took a frame and enclosed the field 'F_std_name'
4. then i enclosed the whole thing by a repeating frame and give it's source as the record gp 'R_g_std'

but when i run it it says the common error
"field F_std_name references col name at frequency below...

so where i am wrong

plz guide

regards

Report message to a moderator

Re: how to make a report manullay [message #288857 is a reply to message #288833]

Tue, 18 December 2007 23:34

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

its mean your field source column is not present in the source you used for repeating frame.
check it again.

Report message to a moderator

Re: how to make a report manullay [message #288884 is a reply to message #288833]

Wed, 19 December 2007 00:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

orarep

... as i can't use the report wizard

Just being curious: why?

Report message to a moderator

Re: how to make a report manullay [message #289732 is a reply to message #288884]

Tue, 25 December 2007 23:12

orarep
Messages: 56
Registered: September 2007

Member

because i should know and there are times when you need that now in my case i need it how?

i have report comprising 12 queries and now when i almost finished so then some last changes and that require another small query to be the part of this report. say it is
"select "hello world" from tab1" now if i run the wizard so the whole format will distorted and i have already taken enough time on it's format so plzz tell me how i will incorporate the label "hello world". in my case it is basically a lablel so now it query so how to do that .

even if it is like that "seelct col1 from tab1" so how to incorporate it plzz tell me that is my prob as i can't run the wizard again and may be there more changes when seen by my client so again?

plz guide

regards

Report message to a moderator

Re: how to make a report manually [message #289845 is a reply to message #289732]

Wed, 26 December 2007 04:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, first you'll have to create a query in the Data Model editor. Then go to Paper Layout editor and create necessary frame(s) and field(s) where appropriate - use Tool Palette to accomplish that task.

By the way, learning how to do that manually is OK when you do it on a simple test report. Messing up with a (complicated?) 12-query report is ... well, not something I'd want to do if I don't know exactly HOW to do that.

Report message to a moderator

Previous Topic:	Opening the report output in CSV format
Next Topic:	Report takes long time to open

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:31:59 CST 2024