Search results for query: *

Hi, I have a table called deal_fact a and alias of the same deal_fact b.Now i want to achive the following query by joining two tables in impromptu.How should i join them. select count(a.deal_key) from deal_fact a, deal_fact b where (b.time_key (+)=20030629 ) and a.time_key=20030725 and...

Hi, I have go two tables...A and B Table A has Investment_id as primary id,while Table has following structure. Deal_id,Property_id,Investment_id,detail_id,month and year.Table A stores the data for current month while table B stores data for all past months.Now in my report, i have to show...

Hi, I have 5 tables A,B,C,D,E A Investment_detail_ID B Investment_detail_ID Investment_id c Investment_id Deal_id D Deal_id E Deal_ID on Joining the A,B,C,D I get some deal_ids.Now if I have to find out which ids of these result set are not there in table...

Hi, I have to prepare a few stored procedure reports.Could you please tell me that for making the catalog, i will fetch the metadata of all tables that will be used.Do i need to perform the join between them as anyway i am using the stored procedures. Please revert. And do i need to inclued...

Hi, I have a catalog with some tables and a database view.The catalog and all the reports associated with it are working fine.But when i send it to somebody be mail, and the guy at other end tries to open the report,it says view or table not found.The report is unable to find data item from...

Hi, I have an .imr report.There are four sub reports in it.Of which, Two are bar graphs.The report runs fine.But When i customise the colours of bars in these graphs,the reports doesn't run for all values of each prompt.For some values, when started running, it shows error saying'Impadmin.exe...