Home > Crystal Reports > Crystal Reports Error A Number Range Is Required Here

Crystal Reports Error A Number Range Is Required Here

I need to pass the value(s) from this prompt to a subreport so I have created this formula field which I have seen in many of the posts:WhilePrintingRecords;Shared numberVar counter;//increments the Get 1:1 Help Now Advertise Here Enjoyed your answer? I put a textbox on the web form to show the session ID where the crystal report viewer is and that works. Seriously it's simple task but tricky, you could solve this. his comment is here

Your Email This email is in use. They must match. thatraja 24-Feb-14 8:37am Just change the formula, yours only one parameter. I got the parameters to InStr backwards. http://stackoverflow.com/questions/4553185/crystal-report-with-error-a-number-range-is-required-here

What is the reason for returning this number ... I deleted the Parameter Field. I would move the 'IF' to the beginning of the first line and that should get you closer to the correct result. thatraja 21-Feb-14 10:07am /* This is the Selection Formula that I have and it doesn't work */ What do you mean it doesn't work?

This is the Selection Formula that I have and it doesn't work. It's simple Computer Wiz99 24-Feb-14 8:39am I am trying that now. It should beCopy Code InStr({[email protected]}, "|" + ToText({spCSSReportNCounts1;1.DOUNum},0,"") + "|") > 0 HTH,Carl 0 Likes 0 View this answer in context 7 replies Share & Follow Privacy Terms of Use Legal Not see your data that matches 12.

mlmcc 0 LVL 26 Overall: Level 26 Crystal Reports 26 Message Active 1 day ago Expert Comment by:Kurt Reinhardt2005-03-08 Comment Utility Permalink(# a13490225) 1) It looks like you've set up thatraja 24-Feb-14 8:58am Did you try {TableCOCINST.inst_id} = CInt({?inst_id})? Computer Wiz99 24-Feb-14 8:55am Error,"A number, currency amount, boolean, date, time, date-time, or string is expected here." No luck. http://www.tek-tips.com/viewthread.cfm?qid=873256 Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Please support the forum! This thing is to verify that your formula is working in preview mode. I want to incorporate those reports into an application whereby when a user clicks on a menu item … Need help with small Crystal Reports error! 4 replies Hey guys!

vb.net This question has already been answered. I've tried entering a number 1 also. Tell others by linking to it on your blog or website:Crystal Reports Forum IP Logged Printable version Forum Jump -- Select Forum -- Announcements Talk with the Author Self-Publishing Job I'd recommend that you troubleshoot that first. ~Kurt 0 Featured Post Free Trending Threat Insights Every Day Promoted by Recorded Future Enhance your security with threat intelligence from the web.

They must match. this content I can put in the same code but CR says it is an error. Covered by US Patent. Computer Wiz99 24-Feb-14 8:49am My Select Expert -- Record formula is not going so well.

That is how I keep my session. And this will read the session value in the text box right? can someone please tell me how to correct it. {SUPPLIERS.SUPP} = {?SUPPLIER} //change = to IN if you allow multiple parameter values Full Code : {ORDERS.DTE} In {?DTE} AND IF http://comscity.net/crystal-reports/crystal-reports-error-a-required-resource-was-unavailable.html If I enter the syntax in CR like this, {COCINST.inst} = 10000, the report will build for that ID.

I wish we could use Adobe Connect. Lucas_10 16 posts since Oct 2016 Newbie Member adding images before a game in pygame Last Post 1 Day Ago Hi, i was want to add an image that is displayed You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

I have updated my code in the question and added the error I get.

Crystal report viewer's? I have this: {TableCOCINST.INST_ID} = '?inst_id' as my formula and it keeps saying that "A Number is Required here." What am I doing wrong? I have a parameter called company code(0cop_code in BW) from the bw which has the following options below.multiple values - truediscrete values- trueranges - trueI need to display this parameter values rhys1619 13 posts since Oct 2015 Community Member Mod- unexpected result Last Post 1 Day Ago I am getting an unexpected result when using mod '%' in Python.

You'll also learn how to use your custo… MS Excel Fonts-Typography MS Office How to create built-in UI screens with Adobe XD Video by: Bob When you create an app prototype Magesh Anandan May 10, 2011 at 15:16 PM 0 Likes Correct Answer Debi Herbert replied May 11, 2011 at 17:47 PM Agreed, a parameter with multiple values is an array, but Right now when a user is logged on and clicks the print button a print preview pops up and shows the report. check over here You should apply with hardcode value like {COCINST.inst_id} = 100.

Right now I can put the ID in the formula and that report loads and word but that will not work because every user will print that report that is not The values for all of the prompts are number values. I am using CR 2008 and SQL Server 2005. Magesh, Take a look at the function MakeArray() and see if you can make it work for you.Edited by: Debi Herbert on May 12, 2011 12:22 PM :Is your parameter a

Computer Wiz99 20-Feb-14 10:10am k07, I put the code you gave me in but the error pops up asking for a number. Where did "CInt" come from? I use this: TextBoxINST_ID.Text = Session["inst_id"].ToString();. thatraja 21-Feb-14 11:00am /* I can put in the same code but CR says it is an error. */ Always tell us error details :'( Include that.

If it's working then you could use dynamic value in coding(like session). See this example, Crystal reports - Creating Record Selection Formulas[^] What's the datatype of INST_ID? or reports with all data? Everything looks and work fine on the report.

Can this work this way? That subreport has the DOUNum field in it and that field is a numeric field, so when I try to put this in my record selection formula:{spCSSReportNCounts1;1.DOUNum} in [{[email protected]}]I get this Insults are not welcome.