Skip to Content
avatar image
Former Member

Report - Work Center start-up time by date...?

Hello all,

I'm fairly new to Crystal Reports and am struggling to write a report for my company...

...I'm trying to create one that shows the daily work center start-up times.  The idea would be to have a "date parameter" that could enter any date in the past and show what time our work centers/machines start production in the morning.  I've tried using a few different tables/fields but I think I'm likely not linking something correctly.  If anyone has any tips/suggestions to help point me in the right direction it would be greatly appreciated!!

thanks,

TZ.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 04:11 PM

    Hi Taylor,

    In one of your tables your company is maintaining work centers/machines start producution in the morning.

    Go in TOAD / Query Analyzer and use below to find which field it is ?

    Select * from TableName

    Once you have this information and the information is from multiple tables then try to join using Inner Join / left / Right outer join and see how you see records in your report.

    Thanks,

    Sastry

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Basicly

      You won't "link" the parameter to any field in the report,  you will need to use the date parameter field to limit  ( restrict)  the result set of data that you are working with. 

      if you are working with data that comes directly from the tables,  you can to use the Report Select Expert     ( from the Report menu dropdown )  to create a formula   that says  essentually  ....  Give me all the data where the start time date is greater than the  date value of the  Parameter that begins the range wanted   ( and is less than the ending date range if you have one )      or if you are working with a select statement or a command to retrieve your data    you can incorporate the parameter  into the select command    just as if were a regular field.    and the same if the data source is a stored proceedure or view.

      Ted