Community

Custom Reports

Avatar
Written by Permanently deleted user
  • 3
Hi,

Have any of you ever done a custom reports?

I'm trying to get batches in order of process (from scanning to processed) and duration time by batch and this would be ran every month to give me a report.

I currently have a SQL query that I run for SQL EXPRESS that I play around with but I'm not sure if this is the right approach.

Thanks.

I attached my current query and results for one batch Ideally I would like to have it by date so I can run it every month and export to excel

Was this article helpful?

0 out of 0 found this helpful

Comments

3 comments

Sort by Date Votes
  • Avatar
    Permanently deleted user
    I made my query but my question is should I select in event log or another table?

    I'm asking because there seem to be missing batches in EventLog Table I guess that table gets flush depending on the configuration for clean the eventlog in monitoring console.
    0
  • Avatar
    Permanently deleted user
    Hello,

    Eventlog is the most common table to use for making reports, but additional information can be found in other tables such as Batches.
    Eventlog can be flushed depending on your settings in monitoring console, information in other tables such as Batch is also updated according to batches in FlexiCapture.

    If you need to create a report using crystal reports you can find more information in Developers help file.

    Regards
    Tim





    0
  • Avatar
    Permanently deleted user
    So if I sent my settings to be flushed at 180 days and run the report every end of month for the previous one I should be good.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post