Search results for query: *

Thanks DJJ, I didn't know it whas that easy! Unleash ----------------------------------------- >>>Fornicate Under Command of the King<<<

Sorry about that! PAL = ORDER. ----------------------------------------- >>>Fornicate Under Command of the King<<<

UPDATE [database].dbo.PAL SET CLIENT_ID = (SELECT CLIENT_ID FROM ORDERTEMP WHERE TAG_ID IN (SELECT TAG_ID FROM ORDERTEMP WHERE ORDERTEMP.TAG_ID = ORDER.TAG_ID)) When I execute the query in MS-SQL the error 'Timeout Expired' is displayed Can anyone help me with making the query work? I...

Hi, In a report I want that the end-user can select orders from certain customers. These customers are requested via a parameter screen. Next I would like that the orders matching to the previous selected customer in a parameter box appear and that the end-user can choose these orders to...

Hi, When I export a Crystal report (version 8.5.3.975) with CrystalDesk (version 9.0.6965) CrystalDesk creates 3 empty lines between each line with data. When I export to MS-Excel using the export function in Crystal Reports it will put the lines correctly without the blank lines. Anyone an...

I found the solution. Folder where the report whas placed in did'nt had write acces rights. ----------------------------------------- >>>Fornicate Under Command of the King<<<

Hi, I have created a report and compiled it. When I try to start the report via the executable I receive the error "Cannot open control file". I searched this forum for a solution but they don't work. I have tryed the following possible solutions: 1. re-compile 2. set .crf file to read only...

Cheers! I will give it a go this week. Thanks! ----------------------------------------- >>>Fornicate Under Command of the King<<<

I wish they should'nt, it is the same reason why we did'nt deployed V10 :-p. I use version 8.5.3.936 ----------------------------------------- >>>Fornicate Under Command of the King<<<

Hi, I am experiecing difficultys with a report. I have created a report and I don't have problems with running this report, but when I run this report after I compiled it and I run it via the exe file I get the error "Cannot open SQL server." I created a dozen of reports with an exe file and...

Hi, I use Crystal reports version 8.5.3.975. When create an alert and I run the report I receive the alert, but when I compile the report and I run it it does'nt show the alert. Is there a checkbox that I am missing? Kind regards, robert ----------------------------------------- >>>Fornicate...

Hi I am having difficulty's with a report wich is based on a Oracle database. The Oracle database generated up to 3GB of sorting data in order to do so. I would like to add a hint to the Crystal report so Oracle will handle his data more efficient. The hint is /*+RULE*/. Does anyone has...

Hi, I am having difficulties with the following formula: If {?Report} startswith 'DAG' and {SKU.SUSR8} = 'Y' then '1' I receive the error "A string is required here." It does'nt work. The original formula is: If {?Report} = 'DAG' and {SKU.SUSR8} = 'Y' then '1' That formula works out well...

Hi, I am not well knowned with Crystal Reporting but I am with MS-Access. Is it possible to GROUP BY a field in the details section of a Crystal report? ----------------------------------------- >>>Fornicate Under Command of the King<<<

I only have the options: free form placement x hide supress x print at bottom new page after reset page number after keep together x suppress blank section underlay following sections Fornicate Under Command of the King

Hi I am having problems with running a summary on a report. The summary keeps adding the total per report upon each other, while I want the summary per page.