Hi guys i make report as title daily receipt report this report consistof
two tables
G/L AccountG/L Entry this report as followingposted date g/l account no document no amount15/03/2012 12 15 15015/03/2012 12 16 200 15/03/2012 12 17 20015/03/2012 13 18 30015/03/2012 13 19 400i make this report but what i need is to display total for every group in footer section or last of report but not after every group .what i need to show report as following
15/03/2012 12 15 150
15/03/2012 12 16 200
15/03/2012 12 17 200
15/03/2012 13 18 300
15/03/2012 13 19 400
12 550
13 700how i make this as above i make this before by group footer but itdisplayafter every group but not suitable solution for me. sothat to display every group in last of report i need to add new g/laccount have group footer to make this task how i make this.please help me thanks
If you are talking about RDLC reports used by the RTC (Role Tailored Client), then this could be possible, but is not easy. I cannot explain it all here, and actually via our support it would even be a billable service as a customization, but I will try to explain what may work. First, a report in the North America NAV version you could look at that does something similar to this is Report 10040 which is the Aged Accounts Receivable. If you look at the layout, you will see two tables(table1 and Table2) being used, with the one on the bottom(Table1) of the Layout being the one used just for report totals.You will notice that built in Code Functions are needed to get the Totals from the main Table(Table2) used for the data. In the main table(Table2) there is a hidden field you will find which is Textbox72, that stores values into memory in a Code Function called CalcTotalBalance, which those totals are then put into memory and used in the Report Total with another Function called GetTotalBalance. This basically mimics the possibility of a Report Footer as the Totals are in in Table1, in a Footer section using the option to call into the Code Functions found in RDLC. It is extremely hard to explain, so I suggest looking at the Report 10040 and see how it works, which may give you a good idea for your report and how to work it out. If your groups and everything are right, I believe it will work out for you.
Nick
OK if this report made by billable service how much does it cost
You would need to set up a support case so that we could scope the issue and give an estimate. This isn't something we would be able to give a price on without an open case. If interested please open a case with the support department through your partner. Thank you.
Please i don't know the partner because one person work before me in implementation of navision and he leave the place and i not see him.please if you want to help me tell me steps by details and case that i need as above so that if possible you can give me price
thanks
Ahmed,
Depending on your build of NAV, the country you are in, and some other factors the support customization would come from a different support group. I see based on where are are located it would not be our specific support group here in the United States, so please email me nhaman@microsoft.com and i will send you your partners information as I cannot post that here in the public forum. You will need to go through a partner as that is the only way to get a billable service started with Microsoft since you are not on a Premier Plan. Please email me and I will send you the partner information and you can then contact your partner whom will be able to help you out and contact Microsoft if you wish to pursue a possible billable engagement. Please let me know the build of NAV you are currently running when emailing me as well as if you use the RTC reporting or the Classic Client reporting. Thank you.