I need to link 2 stored procedure in crystal report, passing same parameter id, i tried but getting error
"Unable to connect: incorrect log on parameters."
in this way i'm creating report.
1) Create Dataset(myTable.xsd) in App_Code folder
2) Create a blank Crystal Report, Field Explorer getting Database Fields, from Database Expert (ADO.Dataset Objects), selecting the
I'm working on a vb.net windows project using crystal reports for report generating.I'm using stored procedures as well.Stored procedures are used by crystal reports.When I run report with some parameters it gives error,like this " Unknown Query Engine Error ".I have checked the Stored Procedure and there is no problem with the SP, no extra parameters.
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
I created a CR which data source is a store procedure. Within the store procedure there is one parameter. How to pass a value to the parameter and display CR on the screen?
I have store procedure: ALTER PROCEDURE dbo.GetAllInfoFromUsers(@name varchar(50)) AS select id, userName,password, role from tbl_users where userName=@name
I am trying to create dataset (.xsd) and link it with stored procedure in MySQL database. the problem is when i connect it it's changing the schema name. like if I have this stored procedure name or table name or whatever :
News.tbNews the builder it self change it to :
def.News.tbNews. MySql version 5.5.8, MySqlConnector 6.3.4 I searched for a solution for this problem and one of the answers was to change the MySqlConnector from 6.3.4 to 6.3.6 !!! I download the new connector 6.3.6 but it's giving me Error while installing it.
How to display images in crystal report from database am inserting address (image folder) of images into the database, not inserting images into the database...
I am new to this. I have ReportingViewer in my toolbox, and the report is set up and running correctly. However, the 3 parameters should be provided by the web page and not entered by the user in the report itself.
i hve crystal report which is wrking perfectly fine.. now i want to add paramter to my stored proc... but i am not able to add the same parameter on crystal report..i tried to add parameter in the parameter fields the crystal reports field explorer.. but when i verfiy database it still gives msg stored proc expects parameter which was not supplied..SQL State 42000 native error..
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
I am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
I have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
I have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.