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!

  • Congratulations strongm 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. mtl2302

    How do you change the date format from YYYYMMDD to MM/DD/YYYY

    This one also works: substr (char (reacdt),5,2) ||'/'|| substr (char (reacdt),7,2) ||'/'|| substr (char (reacdt),1,4)
  2. mtl2302

    Returning data that exists in only one of two tables

    I have two tables. One that contains data for tickets sold, and another that contains all tickets sold that have been redeemed. Each ticket has a unique identifier (the barcode). Is there a way that I can return the data set of all tickets that have been sold, but not yet redeemed? I'm sure...
  3. mtl2302

    parameter with multiple values

    Sorry, I forgot to mention that I had to put the parameter in the report instead of the command because I wanted the user to be able to enter multiple values. I'd rather have the parameter in the command, but I couldn't figure out how to get it to work, and thought that question/answer might...
  4. mtl2302

    parameter with multiple values

    I have a similar question. CRXI BOXI Oracle Database The way I have the report set up right now is that I have date parameters in my command object (beginning and ending dates for a range). I then have a dynamic parameter in the report itself. The parameters are working properly and I am...
  5. mtl2302

    How can I sort date when stored as text?

    I've done all this, but here is the output: Pre 7/15/2007 7/22/2007 7/29/2007 7/8/2007 8/12/2007 8/19/2007 8/26/2007 8/5/2007 9/2/2007 9/9/2007 Post Does it matter that this is all in a cross tab report? Here is the formula of which I am also sorting in the Record Sort Expert: if...
  6. mtl2302

    How to activate hyperlinks when emailing report from server

    Business Objects Enterprise XI Crystal Reports XI How can I activate the hyperlinks when choosing to set the destination as email on a scheduled report? I can set up the report as scheduled, and cab add the viewer hyperlink to the message body. However, when the recipient of the email clicks...
  7. mtl2302

    How can I sort date when stored as text?

    Crystal Reports XI Oracle Database How can I sort dates when they are stored as text in a formula. I have a formula that sets a defined date range, say < 7/1/07 as text "Pre", the date range 7/1/07 - 7/31/07 as the actual date, and >7/31/07 as "Post". I would like to sort the output in the...
  8. mtl2302

    Crosstab - Calculated fields

    Row: Salesperson Column 1: High level product summary group broken into A,B,and C. Column 2: Detail level product (individual products) Summary: Qty of sales Again, I'd like to add some calculations as columns. So for each sales person I'd like to calculate summary group B as a percent of A+B...
  9. mtl2302

    Crosstab - Calculated fields

    CRXI Is there a way to insert calculated fields in to a crosstab report? I have two column levels. The top level is a product summary: A, B, C. Within each product summary there are various products, which is the second column level. I'd like to be able to calculate the total of B sold as a...
  10. mtl2302

    Scheduling reports

    How do you send the email with the attachments? I have reports that are scheduled to run from BOXI (CRXI) once a week. I would like the let the users know that the report has run and include either a link to the report or a copy of the report as an attachment in the email. Is this possible?

Part and Inventory Search

Back
Top