OraFAQ Forum: Reports & Discoverer » Dynamically change the sequence of groups

Home » Developer & Programmer » Reports & Discoverer » Dynamically change the sequence of groups - Reports 6i

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

Dynamically change the sequence of groups - Reports 6i [message #120716]

Mon, 23 May 2005 04:06

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Dynamically change the sequence of groups - Reports 6i

Can is change the sequence of group in a query?
I have to make a report where the user definig this sequence.
Do I have to make the the all variotion of the same report? Sad

Thanks:
Zoltán Patalenszki

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #120765 is a reply to message #120716]

Mon, 23 May 2005 11:08

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Well, the easiest way to do this is with a front-end form. What environment are you running?

You generate a parameter list on the Forms side, pass the values to reports, and reports uses these values to filter data, group data, etc. You would need lexical parameters to accomplish this.

The way I did this was not to have different variations in separate files, but have the variations within the same RDF and suppress/allow with a format trigger over the outermost frame of the different variations.

HTH,
Steve

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #120966 is a reply to message #120716]

Wed, 25 May 2005 04:01

Gurusubramanyam
Messages: 79
Registered: July 2001

Member

Hi,

You can use the lexical parameters in your query to resolve your issue. Pass the parameter value dynamically from your front end form.Don't dispaly the grouping field(Param1) in the report layout.

Please look at the below picture. Hope this will be helpful to you.

Thanks & Regards,
G.S

/forum/fa/177/0/

Attachment: 1.jpg
(Size: 42.50KB, Downloaded 1674 times)

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #120981 is a reply to message #120966]

Wed, 25 May 2005 05:09

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi,

I uploadaed my sample data modell.(datamodell.bmp)
/forum/fa/178/0/

I have 3 groups (g_torzsszam, g_vberk_gszf_szakfkod, g_vberk_tema_temaazon).
I have to variable their sequence order in the layaout modell.
My user will determine this sequence.

Thanks
Zoltán Patalenszki

Attachment: datamodell.bmp
(Size: 245.17KB, Downloaded 1790 times)

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #121006 is a reply to message #120981]

Wed, 25 May 2005 06:48

Gurusubramanyam
Messages: 79
Registered: July 2001

Member

Hi,

Can you please provide some more input?

All the three goup names will be dynamic? How the user is selecting the groups in your front end?

can you please paste the sql also.

Bye,
G.S

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #121018 is a reply to message #121006]

Wed, 25 May 2005 07:41

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi,

I didn't understand your solving at first,
but It's a very good idea.
I will make 3 lexical parameters and 3 group for them.

In my front-end the user will order the groups.

Thanks&Regards
Patalenszki Zoltán

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #121024 is a reply to message #121018]

Wed, 25 May 2005 08:02

Gurusubramanyam
Messages: 79
Registered: July 2001

Member

Hi,

You are right. You can create 3 lexical parameters and pass the values dynamically. Hope this can sove your problem.

Bye,
G.S

Report message to a moderator

Re: Dynamically change the sequence of groups - Reports 6i [message #121046 is a reply to message #120716]

Wed, 25 May 2005 09:24

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

That's cool! I didn't know you could upload snapshots! That makes this whole thing a lot easier!

Thanks!

Steve

Report message to a moderator

One more question....(I'm voracious) [message #121130 is a reply to message #120716]

Thu, 26 May 2005 05:29

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi,

Can i skip the third group in the same report?
It would be a new choice to our users.

Zoltán Patalenszki

Report message to a moderator

Re: One more question....(I'm voracious) [message #121131 is a reply to message #121130]

Thu, 26 May 2005 05:53

Gurusubramanyam
Messages: 79
Registered: July 2001

Member

Hi,

Can you please try with format trigger in the layout. I think you can.

Bye,
G.S

Report message to a moderator

Previous Topic:	printing report
Next Topic:	If i use Graph and image together in Oracle Report9i then Display of Graph is not clear

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 01:48:36 CST 2025