Firecat1970
IS-IT--Management
Dear All,
I would like to implement a simple web-based report writer so that for simple query, users can pretty much draw the data they want.
I have read Dave Griffin FAQ which is very useful. I know I can use PowerPrompt to define the WHERE condition of the query. However, is it possible to use PowerPrompt to create a report column list for users to choose. So out of the 30 or so columns I defined in the Catalog, users can choose the columns he/she wants to see in the report output.
Of course, I expect the report to be in simple tabular format only but that's okay as long as users can choose the columns, sorting, grouping and filtering via PowerPrompt.
My question again is, can PowerPrompt implement columns picklist, if not, is Cognos Query a solution to my problem?
Many Thanks,
Firecat1970
I would like to implement a simple web-based report writer so that for simple query, users can pretty much draw the data they want.
I have read Dave Griffin FAQ which is very useful. I know I can use PowerPrompt to define the WHERE condition of the query. However, is it possible to use PowerPrompt to create a report column list for users to choose. So out of the 30 or so columns I defined in the Catalog, users can choose the columns he/she wants to see in the report output.
Of course, I expect the report to be in simple tabular format only but that's okay as long as users can choose the columns, sorting, grouping and filtering via PowerPrompt.
My question again is, can PowerPrompt implement columns picklist, if not, is Cognos Query a solution to my problem?
Many Thanks,
Firecat1970