Search results for query: *

Hello All, We had a number of web reports (2D & 3D) that were published on a Win2K server. There were some CSP code behind the reports to handle the customization of some parameters pages and so on. Currently we are migrating to WinXP. Everything works fine except for this strange problem: In...

Hello, I have a number of published web Crystal Analysis reports. After viewing any of them, when right-click a dimension and choosing an Action: It opens a new browser window to open another report. The problem is that the URL of the new report is...

Hello All, I have a number of 3D web reports published. When trying to view most of them, they produce the following error in a browser "An error occurred, but no details are available". The title bar of the browser displays...

Hello all, I am developing a number of reports using full client then publish them on InfoView. In the reports, I created several prompts. However, when I try to show the values of one of them, the list is displayed unsorted. In the designer, I sorted the object being prompted (from the...

Hello All, I created a report using BO 6.5.1 accessing a SQL Server database. This report is then published to InfoView, In this report I have a prompt on a Column having a datatype of nchar. The prompt is like this: Where A.Reference2Vendor LIKE @variable('Contract Number:') The problem is...

Hello All, I have a report created in BO 6.5.1 In the SQL of the report, we placed the following in its Where clause: where AI LIKE @prompt('Action Item:','a' ,{'%', 'A', 'B', 'C', 'D', 'E', 'F', 'G'} ,mono ,free) When the report is published to InfoView, the prompt appears as a Drop Down...

Hello All, I have a column in a report created by playing in the SQL of the report. Now I need to prompt on that report. I inserted the following in the Where Clause of the SQL: "Where AI LIKE @variable('Action Item:')" It works fine except that the "VALUES" button is dimmed. Any ideas about...

Hello All, I created a Variable called "Action Item". It have a number of If statements as follows: = If <Last Status> >= "523" And <Next Status> <= "525" Then "A" Else If <Last Status> >= "540" And <Next Status> <= "542" Then "B" Else If <Last Status> >= "530" And <Next Status> <= "542"...

Hello all, I have a requirement in a report that gives me a hard time. The requirement is to change the grouped by column in the report according to the user selection in the prompts (filters). i.e.: If the user filters on Col A, the report groups by Col B and vice versa. Can anybody help me...

Hello all, I use BO 6.5.1 to develop a report then publish it as a Corporate document on Info View. I have several date prompts in the report and i need to enable the user to choose the date from a calender (beside being able to write the date). Is this possible? Thank you, Diaa

Hello all, I need to create a report that needs to be filtered according to the user logged in. i.e each Field Supervisor sees his own data, each manager sees the data of his Field Supervisors, etc. This is needed to be done on the report level. I have written an SQL that returns a result set...

Hello all, Can I write my MDX queries in OWC11? Can you please direct me to any documents speaking about OWC11? Thank you, Diaa

Hi all, I have PowerPlay 5.2 running on win 98 and we want to migrate to win 2000. Is the PowerPlay 5.2 supported on win 2000. I couldn't find any help in the cognos site. Thanks and best regards

Hi all, as i am totally new to Brio, i wanted to know a simple piece of information: Which Brio product is used to access DB2 OLAP Server cubes? that is to be used as a front-end for the cubes created by DB2 OLAP Server. Thanks in advance.

Hi all, i created a catalog on DB/400 and also some reports and they work fine under win2000, but i have a win XP machine on the network and i won't to enable the user to use the reports. When i run any report, it gives me the following error: Query Server Error Error number -239: DMS - General...

Hi all, I have a catalog and some reports that run fine on win2000 but when i try to use them under win XP they produce the following error: Query Server Error Error number -239: DMS - General, a general exception has occured during operation 'prepare request with options'. the Impromptu version...

Hi all, i created a catalog and some reports on sample data and they work fine. But when i moved them to work on the production data, an error appeared in some of the reports. The error is &quot;SQL0802N Arithmetic overflow or other arithmetic exception occurred&quot;. So, have anyone...

Hi all, i connected to a remote DB2 database v7.2 on mainframe from my pc using DB2 UDB enterprise edition v7.2. All the tables came fine but when i right click one of them to export the data to an ixf or del file, there is ne export or import functions. So is it the privilages or there is no...

Hi all, Is there a possibility to syncronise the changes done to passwords on RACF with the domino passwords stored in the ID file (Client/Server environment) Thanks in advance

Hi all, Is there a way to replicate between DB2 and SQL Server 7? how much time does it take to replicate a medium size company Database? Thanks in advance