Need row index of selected row in Impromptu report

[pugger]

I have an impromptu report with a name field and a hidden field with encrypted SSN's. When a user selects a name I need to retrieve the row index so that I can access the encrypted SSN field in the same row. Ideally, I need both the selected row index and the column index of the encrypted SSN field(but can hard code this if necessary).
Any help would be appreciated.
Thanks

 

[griffindm]

pugger,

You may need to investigate a custom user defined function on the database server. Depending on the RDBMS platform, Impromptu supports these. Check the documentation for additional details. Some of the better users here have experience with them, so after you check out what you can find, come back here with specific questions.

Regards,

Dave Griffin



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[pugger]

Thank you for responding, Dave. I
n leiu of the selected index could I create a macro that creates a row with the record number in it? (Some kind of count). I would want to be able to click on the row number and use "SelectedFrames(1)" to get the row number. I could use this number for the row Index.
-Maureen

 

[griffindm]

Maureen,

That would get you the row number within the report, not to be confused with the row number that may be maintained by the RDBMS. If you are trying to apply logic to decrypt a column in the row that requires the latter, this might not be of much use.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com