Change DB table with Impromptu crosstab

[gizuffi]

I created many complex crosstab reports with Impromptu. They are based on a SQL table wich is generated and filled by a user every time he desires to see a different kind of report. The table is cancelled and filled everytime. My customer has 3 different users wich need to launch different reports at the same time so I need to use 3 different tables. These tables have the same fields with the same name. I'd like to know if there's a way to copy a report set for table 1 and change it for table 2 without having to recreate everything from scratch. In my catalog I have a folder for each table.

 

[griffindm]

Why use 3 different tables? Why not populate a USER_ID column and filter the report based on it? This makes the reports simpler and more scalable, assuming they all use the same report columns.

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

http://www.decisionsupportgroup.com