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,
View 7 Replies
Similar Messages:
Jun 21, 2010
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.
View 5 Replies
Nov 12, 2012
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????
View 1 Replies
Feb 7, 2011
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?
View 2 Replies
Oct 26, 2010
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.
View 1 Replies
Nov 10, 2010
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?
View 1 Replies
May 22, 2010
I want to bind dynamic dataset to my crystal report. Dataset come from store procedure with pivot.
following is my sp and code.
[Code]....
[Code]....
View 1 Replies
Apr 14, 2010
I am new to crystal reports and I would like to know to create reports using untyped datasets instead of typed datasets.
View 1 Replies
Oct 26, 2010
i am using untyped dataset to bind the data to crystal reports.
View 1 Replies
Dec 17, 2010
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?
View 1 Replies
Apr 23, 2014
VS2010/sqlserver/crystalreport13
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"))
[CODE]...
View 1 Replies
Jun 16, 2015
[URL] ....
I followed above link to create sample Crystal Report Project. Here is my code:
string conStr = ConfigurationManager.ConnectionStrings["MasterDb"].ConnectionString.ToString();
protected void Page_Load(object sender, EventArgs e) {
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("~/CrystalReport1.rpt"));
DataSet1 ds = GetData();
crystalReport.SetDataSource(ds);
[Code] ...
When I run my project, blank page renders. No Crystal report is displayed.
View 1 Replies
Jan 26, 2011
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.
View 1 Replies
Feb 24, 2010
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:
[Code]....
View 1 Replies
Nov 11, 2010
using vs.net crystal reports 2005
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.
View 1 Replies
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.
View 4 Replies
Aug 5, 2010
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.
View 2 Replies
Feb 25, 2010
Is it possible to configuring a Report.rdlc without using of DataSet?
View 2 Replies
Sep 30, 2010
I have designed a DataSet which contains two TableAdapters. I want to Bind That dataSet with two table adapters how to do this?
Code:
[Code]....
My Code runs without error but it shows a blank report.
View 1 Replies
Nov 25, 2010
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.
View 3 Replies
Jan 4, 2011
I tried to bind a dataset to a cyrstal report viewer in asp.net as follow,
[Code]....
But nothing happens. What can be the problem? Is there any other way?
View 3 Replies
Nov 19, 2010
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.
View 1 Replies
Nov 11, 2010
I'm currently using VS 2008 and I am trying to make my web application to print only 1 specific data set from my SQL database.
For example, i got 3 rows of data sets, how can I choose only 1 data set to be printed?
string reportPath = Server.MapPath("CrystalReport2.rpt");
View 1 Replies
Jun 13, 2010
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.
View 1 Replies
Jul 16, 2010
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.
View 9 Replies