Search results for query: *

Hi, and thank you very much. Your solution worked great, and I think I followed your explanation how it works. I really appreciate all your help. Many thanks. /Goran

Hi again! You are really super. I have tried the script and it was just perfect (but I don't understand how it works). It also seems that I need your help again. I tried to add additional fields in the begin of the view but it failed. Evidently it wasn't just to put them there. Does it need...

Hi! Thank you SantaMufasa for helping me. Just now I can't test i, but I will try to do it tomorrow. Maybe it need some smaller changes. I actually planned to create a view with nine columns from the query, where all the information was at top (therefore the column name "AdrInfo1" etc) with no...

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

Hi! I just want to say that we finally found the reason of the behavior, and the error code we received ("Error:534 Error detected by database DLL. Execute <PEStartPrintJob>") was not much help. It was different NLS_LANGUAGE code settings in the Oracle database and on the Oracle clients that...

Yes, it runs stand alone from our developer work stations, but as I said before, sometimes the report also run correct from the costumers computer when it is called from the application.

Hi! It is called from an application developed in Delphi.

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

Thank you hoinz. It worked perfectly. /Goran

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

It worked fine. Thank you very much. /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 again! That did the trick. I didn´t thougt of the case function. Thank you /Goran

Hi! Thank you Dagon, but maybe I didn´t describe my problem so well. I did try your sql, but it only gave me one row with one of three CONTACT_ID´s. You see, what I want is an sql where I can get all CONTACT_ID´s for one PARTYID in one single row, because when I later join our order table to...

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

Hi blueboyz! If there is a year with 53 weeks (e.g. 1998), what week will you then want to show for the year before? And have you got the amounts for Last Year to show up correctly yet? /Goran

Hi! Another approach that you can try. Create two formulas @LastYearStartDate DateAdd("ww", -52, {?startdate}); @LastYearEndDate DateAdd("ww", -52, {?enddate}); Let your Selection Formula look like: (({Table.field} >= {?startdate} and {Table.field} <= {?enddate}) or ({Table.field} >=...

Sorry, I missed that one. As Brian said it shall look like: DatePart ("ww",{table.date}, crMonday). That will give you the week number with a week starting on monday. Wasn´t that what you wanted? /Goran

Hi! Command objects are listed as Add Command under your data source, just above where all the tables are listed. /Goran