Impromptu Prompt problem

[aa44]

Hi ,

I created a prompts on Impromptu6.0 , That prompt
retrives the dept code data as per the database and it
shows when open the report, what would like to do is
i want to show important deptcode first and then
remianing dept code is it posiible on Prompts .

Here is the data :

detptcodes in the database:
Auto Mobiles
Finance
IT
Real Estate

Desired result

IT
AUTO MOBILES
FINANCE
---

Could you please hel me out


Thanks
Khanna

 

[griffindm]

Impromptu cannot do this on its own. It is possible within a macro however.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[aa44]

Could you please give some hints how to code in macro .

Thanks
Khanna

 

[griffindm]

There are excellent examples in the on-line documentation.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[umag]

create a sort order column in your database and assign values to it the way you want, then your display will be in that order like

IT 1
AUTO MOBILES 2
FINANCE 3

or if you can't add a column to your database table create a separate sort order table in databse which gets data(dept) from main table and assign a sort order code. Use this table in your impromptu.

 

[aa44]

Hi ,

I created sort order in the database level , i assign the values to the table and then i am trying to access that
table in the impromptu but it showing ascending order instead of descending order. i tried many ways to get that in descending order but in vain .Apparantly in the impromptu report level when i creating prompt i found there
is check box " Sort values " was automatically selected .

could you please help me out

Kanna