• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 18 views
  • Users 0 members are here
Related

Posting Report Pre-Post Indicator

Former Member
Former Member $organization

Hi all,

We are working on a custom SSRS posting report. We would like to include the "Pre-Post" indicator when a posting has not yet been finalized.

We're having trouble finding the piece of code in the standard report that determines posting status and displays the "Pre-Post."

Any hints on where we might find it?

Thanks!

Parents
  • $organization

    Hi Mara,

    I looked at a trace before of the report and the following query gets run:

    Select COUNT ( *) , MAX ( posted_by ) , MAX ( posted_dt )
    From t_batch a JOIN TR_BATCH_TYPE bt on a.batch_type =bt.id
    JOIN VRS_BATCH_TYPE_GROUP g on bt.batch_type_group =g.id
    Where post_no =32800 and posted_dt is not null

    When the count is greater than 0 then it is a reprint, when 0 then a pre post.

    Jon

     

     

Reply
  • $organization

    Hi Mara,

    I looked at a trace before of the report and the following query gets run:

    Select COUNT ( *) , MAX ( posted_by ) , MAX ( posted_dt )
    From t_batch a JOIN TR_BATCH_TYPE bt on a.batch_type =bt.id
    JOIN VRS_BATCH_TYPE_GROUP g on bt.batch_type_group =g.id
    Where post_no =32800 and posted_dt is not null

    When the count is greater than 0 then it is a reprint, when 0 then a pre post.

    Jon

     

     

Children
No Data