Do either of you have experience with SSRS? I have always just formatted my fields right then and there in the expression without any care or consideration to the format that the parameters are trying to pass into the report presumably from the RDD. But it looks like if I can change that one format, it would fix all my fields at the same time. Do either of you know if you can influence this parameter format? Like as far as decimal places, etc?
Yes, I do… all bad!!! Ask me anything you want about sales taxes and I probably can help you… do that with SSRS and I run away!
1 Like
You can get rid of the formatting expression altogether and use the field formatting instead from the properties menu for the textbox. That’s the only way I know of. You could alternatively make a custom field in your RptParameter dataset and name it he same as that FieldsDecimalsPrice and give it the appropriate format- this last suggestion would do what you want.
Go query the rptparam table and see what value is in the Fields.DecimalsPrice field. Then replace that wiht the value that gives you the formatting you want.
@dr_dan like this, if you modify that field in the select statment and just replace it with a value that gives you the format you want, just alias it with [DecimalsPrice] and then it will be used everywhere in the report where DecimalsPrice was used to format.
@dr_dan this begs the question as to where we can change this globally so we don’t have this weird workaround that is report by report/report specific…
Alex Av. would probably know.
This is absolute anarchy! So, I did as you suggested (sort of) and deleted the standard field in the RptParameter dataset for DecimalsPrice and then replaced it with a calculated one that I set to 2 (which refers to the number of decimal places). This worked great. However, I tried to get cute and I created a new field for DecimalsPercent, because I wanted the tax percent to go to 3 places. And I get this blurry nonsense. Turns out, there are two fields placed directly on top of one another. So changing one, the other one behind it is still the default. Ugh. I have it going now but COME ON! Is that just our report? Or is Epicor’s default report doubled up?
It’s the report, check the visibility settings on both text boxes and figure out if they have, for some reason, some logic in there on that percent field you just changed in rptparameter.
1 Like
@dr_dan oddly enough our users are asking for 4 decimals on the quote form unit price… what did you do in your .rdl to resolve this for your tax field?
I deleted the field on the RDL from the data source that comes by default and then created a calculated field of the same name DecimalsPrice and set the expression to 2. So you’d set yours to 4.
I’ve always assumed (haven’t checked) that the DecimalsPrice value is being taken from Company Configuration:
On premise - you can change this in Admin Console, BUT TEST TEST TEST first!
Cloud - a had a customer last week who requested and received a DataFix to be able to change this value - it’s tied to your install ID though so request from support.
If obviously has impact throughout the application, not just reporting! You have been warned.
1 Like
@markdamen ! Thank you! haha I was trying to find someone that knew how to adjust this globally, I figured this must be a setting you can set company wide.