Recent content by sstengler

Appreciate the feedback, DoubleD, unfortunately, the summary filter as given has no effect on the query. With the filter applied or not, it still displays all of the elec_eff_date's, instead of just the latest (maximum) one. It looks like the filter is not selecting the maximun date for the...

Ok, tried that, but it kept giving me a syntax error near the MAX function....this was in the Filter expression builder. I don't see anything in Query that indicates "Advanced filter".

I'm needing to duplicate the use of the Oracle MAX() function in my Cognos Query data sets. We have two tables, EMP and ELECTIONS, where EMP contains the demographic data for a person, and ELECTIONS contains thier benefit elections over time (so, there could be several rows where the person...

Thank you, that was it! However, that introduces another question: the column ia2.action_date_c has already been converted to a char() in the in-line view..why does it need to be converted agian in the WHERE clause in the main SELECT? Anyone? Sam

I have the following SQL (6.5) that apparently doesn't see the join correctly, as it doesn't see matching dates that have been converted to char(). select ia.client_id, ia.issue_number, ia.action_date, convert(varchar(10),ia.action_date,110), ia2.action_date_c, ia2.isscount from issue_activity...

Mufasa, Wow....thanks!...this is something I didn't even think of....now, if i can just get the "adding user functions to Cognos" stuff working, I'll be able to solve two problems. Thanks again!

I have a reporting system, using 8i as the database. I have been asked to create a report that concatenates some of the data from multiple rows into a single row, as follows Assume two tables with the following data: Table_a case id name address 1 123 J. Blow 111 Daisy Ave 2...

Ok I've got a Dashboard report made up of a dozen or so subreports. I have a row of bar charts, all displaying the same data, but for different business domains. The probolme occurs when there is no data for one or more of those domains. I want to hide the resulting very ugly bar graph, and...

Thanks for the info. My apologies, but unless I'm missing something in your reply, this is only a small part of the solution. Neither of these functions would really work by themselves or together to give me the correct number of days with the weekends (if any) subtracted/ignored/removed. The...

I have a requirement for a report that needs to calc a time period in Days (now just simply subtracting the two needed dates). Is there a way to change the calc using the COGNOS Impromptu functions to exclude the weekend days in the total? (i.e., if case took 5 calendar days to complete (Thurs...

Thanks for the info - unfortunately, this doesn't apply. THis machine has been up and running for almost a year, and all the other reports still work. Running the report from Impromptu, and Impserver, are successful, and all run on the same machine as the Upfront server. It just gives the...

I have an Impromptu report that has three promtps that are populated from the database. It runs fine in Impromptu, but, when I publish it and try to run it, I get teh following error: GeTemplate iwr_modifyprompts.utml failed. Reason: The content request 'DescribeNewsItem' has failed. The Cognos...

Oracle 8i - native Impromptu 7.0.702 select sum(T1.&quot;TOTALCALLS&quot;) &quot;c1&quot; from &quot;UHGDASHBOARD&quot;.&quot;AAC_COG_TELEPHONE_TOTAL_CALLS&quot; T1 where T1.&quot;PERIODDATE&quot;>=TRUNC(SYSDATE ,'MONTH') and T1.&quot;PERIODDATE&quot;<=LAST_DAY(SYSDATE) and...

Ok, checked the data source column, and it was returning a date-time. so converted it to a date (datetime_to_date(Perioddate), but it still didn't work. The only way I can display the prompt data is to Insert, Prompt variable - that shows the prompt variable name, then the variable...

When I use this as a filter, (Perioddate >= first-of-month( Main Query.promptdate) and Perioddate <= last-of-month(Main Query.promptdate)) - (where Perioddate is a data source column) I get the following error when I try to look at the SQL: &quot;A general exception has occurred during...