Search results for query: *

Hi, Can anybody let me know if there is any summary function to concatenate a character values in a row. For example, I have the data similar to that given below: Sample Data: Contract_ID Product_ID 1 ABC 1 DEF 2...

Hi, Is it possible to schedule IWR which automatically picks up the prompt values from PowerPrompt? Thanks

Hi Folks, Can we dynamically add sub-reports depending in an Impromptu report. I have requirement of creating an excel sheet from a impromtpu report. Report for each year should appear on different work-sheet of the excel. Every year a new sheet should be added. only way to show reports on...

Hi Vijay, Could you find answer to your problem? Is there any to key off the event in IWR? Can we use MQ message or e-mail to key off the event? If it is possible how can it be done. Thanks, Subhash.

Hi, I am able to schedule a COGNOS macro to create 40 PDF reports by applying filter on lender column (one of the columns in the report) of an IMR report. Now I have to publish this report in IWR and create 40 PDF reports for 40 different lenders. Since I cannot run macros in IWR, is there any...

Hi Folks, I have 3 sub-reports which should be shown on three different pages. Data in first sub-report is shown only on first page. Data in second sub-report is shown only on second page. Data in third sub-report is shown only on third page. I used the conditional format "Hidden" whenever...

Hi Folks, I need help in creating complex report. I have a view whose result set is similar to the view looks like the following: ReportType Sales Profit Item# ItDetails Customer Item# Qty ------------------------------------------------------------ SalesReport 100 10 null null...

Thanks for the reply Dave! We cannot predict the address ID. I tried with cross tab, But Addresses of second guy starts after the addresses of first guy as show below: Ananth Addr_1_1 Add_1_2 Add_1_3 Boby Add_2_1 Add_2_2 Is there any other way? -Subhash.

Hi Folks, I have a very complex transactional data model. I have to create a report out this complex data-model. I can give the picture of this data model in simpler terms. I have the following tables: Employee Table -------------- Employee_id Employee Name ----------- ------------- 1...

Sub-reports use different queries. If you want to create mutiple frames for a single query, insert a new list frame and drag and drop the data items from the frist frame to the new frame. This way you can create mutiple frames though the query is same.

Hi folks, I have about 10 IMRs which are to published on Upfront server which can be viewed in PDF file. I know this is possible. But I also want to have one PDF file which contains all these 10 reports. I hope this cannot be done by upfront server. Therefore I will be using PDF merge software...

Thank flex! I will try this.

Hi Folks: My client has a specific requirement of puttin all the reports in one PDF and send it to their clients on a periodic basis. Can we save multiple reports into one PDF file? Can we write any script to do this? Also can we add a blank page to a report? Looking forward for some...

Hi, My client has requirement of saving multiple sub-reports of an impromptu report to one work-sheet of the excel file. Can you please let me know if it is possible? If yes, How can we do this? Thanks in Advance, Subhash.