Search results for query: *

Hi, Does anyone know about the following Query Server Error? [!]EXPENG-E-TYP2, The operation <assign> is invalid for data types <null> and <null>.[/!] Details as follows [!]Error number -239: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'...

Hi, I have used a calculated data item with prompt value to enable dynamic sorting,e.g. if (?column to sort prompt? = 1) then (column1) else (column2) However, after we upgraded to Impromptu 7.1 (from 7.0 MR1). I have been having trouble with any comparison using prompt value. I got the...

Hi, I read quite a few solutions using this method. However, after we upgraded to Impromptu 7.1 (from 7.0 MR1). I have been having trouble with any comparison using prompt value. I got the following error: [!]Error retrieving data from the database. DMS-E-TYPENOTSUPPORTED, The data type...

I have a sort of similar problem, and still looking for help. I'm working on Windows XP Professional, IIS version 5.1, Access 2003 The web server and the data source is on the same computer After reading the following post...

Hi, My problem is as stated in the subject line. I have a report picklist prompt that feeds a final report, but there are times when the picklist returns no data, but the prompt window still displays for users to click, which I want to avoid. Could anyone with similar experience share with me...

Hi, I'm still new to Cognos and data reporting even after several struggling attempts to create Cognos reports. I have been wondering about the approach to do a report. Can anyone tell me when I should create reports with multiple criteria from user input with a multidimensional cube or should...

Hi Martijn, My prompts are cascading prompts. It first contains 2 picklists of university and fiscal year. From there users will get a second prompt to pick buildings for the selected universities and fiscal years. All prompts are string datatype. I simply found this weird as compared to other...

Hi, Does anyone know why I got an error message when I click Cancel on a picklist prompt? The error message is as follows, ****ERROR**** An error has occurred during the execution of the report picklist prompt query. Please check your picklist report. I pulled out the picklist report and it...

Hi, On my Cognos report, I have a value that is calculated from a value passed from a picklist prompt. The value is a concatenated string of values gathered from prior prompts to filter data on the report (since Cognos prompts only allow one value to be passed and I need all the values from...

Hi Dave, Thanks for your suggestion of alternate design scheme. I have tried it and it works! Meanwhile, I tried rewriting my statement in a slight different manner and finally got the multiple selection list box to show up fine for both University and Fiscal Year prompts. 1 = if ('*' in...

Hi Dave, Thank you! I inserted a dummy row ('*') in the tables where I draw the University, Fiscal Year, and Building. That's how I expect the user to select their response from the list. If you have any suggestions on this use, please advise :) I'd love to hear it. Could you see why I am...

Hi Dave, Thank you very much for the elaboration of the conditional filter construct. I wonder if you can look at my code and offer me your insight into my Cognos piece? :) Here it is: Basically my code is trying to retrieve a list of buildings from picking from a university and fiscal year...

Hi Griffindm, Thank you for your response. I really appreciate it. I do not quite understand the constant you put in your code sample. Could you tell me how 1 is defined? I see that you put &quot;1 = if(test condition1 true) then (1)...&quot; If this is where it is defined, could you explain...

Just to add a code example here for my question posted above. Thanks in advance. If (?\Prompts\Pick University? <> '*' and ?\Prompts\Pick Fiscal Year? <> '*') then (Building Picklist University ID in (?\Prompts\Pick University?) and Building Picklist Fiscal Year Code in (?\Prompts\Pick Fiscal...

Hi, Does anyone know how I can create a report that would use a different filter based on user input from the picklist? I tried to create conditional filters, but Cognos doesn't appear to like expressions following &quot;else&quot; and &quot;then&quot;. I'm new to Cognos and would appreciate...