daily cash balance report 20610d

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Carolyn Kolpien on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

eleanor

Was this reply helpful? Yes No
dnlchristanto 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No