Skip to Content
author's profile photo Former Member
Former Member

Dual data sources, dual date formats

Post Author: Mack

CA Forum: Formula

My question is this...

Using Crystal XI I've written a report and subreport to combine records from two Oracle dbs to provide a monthly activity cost report. The date format in the main report data is mm/dd/yyyy, and in the subreport data it's MMM-YY. I'm able to report one month at a time(using separate date parameters in each report, main & sub) but now need to produce a YTD report.

How can I handle the date format difference when providing a date range? Any help will be greatly appreciated. Thanks!

Mack

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 12:58 AM

    Post Author: SKodidine

    CA Forum: Formula

    Hello Mack, I received your message but am unable to repond to your message, so here goes:

    If you are able to generate the report month by month then you should be able to generate it for a whole year grouped by each month.

    Let's get the main report working for YTD before we tackle the subreport.

    For the main report, (for testing purposes) add a new static parameter value, say YTD. In your main report, group by the date (by month). In your selection criteria put a if-then or case statement.

    Select {?My parameter}

    case 'YTD':

    {table.date} in YearToDate // if the selection is for YTD then you will get all records based on the date from the begining of the year.

    default:

    "However you have the selection setup right now";

    Test it and see if the data is grouped by month of the current year from January to September. If that works then we can work on the subreport.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.