Adding Parameter Field to a Formula
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21961
Printed Date: 07 May 2024 at 6:25pm
Topic: Adding Parameter Field to a Formula
Posted By: chrisfaw
Subject: Adding Parameter Field to a Formula
Date Posted: 11 May 2016 at 2:02am
Hi
I am quite new to cr and I am struggling with a parameter field
I am using a SAP B1 query and I have created a report which I wish to add my own parameter field to a formula
The parameter I need is for an actual exchange rate and will look something like the below
if {Command.TotalFrgn} = 0 then {Command.LineTotal} else {Command.TotalFrgn} / {?My Parameter}
I have tried to set this in the selection expert and record but CR will not allow me. Is this possible in CR.
Please advise?
|
Replies:
Posted By: kevlray
Date Posted: 11 May 2016 at 4:00am
First off, I do not believe the selection expert is the place to go for that formula. But you should be able to create formula (formula expert) and put that formula in the report.
|
Posted By: chrisfaw
Date Posted: 11 May 2016 at 5:16am
Thanks I didn't have the parameter set as a number which is why it was not populating. .. doh
Just on another topic I have managed to get the report run ok in CR and previewed in sap, however when SAP prompts me to add the CR parameter it will not allow me to add a decimalised number. Could that be an issue with CR.
I have added the parameter field to my report to check the format of the parameter which is decimalised but it still will not allow me?
Regards
Chris
|
Posted By: kevlray
Date Posted: 11 May 2016 at 10:55am
I have never needed a decimalised number as prompt before. Not sure why it would not work. Can't help with this one.
|
|