Could not set "Fixed Currency" symbol on subreport

[japss1977]

Would appreciate if someone could give me a solution! It is really killing me!!!!!!

I have a subreport that prints order details like Qty, Price, Desc and the Total Amount (quantity x price)

I want to format the currencies (Price and Total Amount) to "Fixed Currency" symbol - not floating currency symbols. I set it through the formatting property of the Price and Total fields but it does not seem to be taking the setting when it gets displayed. It just looks like "Floating Currency" symbol. However, the amount fields in main report prints perfect with "Fixed Currency" symbols.

This subreport is not a separate .rpt file. It is part of the main .rpt file. Does it make the difference???

And I am using CrystalReport.NET on VS2005 SP1

Thanks in advance!

 

[lbass]

I just tested this in XI, and I was able to format the currency within the sub to fixed format. Are you formatting the currency separately in both the main and the subreport? The formatting in the main report does not get carried over to the subreport.

-LB

 

[japss1977]

I am setting the format only at sub-report's detail section for those two currency fields. I have 3subreports linked from the main page. All 3 have the same issue. However, if I write a currency field in the detail section of main report and format the field, it comes up with right format. Is there any alternate or workaround to this problem?
Thanks!

 

[lbass]

I'm not sure what you mean by setting the format only at the sub's detail section--you are formatting the fields, not the sections. If you have a summary on the field, it would have to be formatted independently of the field itself.

-LB

 

[japss1977]

sorry for not being clear...Both the fields (Unit price and Total) are in the detail section of the subreport and both are formatted. Just right click on the field and set "Fixed" currency.
I do not have any currency field at the main report. I have created three details section (right click on detail section and select Insert Section Below option). Each of the detail section has one subreport each. So, the main report has four detail section 1 for the header information and 3 other detail section are for 3 subreports.
For testing purpose, I created one currency field at main report and it display fixed currency symbol correct but all of the 3 subreports always display at floating currency style.
Hope it clarifies!

 

[lbass]

I'm not sure what features the Net version has, but within each subreport, try going into Report->Options->Fields->Currency->Number and set the fixed symbol there. Not sure it will help, as I think what you already done should have worked. I just thought maybe the reports were for some reason reverting to the default set in the Options tab.

-LB