Crystal Reports Error Invalid Argument Provided
Contents |
printing a Crystal Report based on a stored procedure using GP Reports Viewer: "Invalid argument provided" "Login failed" "Failed crystal reports xi invalid argument provided to open the connection. Details: [Database Vendor Code: 17]" Another symptom crystal reports invalid argument for database of this issue is if the database the report is based on does not switch automatically to
Syspro Invalid Argument Provided
the current Dynamics GP company using GP Reports Viewer. SOLUTION: Please contact us by emailing support@flex-solutions.com or clicking new above to start a new support incident. We
Crystal Report Viewer Invalid Argument Provided
will send you a new GPReports.exe file. Steps to install it: Rename your existing GPReports.exe file located in your GP installation directory to GPReportsOLD.exe Unzip the file and remove the '.rename' file extension so that the file is now called GPReports.exe and copy it into your GP installation directory Right click on the new GPReports.exe file and crystal reports an invalid argument was encountered choose Properties, if you have an Unblock button at the bottom, please click it and choose Apply, then OK to close the Properties window Launch Dynamics GP and try to print the report you were having trouble with again If you receive an Open File - Security Warning saying that the GPReports.exe is from an Unknown Publisher, uncheck the box at the bottom left for Always ask before opening this file If you are still having trouble printing the report properly after this, please let us know. FIXED: The fix for this issue is included in builds 60 and higher for GP 2010. SOURCE: Support Ticket 1409 KB ARTICLE: 21809891 LAST UPDATED: August 9, 2012 Was this article helpful? 0 out of 0 found this helpful Facebook Twitter LinkedIn Google+ Have more questions? Submit a request 0 Comments Article is closed for comments. Related articles "Failed to retrieve data from database. Details: [Database Vendor Code: 911]" when printing Crystal report Powered by Zendesk
here for a quick overview of the site Help
Crystal Reports An Invalid Argument Was Encountered Saving
Center Detailed answers to any questions you might have Meta syspro crystal reports viewer invalid argument provided Discuss the workings and policies of this site About Us Learn more about Stack crystal reports invalid argument provided invalid argument for database Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask http://support.flex-solutions.com/hc/en-us/articles/218197727--Invalid-argument-provided-error-when-printing-a-Crystal-Report-based-on-a-stored-procedure Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Crystal report viewer giving me error : “Invalid Argument provided. Failed to open a rowset.” up http://stackoverflow.com/questions/16620846/crystal-report-viewer-giving-me-error-invalid-argument-provided-failed-to-op vote 0 down vote favorite i am having a crystal report , that is to be filled with stored procedure, but when i put any parameter of procedure in .rpt file it is giving me error like "Invalid Argument provided. Failed to open a rowset." my code is as below : public void GroupwiseRegistrationReport() { SqlConnection connection; DataSet ds = new DataSet(); DataTable dt = new DataTable(); connection = gen.con; string SP = ""; SqlCommand command = connection.CreateCommand(); SqlTransaction transaction = null; try { connection.Open(); transaction = connection.BeginTransaction(); if (rblReportFrom.SelectedValue == "0") { SP = "SPGroupwiseIndustriesEM1Report"; } else { SP = "SPGroupwiseIndustriesEM2Report"; } ValueData = new ArrayList(); ParameterData[0] = "@fromdate"; ValueData.Add(txtTotalBetweenFrom.Text.ToString().Trim()); ParameterData[1] = "@todate"; ValueData.Add(txtTotalBetweenTo.Text.ToString().Trim()); ds = gen.FunSearch_Trans(ParameterData, ValueData, SP, transaction, command); dt = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { if (rblReportFrom.SelectedValue == "0") { repdoc.Load(Server.MapPath("~\\admin\\Reports\\Groupwise-EM-I-Registration-Report.rpt")); } else { repdoc.Load(Server.MapPath("~\\admin\\Reports\\Groupwise-EM-
Dec 2007 Location: United States Online Status: Offline Posts: 19 Topic: Invalid Argument ProvidedPosted: 21 Feb 2008 at 6:48am Hello. This question may be too general to answer, but if someone could http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2399 offer any guess or suggestion, it would be appreciated. I have https://social.msdn.microsoft.com/Forums/en-US/33397df0-2492-423e-93cd-7262cd620307/invalid-argument-for-database?forum=vscrystalreports a report that was working fine, that is suddenly no longer running, giving me an error message that states "Invalid Argument Provided." I get no follow-up message to tell me what the Invalid Argument is, so I don't have any real way of researching what might've changed that is making the invalid argument report stop running. It reads records for a while, and then just halts and the message pops up. Does anyone have any clue what might be wrong? The report has parameters, and what's really strange is that if I use a from and thru date of 02/01/08 thru the current day, it'll run. But then I'll refresh and use a from date of invalid argument provided 01/01/08 thru the current day, and I get this message. I thought maybe I was dividing something by zero or that there may be some other calculation giving it grief in the report, but I'm not doing any sort of calculations like this in this report. I realize "Invalid Argument Provided" is pretty generic, but unfortunately it's all I have to go on, and any guess as to what I might look into would be appreciated! Thanks, Mike IP Logged BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2460 Posted: 21 Feb 2008 at 5:27pm I'm guessing that the database has some type of invalid data prior to 2/1/08. I would try more date ranges and make them smaller and smaller ranges to see if you can find a specific day that causes the problem. Then look in the database to see if you see anything unusual on that day. Please support the forum! 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
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Invalid argument for database Archived Forums C-D > Crystal Reports for Visual Studio (Retired) Question 0 Sign in to vote Hi, I have a report that is connecting to two different databases and retrieving data from a stored procedure in each. My problem is that when I try and set the destination of the database at runtime, I get the following error: Invalid Argument provided.Failed to open a rowset.Error in File C:\DOCUME~1\JAMES\LOCALS~1\Temp\temp_{5E8F9D66-6EFF-47E9-96F7-65D32A761DCC}.rpt:Invalid argument for database I have other reports connecting to the two databases and I am setting their destination at runtime with no problems. The only difference in this report is the fact that it is using stored procedures rather than tables directly. Strangely enough, when I set the designtime location of the database to be the location that i am setting it at runtime (i.e. point it to my live databases instead of my local development copy), the report runs fine - even though my code is still passing it logoninfo. My code for setting the logoninfo is as follows. //-------my code for setting the logoninfo--------- private void SetDBLogonForReport(ConnectionInfo db1ConnectionInfo, ConnectionInfo db2ConnectionInfo, ReportDocument reportDocument) { Tables tables = reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { TableLogOnInfo tableLogonInfo = table.LogOnInfo; if (string.Compare(table.LogOnInfo.ConnectionInfo.DatabaseName, db1ConnectionInfo.DatabaseName, true) == 0) { tableLogonInfo.ConnectionInfo = db1ConnectionInfo; } else if (string.Compare(table.LogOnInfo.ConnectionInfo.DatabaseName, db2ConnectionInfo.DatabaseName, true) == 0) { tableLogonInfo