コミュニティ

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

この記事は役に立ちましたか？

0人中0人がこの記事が役に立ったと言っています

コメント

3件のコメント

並べ替え基準 日付 投票
  • 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

サインインしてコメントを残してください。

お探しのものを見つけられませんでしたか？

新規投稿