Search results for query: *

Hi! We have an Address table with a total of nine different name and address fields. Sometimes every field is filled, but mostly there are several empty columns (NULL). Now I want to create a SQL-query with a result where I can "move" all fields upwards, so that every empty column appears at...

We sometimes get this error: "Error:534 Error detected by database DLL. Execute <PEStartPrintJob>" We are using Crystal Reports 8.5 and database Oracle 10. The report is used in an environment developed in Delphi. When we call the report (a delivery note) from the application using our...

Hello! My question is if it is possible to have a "Select Case" with a SUM (or MAX) and the have a GROUP BY. We have a alphanumeric field where there in some specified positions will be values for length, width and heigth. I have to pick out the biggest value, but I also want to check and see...

Hi! We are using Crystal Enterprise 10. We have both named and concurrent users (total 250 users). We have a licence for 15 named users. My question is how I can get information about which users that are configured as a named user, without having to look att every single account name. /Goran

Hi! I´m working Crystal Reports 8.5 I havn´t worked so much with cross-tabs, and now I have a question regarding the height of each row. Is it possible to reduce the space between the rows, so I can get the cross-tab more narrow in height? /Goran

Hi! My question is if it is possible to retrieve just one row for the following case. We have a table, PARTY, where we have a single row for each PARTYID´s contact. The table look like this: PARTYID, CONTACT_ID, NAME, PHONE One PARTYID can have up to three different CONTACT_ID´s. Is it...

Hello ! We are using CE 10. We have lot of reports that we schedule and email. Now the customer are going to change email-addresses. How do the query looks like that I can use in the CSP Query Builder to find all objects with mailadresses that ends with '@.yyy.com' ? SELECT * FROM...

Hi ! We are having trouble on one of our workstations, where some formatting does not work (while it works on other stations). It´s a report where I conditionally format background and font. Here is an example of the font-formula: if {MyTableField} = 1 then crBold On the...

Hi ! I´m using Delphi 5. I have a standard combobox in my form. The width of the box is not as wide as the items that are in the box. What I want to happen is that the dropdown itself will be as long as needed so you can see all the text. I have not found any settings for this. Is it...

Hi ! I´m using Crystal Reports 10 and Crystal Enterprise 10. I wonder if it´s possible to edit the alert message, so the receiver of the email gets information about the alerts. I have for example in this case a report that runs daily, but only have records that meets the criteria say ones a...

Hello! I'm running Crystal Enterprise on a Windows 2000 server. I also have Crystal Report installed on the same server. My problem is that i get wrong date format when exporting a report to excel or pdf, but right format when I save it as crystal format. And also when running the report...

Hi ! We have CR 9 and Crystal Enterprise 9. We now have two reports against an SQL Server database. There they have written a stored procedure, which I use in my reports. The procedure takes two parameters: @FromDate and @ToDate (both DateTime). My problem is that I want to schedule the...

Hi ! We are going to upgrade from Seagate Info 7 to Crystal Enterprise 9. We are running against an Oracle7 database (Server Release 7.3.4.5.0). Our reports are connected through a native connection. However, when we migrate the reports to CE9 it seems that we can not do that anymore. When we...

Hello ! Can anyone tell me how to deal with this: I have two tables (ORDERROW and ARTICLE). Articles are divided into five different groups. I have today an SQL which counts the number of orders for each group: SELECT A.ARTGROUP, COUNT(DISTINCT B.COID) FROM ART A, ORDERROW...

I have a very stange problem. My report, wich includes two linked subreports, shows right values when I run it thru the Report Designer, but when I schedule the report it shows complete different values. We have Seagate Info 7.0.2. Does anyone have any ideas ? Thanks.

Hi ! I have a report with a parameter where the user types in a signature and a pickorderno. The record selection says &quot;Pickordernumber >= {?Pickorderno}&quot; The result can be everything from 1 to n pickorders with multiple orderlines. My problem is that I have to sort the selected...

Hello ! I have a problem with setting the location for my Crystal Reports subreports from my Delphi application. For instance, I develop the report, and use a testdatabase called ”TEST_DB”, so both main report and subreport are set to that location. Later when we run those reports in ”sharp”...

Hello ! I have a problem with setting the location for my Crystal Reports subreports from my Delphi application. I have seen some threads about this before but I haven´t been able to fix my problems. When running the application we get an access violation. I’m working with Crystal Reports...

Hi ! I have a report with a subreport placed in the ReportFooter. The subreport can consist of several pages. My problem is that I want to have different PageHeader on the Main Report and the Subreport. I have created a group in the subreport and I have its groupheader repeated on every...