I would like to customise the daily cash balance report (20610d). I would like to add some fields from the apdoc and catran tables; however the report has other tables i.e. wrkcabalances and wrkcadetail. These appear to be populated by a procedure. How would i identify and modify this procedure.
Eleanor Katongole
you can just edit it with crystal report 2008 and add the tables in that report.
with that crystal report 2008, you can play your any report as you wish..
even you can choose which user that can see specific bank..
something like that..
Regards,
Daniel
Thanks Carolyn, i think let me just add the tables instead of trying to ammend the stored procedure
eleanor
Hi Eleanor,
I don't recommend changing the stored procedures. You can just add the tables you mention to the report and link them to the work tables.
I usually use SQL Profiler to find out how a report works. You can find instructions and our recommended template on CustomerSource by doing a search. I found the articles at mbs2.microsoft.com/.../search.aspx
Just use the instructions and template that match your version of SQL Server. Be sure to load the template before running your trace.
Let me know how it goes or if you have additional questions.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,552
Super User 2024 Season 2
#2
Martin Dráb
228,552
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (