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 Rhinorhino 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: *

  • Users: GretaD
  • Content: Threads
  • Order by date
  1. GretaD

    date part with format 1st 2nd 3rd etc.

    Hi I'm using Crystal Reports XI and Oracle database. I have date fields that I want to extract only the day part of, and with the format 1st, 2nd, 3rd etc. Does anyone know if this is possible and which format I should specify in the formula? Thanks! Greta
  2. GretaD

    shared variables and multiple sub reports

    Hi I'm using CRXI I have a subreport that contains 3 shared variables (unit, unit_type and currency). The code are similar to this in all 3 whileprintingrecords; Shared stringvar unit_type:= {UNIT.UNIT_TYPE}; The subreport is placed in the report header of the main report. These 3 shared...
  3. GretaD

    Change shcemaowner /DB user in a report

    Hi I am using CR XI and Oracle 9. I have a database with different schemas/users in it with the same table structure but different data. How can I change manually between these schemas/users when running the report, and is it possible to add it as a parameter field? Thanks for any answers...
  4. GretaD

    more crosstab problems

    Hi, Still using CR XI and Oracle database. I posted a thread earlier today, found out some of that myself, but encountered more crosstab problems... Here is what the crosstab should look like (in design mode) the lines here should represent single lines size hairline...
  5. GretaD

    CrossTab totals

    Hi I have a crosstab report (Crystal XI, Oracle) where I want three summarize fields, but for two of them I only want to show the total (row total for one and column total for the other) is this possible in some way? Example Month Seller 1 Seller 2.. Seller5 Total ActualGCV Jan...
  6. GretaD

    call PL/SQL functions outside SQL Expressions?

    Hi Do anyone know if it is possible to call PL/SQL functions outside SQL Expressions? I have a PL/SQL function where I want to send in the parameterfield I get in the report as a parameter to the function. That does not seem to be possible in SQL expressions... I use Crystal Reports XI and...
  7. GretaD

    Parameter fields in SQL Expressions

    Hi, I'm using Crystal Reports XI. Is it possible to add parameter fields in SQL Expressions? I want to create a subquery in an SQL expression and in that subquery I need to use the parameterfields from the report to select the correct record. Example Select CONTRACT_INVOICE.INVOICE_YEAR...

Part and Inventory Search

Back
Top