show details based on the number of levels prompt value

[unknownly]

Hi,

Can any one help me with this.... please.

I have database table where it has data for all level id's and level name's( about 6 levels I will be using in the report) and another table where I have details and totals for codes

I should be prompting my user with Level 1 _id and period and number of levels.

I did the 1st two propmts and it works good. But how do I work with the number of levels prompt( i tired but i don't get How i need to see).

This is how the report looks like: ( with level1_id and period prompts)

Level1_id, Name
|
--Level2_id, Name
|
-- Level3_id, Name
|
--Level4_id, Name
|
--Level5_id, Name
|
--Level6_id Name codes codecount amount
--( codecount, amount I am show it for the roll back of six months based on the user entered prompt)

what I should do is: My user enters the value level of number prompt( say level of number: 4) then I should show thr report for level3_id and level4_id as details.

Is it possible to do so this way...

as of now iam doing 7 group by's(6 level's and on code)

I hope you understand what Iam asking for....Iam very bad at explaining things


Thanks,
sweety

 

[synapsevampire]

They enter 4, and so you show level 3?

This means that you do not want to show any other levels?

You intend to show 1 level up from what's requested?

How does the period parameter get used?

I'd suggest that you show example data, example of parmeters chosen, and example output rather than text descriptions.

Having multiple groups might make sense, then right click each section and select format section->X 2 next to suppress, and code for suppression according to your rules, as in the following for the 5th and above groups:

{?level prompt} > 4

-k

 

[unknownly]

Thank you for responding...

Yeah if the number of levels : 4
then the report should show from level1 to Level3 and show level4 as details( which is codes and count of codes and amount) Period Parameter is getting used in details( code count of codes and amount will be shown for the rollback of six months on the entered period parameter).

 

[unknownly]

Output should like like this

level_1, Level_1name
Level2, Level_2name
Level3, Level_3name

Jan2003 Dec2002 Nov2002 Oct2002 Sep2002
Unit unit_Name code count amount count amount count amount count amount count amount

level4a level_4aname 100 10 $9999 0 0 2 $9999 4 $99999 0 0
level4b level_4bname 200 1 $9999 0 0 2 $9999 4 $99999 8 $999
level4c level_4cname 400 6 $9999 3 $999 0 0 10 $99999 2 $999
level4a level_4aname 600 11 $9999 0 0 2 $9999 4 $99999 0 0

 

[synapsevampire]

You might more simply suppress the group footers if the parameter isn't that levels value, and place the details in the group footers.

Same thing, only easier to implement and manage.

-k

 

[unknownly]

I tried the it but I don't see the output as I need to see it.
This is what Iam doing
Iam grouping by each level( so that will be 6 groups)
then grouping by code( which is 7th group) and placing all the details in the 7 group footer
and have 6 sections of 7th group footer where Iam placing the details accordingly for each level( unit, unitname, code, countcode, amount) and then using the conditional suppress.

What I noticed when Iam trying to suppress

because of level grouping the code group is done multiple times

for the above sample data eg:

for code = 100 and countcode is 10 --> for only level4

but it prints 100 in multiple rows breaking up the code count on all the groups

like

unit unitname code countcode amount
level4 nameAA 100 3 $9999
level4 nameAA 100 4 $9999
level4 nameAA 100 1 $9999
level4 nameAA 100 1 $9999
level4 nameAA 100 1 $9999

any thoughts on how to tackle this case


Thanks,
Sweety

 

[unknownly]

can we controll the way to group details on a prompt value