Share
ReportI was just wondering if anyone knows what triggers the table vr_08610dp to populate when an Aged AR report is printed?
Thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
160
I was just wondering if anyone knows what triggers the table vr_08610dp to populate when an Aged AR report is printed?
Thanks
*This post is locked for comments
Because, as you saw, that report uses only one object (the view), and there must exist a way to avoid clashes if multiple users run the same report simultaneously, the Aged AR reports (each report format is a separate Crystal report) use a pre-process (the PB_08610 SQL stored procedure) to jam the RI_ID (the unique identifier temporarily assigned each report user) into the WHERE clause used to execute the SQL (view, in this case). If you use just vr_08610dp as your "table" for your report, this will still work if you add the new report as an additional format under the Aged AR report. If, however, you instead add it to Solomon as a new report on the menu, you'll need to put that stored procedure name in the Pre-Process Name field on the Control Options form in Report Control Maintenance.
You don't need to recreate the view. Just use the same view in the new report that you create from scratch. When you get data just grab this view. (Personally, I would just take the existing crystal report, make a copy and then modify it as needed....so I don't need to recreate everything.)
FYI. The 8 tables are used in the view vr_08610dp are:
ARDoc AS d -- being the most important table!!
Customer AS c
AR_Balances AS b
Terms AS t
ARStmt AS s
RptRuntime AS r
RptCompany AS y
ARSetup
Thanks for the reply.
I understand what you are saying about it being a SQL View. If I open 08610dp (Aged Receivables Detail) in Crystal reports, the only table selected is vr_08610dp. If I wanted to create a brand new report based on vr_08610dp, how would I go about this? Somehow, running the Aged Receivables report tells it to get the current data from the tables when the report is run.
Hi!
First of all, vr_08610dp is not populated because it is a SQL View so every time it is run, it will retrieve current data from the tables it uses. Now, if you run it in SQL Query Analyzer, it will return 0 results if the Aged AR report is not open because one of the tables that is linked in the view, is rptruntime, that only holds a record while the report is open.
Let me know if this helps.
Miguel Otero
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
