daily cash balance report 20610d

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

*This post is locked for comments

All responses (3)

Answers (0)

dnlchristanto 45 on at

Like (0)

Report

RE: daily cash balance report 20610d

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
Community Member Microsoft Employee on at

Like (0)

Report

Re: daily cash balance report 20610d

Thanks Carolyn, i think let me just add the tables instead of trying to ammend the stored procedure

eleanor
Carolyn Kolpien on at

Like (0)

Report

Re: daily cash balance report 20610d

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.