a number is required in the selection criteria when using a parameterSet Number Format for dynamic parameters in Crystal ReportSelect criteria not working in Crystal Reports and Visual Studio 2010Crystal selection formula that would bring based on first parameterPass Formula Field into Parameter FieldCrystal Reports Leaving out parameterHow to use Parameter field in a record selection “like” statement?Handling Optional Parameters when running Crystal Reports 2011 report from C#How to write crystal report formula condition correctlyformula to select a year using crystalCrystal Reports: multiple value selection not displaying all values
Why does this London Underground poster from 1924 have a Star of David atop a Christmas tree?
Should I use the words "pyromancy" and "necromancy" even if they don't mean what people think they do?
The term Feed-forward and its meaning?
Why does a sticker slowly peel off, but if it is pulled quickly it tears?
Counting the triangles that can be formed from segments of given lengths
Why is sh (not bash) complaining about functions defined in my .bashrc?
If I said I had $100 when asked, but I actually had $200, would I be lying by omission?
Which meaning of "must" does the Slow spell use?
Can MuseScore be used programmatically?
Why did the population of Bhutan drop by 70% between 2007 and 2008?
助けてくれて有難う meaning and usage
Can I Prove Schröder-Bernstein With Just Definition of Bijection?
Do sharpies or markers damage soft gear?
Can someone identify this unusual plane at airport?
rationalizing sieges in a modern/near-future setting
Why does the `ls` command sort files like this?
Why does matter stay collapsed in the core, following a supernova explosion?
Force SQL Server to use fragmented indexes?
How to prevent a hosting company from accessing a VM's encryption keys?
Recommended Breathing Exercises to Play Woodwinds
Can I take a boxed bicycle on a German train?
Why didn't Doc believe Marty was from the future?
Can I get a PhD for developing an educational software?
Time difference between banns and marriage
a number is required in the selection criteria when using a parameter
Set Number Format for dynamic parameters in Crystal ReportSelect criteria not working in Crystal Reports and Visual Studio 2010Crystal selection formula that would bring based on first parameterPass Formula Field into Parameter FieldCrystal Reports Leaving out parameterHow to use Parameter field in a record selection “like” statement?Handling Optional Parameters when running Crystal Reports 2011 report from C#How to write crystal report formula condition correctlyformula to select a year using crystalCrystal Reports: multiple value selection not displaying all values
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am new to CR, and I think this is a complicated question. When a user runs the report, I want the user to input either nothing - which will get everything, or to input the values for that field - to get those specific values. Let me know if I am approaching this right.
I am trying to use a formula in the record selection formula editor. This formula references a parameter. I am trying to use WrkOrder.Center field - which is a number - in my selection criteria.
I am getting the error "a number is required here" in the record selection formula editor. I need to do a totext or cstr ? It just seems to still be incorrect.
if the center is blank then get all centers, else get the selected center input in the parameters by the users running the report.
if ?Center="" then true else ?Center=cstr(WRKORDER.CENTERNBR)
if ?Center = "" then true else ?Center=WRKORDER.CENTERNBR
parameters to get what is either input or get all centers
crystal-reports crystal-reports-2010
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
add a comment |
I am new to CR, and I think this is a complicated question. When a user runs the report, I want the user to input either nothing - which will get everything, or to input the values for that field - to get those specific values. Let me know if I am approaching this right.
I am trying to use a formula in the record selection formula editor. This formula references a parameter. I am trying to use WrkOrder.Center field - which is a number - in my selection criteria.
I am getting the error "a number is required here" in the record selection formula editor. I need to do a totext or cstr ? It just seems to still be incorrect.
if the center is blank then get all centers, else get the selected center input in the parameters by the users running the report.
if ?Center="" then true else ?Center=cstr(WRKORDER.CENTERNBR)
if ?Center = "" then true else ?Center=WRKORDER.CENTERNBR
parameters to get what is either input or get all centers
crystal-reports crystal-reports-2010
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
add a comment |
I am new to CR, and I think this is a complicated question. When a user runs the report, I want the user to input either nothing - which will get everything, or to input the values for that field - to get those specific values. Let me know if I am approaching this right.
I am trying to use a formula in the record selection formula editor. This formula references a parameter. I am trying to use WrkOrder.Center field - which is a number - in my selection criteria.
I am getting the error "a number is required here" in the record selection formula editor. I need to do a totext or cstr ? It just seems to still be incorrect.
if the center is blank then get all centers, else get the selected center input in the parameters by the users running the report.
if ?Center="" then true else ?Center=cstr(WRKORDER.CENTERNBR)
if ?Center = "" then true else ?Center=WRKORDER.CENTERNBR
parameters to get what is either input or get all centers
crystal-reports crystal-reports-2010
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
I am new to CR, and I think this is a complicated question. When a user runs the report, I want the user to input either nothing - which will get everything, or to input the values for that field - to get those specific values. Let me know if I am approaching this right.
I am trying to use a formula in the record selection formula editor. This formula references a parameter. I am trying to use WrkOrder.Center field - which is a number - in my selection criteria.
I am getting the error "a number is required here" in the record selection formula editor. I need to do a totext or cstr ? It just seems to still be incorrect.
if the center is blank then get all centers, else get the selected center input in the parameters by the users running the report.
if ?Center="" then true else ?Center=cstr(WRKORDER.CENTERNBR)
if ?Center = "" then true else ?Center=WRKORDER.CENTERNBR
parameters to get what is either input or get all centers
crystal-reports crystal-reports-2010
crystal-reports crystal-reports-2010
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
edited Mar 29 at 19:40
bstand
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
asked Mar 27 at 20:27
bstandbstand
103 bronze badges
103 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
First thing to check is the data type of your parameter and the data type of database field to ensure they match.
If you edit your parameter the first three controls on the form at the top are Name, Type, and List of Values. The Drop Down Box for Type will identify the data type of your parameter.
To identify the data type of your database field, find the field in the Field Explorer and if you don't already see a data type listed next to the column names for each table, right click on any field name and click "Show Field Type" and this will toggle the display of the field data type on and/or off. Its usually off by default I believe.
In order to use a comparison with the = operator, these two objects must have matching data types. You aren't able to change the data type of a database field, but you can change the data type of your parameter to match it.
Hopefully this will fix your error. The most common cause of the error message you are receiving is when one field is a Number type and the other is a Text type. Functions that convert the data will work in formula fields, but usually will continue to throw errors when used in selection expert formulas.
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385889%2fa-number-is-required-in-the-selection-criteria-when-using-a-parameter%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
First thing to check is the data type of your parameter and the data type of database field to ensure they match.
If you edit your parameter the first three controls on the form at the top are Name, Type, and List of Values. The Drop Down Box for Type will identify the data type of your parameter.
To identify the data type of your database field, find the field in the Field Explorer and if you don't already see a data type listed next to the column names for each table, right click on any field name and click "Show Field Type" and this will toggle the display of the field data type on and/or off. Its usually off by default I believe.
In order to use a comparison with the = operator, these two objects must have matching data types. You aren't able to change the data type of a database field, but you can change the data type of your parameter to match it.
Hopefully this will fix your error. The most common cause of the error message you are receiving is when one field is a Number type and the other is a Text type. Functions that convert the data will work in formula fields, but usually will continue to throw errors when used in selection expert formulas.
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
add a comment |
First thing to check is the data type of your parameter and the data type of database field to ensure they match.
If you edit your parameter the first three controls on the form at the top are Name, Type, and List of Values. The Drop Down Box for Type will identify the data type of your parameter.
To identify the data type of your database field, find the field in the Field Explorer and if you don't already see a data type listed next to the column names for each table, right click on any field name and click "Show Field Type" and this will toggle the display of the field data type on and/or off. Its usually off by default I believe.
In order to use a comparison with the = operator, these two objects must have matching data types. You aren't able to change the data type of a database field, but you can change the data type of your parameter to match it.
Hopefully this will fix your error. The most common cause of the error message you are receiving is when one field is a Number type and the other is a Text type. Functions that convert the data will work in formula fields, but usually will continue to throw errors when used in selection expert formulas.
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
add a comment |
First thing to check is the data type of your parameter and the data type of database field to ensure they match.
If you edit your parameter the first three controls on the form at the top are Name, Type, and List of Values. The Drop Down Box for Type will identify the data type of your parameter.
To identify the data type of your database field, find the field in the Field Explorer and if you don't already see a data type listed next to the column names for each table, right click on any field name and click "Show Field Type" and this will toggle the display of the field data type on and/or off. Its usually off by default I believe.
In order to use a comparison with the = operator, these two objects must have matching data types. You aren't able to change the data type of a database field, but you can change the data type of your parameter to match it.
Hopefully this will fix your error. The most common cause of the error message you are receiving is when one field is a Number type and the other is a Text type. Functions that convert the data will work in formula fields, but usually will continue to throw errors when used in selection expert formulas.
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
First thing to check is the data type of your parameter and the data type of database field to ensure they match.
If you edit your parameter the first three controls on the form at the top are Name, Type, and List of Values. The Drop Down Box for Type will identify the data type of your parameter.
To identify the data type of your database field, find the field in the Field Explorer and if you don't already see a data type listed next to the column names for each table, right click on any field name and click "Show Field Type" and this will toggle the display of the field data type on and/or off. Its usually off by default I believe.
In order to use a comparison with the = operator, these two objects must have matching data types. You aren't able to change the data type of a database field, but you can change the data type of your parameter to match it.
Hopefully this will fix your error. The most common cause of the error message you are receiving is when one field is a Number type and the other is a Text type. Functions that convert the data will work in formula fields, but usually will continue to throw errors when used in selection expert formulas.
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
answered Mar 28 at 19:25
R. McMillanR. McMillan
7691 gold badge2 silver badges10 bronze badges
7691 gold badge2 silver badges10 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385889%2fa-number-is-required-in-the-selection-criteria-when-using-a-parameter%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
