Crystal Reports :: Always Blank But DataSet Has Data?
Mar 12, 2011
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,
is there a way in crystal report to remove blank space between two data field for example
Field 1 Field 2
how do i make it the distance between Field 1 and Field 2 become closer and look like this
Field 1 Field 2
without changing the position of the Field 2 in the report design... i need this cause the data in Field 1 is different for each user and i need the Field 2 to have a smaller font size than the Field 2 so i cant use formula since formula only allow 1 font size.
i cant access crysrtal report after deployment in IIS i have depolyed my website the pages where my crystal report is just blank .. how can i access crystal reports????
I have no problems viewing data on local machine but for some reason I cannot view that same report on the web. When i view source of the web page I can see data inside the javascript but the page is blank. What could I be doing wrong?
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.
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 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 have a simple crystal report created on VS 2008 .net 3.5 sp1. The report works when I run it from the local host connecting directly to the live hosted database. When I copy the files to the host server it connects with out error but at the point where the report viewer frame would appear I get a blank page and Done displayed on the browser status bar.
The host server has Crw server installed on it and other websites on the same server are working OK.
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 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.
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 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'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.