Search results for query: *

I need to pull up data within specific date (that is specified by the users) and display the returned value in comma delimited. How can I do that? So my data looks like the following: TABLE 1: PARENT ID CHILD ID --------- --------- 12345 22234 12345 33345...

Hi, I'm just wondering, is there a way to open the drill through report in a new window (in IWR)? Thanks, Lia

Is it possible to call stored procedure from impromptu? Thanks, Lia

I have the following data in my database: Table 1 AUDIT_ID FACTORY_ID TYPE 10001 12345 AUDIT 1 10002 23456 AUDIT 1 10003 12345 AUDIT 2 10004 34567 AUDIT 1 10005 23456 AUDIT 2 Table 2 AUDIT_ID QUESTIONS_ID 10001 23 10001 45 10001...

Hi all, I have a VIEW that combines data from 2 tables (table 1 and table 2). In the view, I have all columns from table 2 and only 2 columns from table 1 (FACTORY_ID and TYPE_ID) In Impromptu, I'm able to pull out all view data from table 2 into the report. However, when I try to pull out the...

Hi, I have another questions. I have cascading prompts in which the users can select a factory name and then based on the name they select, the second prompt should display all the available products for that factory. The users can select the products, and the report will be populated based on...

hi all.. I have the following data in my database: Factory1 Audit Date1 Factory1 Audit Date2 Factory1 Audit Date3 In my report, I need to display it like this: Factory1 Audit Date1 Audit Date2 Audit Date3 I can get Audit Date1 and Audit Date3 using the minimum and maximum...

Hi, Is there a way to see and get data from database views in impromptu? Thanks, Lia