Home > Crystal Report > Crystal Report Stored Procedure Parameter Cannot Accept Multiple Values

Crystal Report Stored Procedure Parameter Cannot Accept Multiple Values

Just what I needed, quick and no messing about. Here is the code I use:Private Sub CrystalReportViewer1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.LoadDim TestingReport_Param As New TestingReport_Param Dim CRDoc As UserDetailReport = New UserDetailReportDim pubnamereceivedtouse As New please help urgently On Sunday, June 17, 2007 7:26:03 PM yazzy said: Please could someone help me, I am new and I am trying my first ever crystal report. first i created one report(first). Check This Out

Enter the following list in the Value column (leave the Label column blank): Design Engineer, Buyer, Marketing Assistant.In Default values, enter Buyer.Run preview. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Make yourself heard by casting your vote below. 1 2 3 4 5 (Sucks) (Rules) Total number of ratings: 552 Follow me on Twitter Want to be notified of new Insert a sub report and in the sub report link choose parameters @a and @b Once you have selected @a you will see sub report parameter to use at the bottom

How to be Recommended to be a Sitecore MVP Do we have "cancellation law" for products of varieties At delivery time, client criticises the lack of some features that weren't written I do not know how to create such a string from a parameter in crystal reports. –user194076 Mar 10 '11 at 0:38 @user194076 Hopefully that bit of code I Manage Your Profile | Site Feedback Site Feedback x Tell us about your experience... Please help me at the earliest, I have to submit my project.

No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers What is the difference between "veki" and "vekiĝi"? Register now while it's still free! I am unable to pass that kind of query for crystal report.Please help me.

Anyways I need to fix this. On Sunday, November 05, 2006 5:36:01 AM Mohammed Jameel said: Hi;I a report using Sql Stored procedure as a data source, I want to run that report from vba or vb6 Create a main report with main stored proc. i created one parameter in crystal report and i wrote the program from vb such as Me.cryReport.ParameterFields(0) = "SText;" & Trim Me.comVoucharType) & ";False"when i preview the report that's ok.

Try posting your question at a forum like http://p2p.wrox.com.Cheers,Imar On Tuesday, July 11, 2006 4:47:14 AM Tanmay Choudhury said: How do I assign values in text at runtime in crystal report Add the following code to the click handler of a button, the load handler of a form, or any other method that is applicable in your situation: using CrystalDecisions.Shared; ... See my java code below : InputStream is = new FileInputStream(xmlFile); // Path of my xml file int length = is.available(); byte [ ] byteArray = new byte[length]; is.read(byteArray, 0, length); Try the Crystal Reports forum or http://p2p.wrox.com instead.

Its very urgent and i wil b thankful if u can help. A multivalued parameter can be set to more than one value. Unfortunately, I don't have the time to answer each question I get on this site personally.Thanks,Imar On Monday, May 09, 2005 7:23:36 AM thomas said: i tried the code given here To set the multivalue property for a parameter, select the Allow multiple values option on the Report Parameter Properties dialog box.

Parameters!.CountThe number of values in the array. http://outwardsound.com/crystal-report/crystal-report-viewer-cannot-find-dll.html Possible outcomes of fight between coworkers outside the office Why is this C++ code faster than my hand-written assembly for testing the Collatz conjecture? Join Us! *Tek-Tips's functionality depends on members receiving e-mail. after that i created another report sepratly in my project (second).

Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. I think I will just request the users to develop the different scenarios they would want to see and incorporate that in my proc.Thanks again!M. Any suggestions. this contact form The subreport should then contain all the information you want to see.

On Monday, September 18, 2006 6:50:30 AM Vidhan Vijayavergiya said: Is it feasible to work on crystal report 11 in visual basic 6. However, if you want to pass multiple parameter values back to a data source by using the query, the following requirements must be satisfied:The data source must be SQL Server, Oracle, Unfortunately, I don't have the time to answer each question I get on this site personally.Thanks,Imar On Wednesday, June 01, 2005 9:43:38 PM Tamara Dillard said: Thanks for the great article!It

How can I take a powerful plot item away from players without frustrating them?

How do pilots identify the taxi path to the runway? Yes No Tell us more Flash Newsletter | Contact Us | Privacy Statement | Terms of Use | Trademarks | © 2016 Microsoft © 2016 Microsoft

There are loads of results that can help you fix this problem.Cheers,Imar On Sunday, February 05, 2006 6:11:34 AM Shoaib Ata said: I have a main report that has embeded 02 If you use the crystalviewer and set your parameters in the report document and then tie the document to the viewer via report source the parameters don't seem to refresh if Just add the following line after the MyReportObject = New YourReportName line:SetLogonInfo(MyReportObject)Private Sub SetLogonInfo(ByVal myReport As ReportClass)Dim myDbConnectionInfo As New CrystalDecisions.Shared.ConnectionInfoWith myDbConnectionInfo.ServerName = "YourServerName".DatabaseName = "YourDatabaseName"End WithDim myTableLogonInfo As New CrystalDecisions.Shared.TableLogOnInfoDim navigate here For both the main and subreport, am passing same 'sortby' values.parmcmbSortBy.ParameterFieldName = "sortby"discretevalue.Value = GMparmrep2.sortbyparmcmbSortBy.CurrentValues.Add(discretevalue)I dont want CR to ask for parameter becoz it is already passed frm Combobox.

Details about this method ( and some others) are available here: http://www.r-tag.com/Pages/MultivalueParametersWithSQLSP.aspx 0 LVL 100 Overall: Level 100 Crystal Reports 94 DB Reporting Tools 31 Message Active today Expert Comment Just make sure that the ParameterFieldName matches the name of the parameter in the Field Explorer (minus the question mark). I'll be bookmarking your site for sure.