Hello all,

I got an issues when pass value of Formula Field from main report to subreport Parameter Field in Crystal Report. Here are the steps that I did as following:
1. In main report, I created a TOTAL_AMOUNT Formula Field. I can see that value of TOTAL_AMOUNT when drag and drop it on main report. There are some other column field in main report.
2. I created a subreport in the GroupFooterSection of main report (not in the section details). In this subreport, I used the store procedure as a Crystal Report datasource. Therefore, Crystal Report to ask for enter parameter value and and just set NULL and ignore them at this step. Next I went to subreport and right click on it that will pop up the panel window and choose the option Change Subreports Links ..then opened Subreport Links to allow us setting the Available Fields to link the fields to subreport parameter. I linked three database fields from main reports to subreport parameter, and one dynamic formula field from main report to subreport parameter.
3. when I ran the application, the report showed the results of database field but not the result that associated to Formula Field

I found the interested thing if I click on the subreports area, it will popup another tabpage to show the result of missing TOTAL_AMOUNT field. I really got stuck in this issue. Any option to set between main report and subreport in order to asynchonize for displaying the results ???

Any helps or codes to solve this issues, I really appreciate it. Thanks in advance.

Edited by avt2011 - 19 Mar 2011 at 9:19am

Hello,

I found the solution why it did not display the TOTAL_AMOUNT on subreport because the size was too small when created the sub-report. I increased the size and the amount showed up the missing result. Thank anyways.