Recent content by dideb

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, Could the server name have been assigned in the report itself? Thank you

Hello Turkbear, I am a bit new with Crystal. Can I know the data source info (name, path, etc...) from the report itself? Thank you

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 synapsevampire, Yes, they are Crystal Analysis reports. I tried to run the reports using crystal analysis but surprisingly, they produced the following error: Crystal OLAP The file that you are loading refers to a cube that no longer exists. Would you like to open the file against a...

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

Well, surprisingly the problem was solved by copying the .lov files from \mycluster\universes\efulmart to \mycluster\universe\universes\efulmart on the server. It seems that the designer is working on a folder different from the one InfoView is reading from. Can't explain why...

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 skrandel, As you said, @prompt worked. I problem i am facing now is how to preserve the "%" sign in the prompt to produce all records. Unlike @variable prompts, the value is reset when re-opening the report. So "%" is not there. Silly but required... Thank you, Diaa

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 Ties, I have placed your code as an expression in the select statement of the report and named the expression "Subquery". Unfortuntely, expressions can't return more than one value. The following error popped up: Exception: DBD, [Microsoft OLE DB Provider for SQL Server] : Subquery...

Hello Brian, Thank you for the reply. I think this won't do because if the 2 conditions are satisfied, 2 rows should appear; one for each Action Item. What do you think? Thank you, Diaa

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