Search results for query: *

Hi, I am using CRD XI R2 and have a subreport. The output is going to be split across two columns going down the left and then down the right column after that. Page 1 Header Summary block Subreport-Shorty Col 1 Col 2 Value 1 Value 4 Value 2 Value 5 Value 3 Value 6 End of Page 1...

Hi, we are using Clarity for PPM and are implementing Webi to allow users to run their own queries. However we want to make sure that they can only see the projects/resources etc that they would be able to in the Clarity application. So in the universe I have two main tables. First one called...

Hi, I am new to using the BO Designer as used to working with Crystal Reports. Using Designer on BOE XI Release 2 and have a question that I am hoping you can help with. I would like to create an object which has a value of "1" if various conditions are met. For example "if (field1=A and field2...

Hello folks! Very quick question. My client is running Crystal Reports Server XI release 1 and wants to move up to release 2. I believe that this is not included in the support/maintenance agreement as it is not a service pack but an actual product release. The client does not have good...

Hi folks. I am using Crystal Reports XI R2 against an Oracle DB using native driver. I have a field with values such as 'DD port.1.2.1' and 'DD port.12.3.19'. Note that all of the numerics can be either single digits or double digits so the field length varies. Basically I want to strip the...

Hi. I am looking to use Business Objects Enterprise either with Business Objects (Desktop or Web Intelligence) or Crystal Reports as the development tool. Does Business Objects Enterprise support export of report output to XML ? For background I want to export via XML to integrate into an...

Hi, I am looking at using our existing CRS XI Release 2 installation to run reports via URLs eg: http://myserver:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?iDocID=272 After prompting the user for the logon details the report is run and displayed. My problem is...

Hi there. I am using CR XI against an Oracle database. The table I am reporting off of is : Category, Month, Cost, Revenue 1A, Jan, 1.50, 1.75 1B, Jan, 1.25, 1.95 1A, Feb, 1.90, 2.25 The requirement is for a line chart with the month along the x-axis with the cost and revenue being shown for...

Hi. I am using CR XI against Oracle database via ODBC. I have a main report which has 3 subreports. Each subreport has a chart showing all outages between two parameters (My_Start and My_End for example). For each record the gantt chart shows mytable.startdate and mytable.enddate. All going...

Hi, we have an in-house developed web solution that uses the Java SDK running via a Weblogic server. This connects to Crystal Report Server XI running on a Windows 2000 server. I am attempting to run any report from our web solution but it is not working. From the trace on the web server the...

Hi, we have an in-house developed web solution that uses the Java SKD running via a Weblogic server. This connects to Crystal Report Server XI running on a Windows 2000 server. I am attempting to run any report from our web solution but it is not working. From the trace on the web server the...

Hi. I am using CR XI against an Oracle database connecting via the Oracle driver. Using a formula to convert a string datetime value to a real datetime using : datetime({MyStringDate}) I am experiencing inconsistent behaviour as follows Field value Formula output Correct value 10/09/2007...

Hi, I am using CR XI against an Oracle database and have a query about Gantt charts. Data : ID Start_Date End_Date 1 13/01/07 15/01/07 2 03/05/07 06/06/07 3 14/01/07 16/01/07 My requirement is to show the above on a chart so that any overlaps (ie...

Hi, I am using CR XI reporting via ODBC against an Oracle database. The purpose of my report is to show the number of hours a service was unavailable during the month. Data sample: TICKET_ID (unique), START_DATE, END_DATE 1, 17/04/07, 03/05/07 2, 01/04/07, 07/04/07 If a ticket was opened and...

Hi I have a table with one field caled Tax (char 6). The values can be either NULL or LONDON There is a stored procedure that uses a parameter called "@Tax". I want to do a selection whereby if the param is set to NULL...

Hi, I am running CR XI against SQL Server 2000 connecting via OLE. I have an existing stored proc, called "MySP" which has 2 parameters. This stored proc has been cloned to "MyNewSP" and has 2 further parameters. When I try to use "Set Datasource location" in CR to point to the new SProc it...

Hi, I am using CE 9 on Windows 2003 Server running against SQL Server. Any reports that are migrated for a single SQL datasource always fail when run. I have run them via Schedule to see if it was the Report Job Server. They failed with : Status: Failed Printer: The instance is not printed...

Hi, I am using CR9 against a SQL Server 7 database using ODBC to connect. I have a count of {Field1} within Group{Field2}. When the count is over 1,000 an alert is triggered. However I would like the message to shown which group the alert has been triggered in. Currently I cannot use the...

Hi, I am using CR9 Professional against SQL Server 7.0 connecting via ODBC using the Microsoft SQL Server driver. I have two tables (W03 and W01) that are being joined on a field called CRDATTIM. In Database Expert I have setup the join to be a left outer on CRDATTIM so that if there are no...

Hi, I am writing a stored procedure that checks for a value in a table calle W01, if it exists then the value is updated with one from a reference table. If the record does not exist then an insert is done with the record from a reference table. I would like to capture the values of a couple of...