ADO.NET :: Loading Dataset Using Datatabeladapter Crystal Reports?
Oct 22, 2010
I am trying hard to analyse but cant figured it out.I am using a Dataset which has 23 stored procedures (Table Adapters).Depending on the user requirement,I call each Tableadapter and pass the dataset to Crystal reports to display.
Namespace DAL
{
Dataset1 ds = new Dataset1();//Dataset instance is create/////
public dataset getdata()
{----
dataadapter.fill(ds1.sp1);
return ds;
}
public dataset getrecdata(params)
{---------
dataadapter.fill(ds1.sp2);
return ds;} and so on
}
Does the dataset instance gets loaded once or multiple times( as the table adapter calls each timme)Can anyone tell me if this is the right procedure I am following? and also does it work fast?or slows down my project.I am using dataset as input to Crystal reports bcaz thats working good in Design of crystal report as well as it takes dataset as input.
i have developed my asp.net application along wih crystal report .... i need to show loading image on ever client and server side request .... (i.e) like when ever IE progress bar get loading i want to show my gif loading ... after IE progress bar finish its loading, my gif loading image should disappear .
using vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?
I want to export dataset to Excel. I did the following ways:
1) bind a dataset to a crystal report, 2) export crystal report to Excel Can it be done without displaying crystal report and only Excel file? Or, I have to find out a way export to Excel directly from dataset?
I'm using Crystal Reports in a Webform inside of an MVC application. Images in the reports are not being displayed, however, on both the ASP.NET Development Server and IIS 7 (on Win7x64).
I know from a number of other questions similar to this that the CrystalImageHandler HTTP Handler is responsible for rendering the image, but I've tried all of the usual solutions to no avail.
So far, I have
Added the following to my appSettings (via http://www.mail-archive.com/bdotnet@groups.msn.com/msg26882.html) <add key="CrystalImageCleaner-AutoStart" value="true" /> <add key="CrystalImageCleaner-Sleep" value="60000" /> <add key="CrystalImageCleaner-Age" value="120000" /> Added the following httpHandler to system.web/httpHandlers (via http://stackoverflow.com/questions/2253682/crystal-report-viewer-control-isnt-loading-the-images-inside-the-report) <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> Added the following to my Global.asax.cs (via http://stackoverflow.com/questions/2006011/crystal-reports-images-and-asp-net-mvc) routes.IgnoreRoute("{resource}.aspx/{*pathInfo}"); and routes.IgnoreRoute("CrystalImageHandler.aspx");
I am getting the result properly in crystal report.But after few loading,I get report Load failed...error msg.I am using Page_Init for crystal report Page navigation.I am stuck with this
I have a crystalreportviewer bound to a dinamically generated DataSet. The Datatable within that dataset has 2 rows of data, however only the first one is showing on my report.
Here's the code that binds my dataset to the report viewer:
I am attaching a dataset to a crystal report and want to know when I have several rows of items to display on the report how would I display several rows of data in the crystal report.
I am normally using textObjects on the report but it looks like I need some kind of repeating control, something like crystal reports version of a datagrid. I realize that in the part of the report where I need to display rows of product names that I might need to create a sub-crystal report that I attach a sub query to.
I'm having a lot of trouble with this, and all the examples that I've found online tell me different things, so II added a DataSet to my project and added my database table to it. (DataSet should be ready)I added a CrystalReport to my project and in the Details section, I right clicked and chose "Database Expert" under "Database". I expanded "Project Data" and found my DataSet...I selected my table and added it to the "Selected Tables" list.In the CrystalReport designer, I used the "Field Explorer" to add 5 of my database fields (just for testing purposes). The report added their names to the "Page Header" and the fields to the "Details" section.On some button click, I use the following code to show the report:
[Code]....
where "conn" is my global SqlConnection.where "CrystalReportViewer1" is obviously the viewer I have put in my aspx page.where "DataSet1" is the DataSet I created and holds my table.where "CrystalReport.rpt" is obviously the report I created.and I used the following code to make sure that myDS actually was loaded with the data:
[Code]....
So the DataSet is definitely loaded with data, the CrystalReport is found (because before I was having trouble with loading into oRpt), and no exception is being thrown because the "Catch" section is never reached.I'm sure it's something dumb I'm doing, but does anyone have any suggestions? I know if I can figure this little problem out, I can expand it to the more complex things I want it to do. But currently, I can't get anything to show,
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 am havin one join condition in back end and storing the result into dataset and from dataset i am unable to load data into crystal reports nothing is coming only empty report is getting displayed.
I have a report displaying the data for an employee. If I wish to generate report for 2 employee, how I can do to make a single report contains both the data? (e.g.: 1st page display data for 1st employee; 2nd page display data for 2nd employee and so on) I need them to be in the same report/pdf file.
using vb.net 2005 and crystal reports. in the vb.net code I am querying the database, processing the results and then binding to the crystal report.
What I need to do now in the code is this: I need to create a new page to display the results so that there is one page for each row in the dataset that I'm binding to the report.
I have a report which is runnin fine as it is using singe table Dataset(.xsd) . I want to expand the report and use more tables in it to show more information .
How can I do so. I am attaching my present code with this.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim stdate, enddate As Date Dim sql As String start_date.Text = Session("startdate") end_date.Text = Session("endate") Dim dt As DateTime = DateTime.Parse(start_date.Text, System.Globalization.CultureInfo.GetCultureInfo("en-gb"))
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#.
