Recent content by tandyaw

By the way, this is for Cognos Impromptu. But if it can be done in the database level, it would be great. Thanks again!

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...

sorry, let me rephrase the question. I have the main imr and the detail imr. After published to IWR, I want the detail report to be opened in a new browser window. Is that possible? Thanks, Lia

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

Hi Dave, I think I'm not doing this correctly. This is what I did: I created the view above. Then I created an alias of table 2. First, I join the audit_id from the alias to both audit1_id and audit2_id from the view. But I didn't get any results in the report. Then I changed it and make a join...

Hi Dave, If I'm understanding you correctly, joining the alias to both audit1_id and audit2_id, won't give me any results because audit1_id and audit2_id will never be the same. When you said 'single alias' it means an alias of the questions table, right? Thanks, Lia

Table 1 represents all the available audits. While table 2 represents all the questions in each audit. Based on the sample data, Factory 12345 currently has 2 audits available (10001 which is AUDIT 1 and 10003 which is AUDIT 2). AUDIT 2 is the follow up of AUDIT 1. There might be AUDIT 3 which...

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, there was only every going to be three audit dates for a factory. And I think choosing one that is neither the minimum nor the maximum might work. Should've thought about that! If not, then I'll try sln007's suggestion. I just need to remember again for which report I asked this question...

What do you mean with 'fixed' number? There are currently only hundreds of rows, but it'll grow. Thanks..

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...

Got it! Thank you guys! -Lia