Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. goranm

    How to "get rid of" empty columns in a 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
  2. goranm

    How to "get rid of" empty columns in a query

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

    How to "get rid of" empty columns in a query

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

    How to "get rid of" empty columns in a 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...
  5. goranm

    Problem with error 534 (Error detected by database DLL)

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

    Problem with error 534 (Error detected by database DLL)

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

    Problem with error 534 (Error detected by database DLL)

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

    Problem with error 534 (Error detected by database DLL)

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

    Problems with Select Case and Group By

    Thank you hoinz. It worked perfectly. /Goran
  10. goranm

    Problems with Select Case and Group By

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

    Named Vs Concurrent users

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

    How to configure the height of a cross-tab row

    It worked fine. Thank you very much. /Goran
  13. goranm

    How to configure the height of a cross-tab row

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

    Create a view with one row per ID

    Hi again! That did the trick. I didn´t thougt of the case function. Thank you /Goran
  15. goranm

    Create a view with one row per ID

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

    Create a view with one row per ID

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

    Same Week Last Year formula

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

    Same Week Last Year formula

    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} >=...
  19. goranm

    How to group by week starting on Monday

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

    Possible? SQL Left Outer Join with where clause for the right table

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

Part and Inventory Search

Back
Top