Recent content by mtl2302

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

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

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

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

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

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

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

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

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

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?