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

Crystal Reports Error A Number Range Is Required Here

And this will read the session value in the text box right? 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 sm trying to get it to do the same just by reading the session value in that text box. I will put this same formula in my code behind in page_load along with the session to pull the right data? Check This Out

You should apply with hardcode value like {COCINST.inst_id} = 100. thatraja 24-Feb-14 8:48am Inside your report, your formula should be like below, {?inst_id} is parameter field {TableCOCINST.inst_id} = {?inst_id} Now assing the value to parameter field from session in Computer Wiz99 24-Feb-14 8:30am Only problem is that it is not a Date Range. Remove the code from Page_Load() Permalink Posted 19-Feb-14 22:32pm thatraja248.5K Comments Computer Wiz99 20-Feb-14 10:12am thatreja, The data type is int for INST_ID. http://stackoverflow.com/questions/4553185/crystal-report-with-error-a-number-range-is-required-here

Tell others by linking to it on your blog or website:Crystal Reports Forum IP Logged DarlaE Newbie Joined: 03 Oct 2008 Online Status: Offline Posts: 2 Posted: 03 Oct thatraja 24-Feb-14 8:37am Just change the formula, yours only one parameter. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ

thatraja 24-Feb-14 5:29am Which textbox? I deleted the Parameter Field. I have tried "blit" and a few other thinks to try and get the image to appear ... Recursos de aprendizaje Microsoft Virtual Academy Channel 9 MSDN Magazine Comunidad Foros Blogs Codeplex Soporte técnico Autoasistencia Programas BizSpark (para empresas nuevas) Microsoft Imagine (for students) Faculty Connection Microsoft Student España

Computer Wiz99 24-Feb-14 8:55am Error,"A number, currency amount, boolean, date, time, date-time, or string is expected here." No luck. No se por que el error y soy novato utilizando cristal. ¿Podríanayudarme por favor? The lowest level prompt is a multi value prompt. http://www.tek-tips.com/viewthread.cfm?qid=873256 I got the parameters to InStr backwards.

I need a little help with Crystal Reports!The Report keeps repeating the details.I tried to group it by the reference number but it … Crystal Reports Keeps Duplicating! 7 replies Hey It hightlights the '0' that I have entered in the if line. los valores solamente deben ir separador por como y dentro de [], si te das cuenta el mensaje de error te manda un select con losparámetrosdel IN dentro de '', revisa 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

Where did "CInt" come from? Do you need your password? Where are you adding this? 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?

Saber más Developer Network Developer Network Developer :CreateViewProfileText: Iniciar sesión Suscripciones a MSDN Obtener herramientas Descargas Visual Studio Acceso a la suscripción de MSDN SDK Software de prueba Descargas gratuitas Recursos his comment is here Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 thatraja 24-Feb-14 9:08am Will reply after 3 hours Computer Wiz99 24-Feb-14 9:08am Ok. If there's no matching records for that ID(based on session value), then the report will be empty.

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 They must match. Add a Solution Add your solution here B I U S small BIG code Plain TextC++CSSC#Delphi / PascalF#HTML / XML / ASPJavaJavascriptObjective-CSQLSwiftPerlPHPPythonVBXMLvar < > & link [^] encode untab case indent this contact form I have a main report that has a six level cascading prompt.

The textbox is not a text change event. I put a textbox on the web form to show the session ID where the crystal report viewer is and that works. Like below {TableCOCINST.inst_id} = CInt({?inst_id}) Computer Wiz99 24-Feb-14 8:52am Ok.

if {InsLine.LineAnnualizedPrem} >= 0 then Maximum({InsCovTerm.CovTermVersion}) else 0 and{InsPolicy.PolExpDate} > DateTime (2008, 09, 01, 00, 00, 00) and{Entities_BCO.EntLookup} = "enco" Darla IP Logged BrianBischof Admin Group Joined: 09 Nov 2006 Online

Removed single quotes. 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? Linux questions C# questions ASP.NET questions fabric questions SQL questions discussionsforums All Message Boards... Let's work to help developers, not make them feel stupid.

If it's string then you should enclose value with single quote like below CrystalReportViewer1.SelectionFormula = "{TableCOCINST.inst_id} = '10000'"; And why did you paste the code in both events? Which version of Crystal? El contenido solicitado se ha quitado. navigate here SolutionsBrowse by Line of BusinessAsset ManagementOverviewEnvironment, Health, and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning

All rights reserved. What am I doing wrong? Get 1:1 Help Now Advertise Here Enjoyed your answer? 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

Why is that? What is the reason for returning this number ... I am using CR 2008 and SQL Server 2005. Rate this: Please Sign up or sign in to vote.

I can put in the same code but CR says it is an error. When answering a question please: Read the question carefully. All Rights Reserved. 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

Computer Wiz99 24-Feb-14 8:01am No. Will reply you later(after 1 & 1/2 hour). Insults are not welcome.