Crystal Reports
35K
Solutions
15K
Contributors
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
Share tech news, updates, or what's on your mind.
I am at the final stage of getting crystal report to work
in my c# application.
I got to the stage of dragging the CrystalReportviewer to the Report Screen
but found out that the CrystalReportViewer is greyed out (Not Active) and simply
gives me a circle crossed red when dragged which does not get the viewer dragged
See attached screen below:
I believe i have followed all the steps by emoreau except for the fact that this
time around my datasource is not inline but from a database
What do i need to do, to get the Tools/Reporting/CrystalRep
selectable
Thanks
Olukay
in my c# application.
I got to the stage of dragging the CrystalReportviewer to the Report Screen
but found out that the CrystalReportViewer is greyed out (Not Active) and simply
gives me a circle crossed red when dragged which does not get the viewer dragged
See attached screen below:
I believe i have followed all the steps by emoreau except for the fact that this
time around my datasource is not inline but from a database
What do i need to do, to get the Tools/Reporting/CrystalRep
selectable
Thanks
Olukay
2 Comments
I have this script below in my c# application
Its under a click button and its supposed to run a crystal report
[] private void button3_Click(object sender, EventArgs e)
{
var results = GlobalConfig.Connection.Ge
CrystalReportProcessor processor = new CrystalReportProcessor();
LoginDetails._dsData = processor.ToDataTable(resu
DataTable dataTable = new DataTable { TableName = "stateorigin" };
string strFullPath = System.IO.Path.Combine(Sys
LoginDetails._dsData.Write
_rptDoc.Load(System.IO.Pat
//Pass the dataset to the report
_rptDoc.SetDataSource(Logi
//Pass the Report Document object to the viewer
crystalReportViewer1.Repor
}[/code]
The first 3 lines executes without error and gets data from a table in database. (see previous post if required to see the data retrieved from database)
However when i got to the line " LoginDetails._dsData.Write
See error screen below:
Grateful for your help
Olukay
Its under a click button and its supposed to run a crystal report
[] private void button3_Click(object sender, EventArgs e)
{
var results = GlobalConfig.Connection.Ge
CrystalReportProcessor processor = new CrystalReportProcessor();
LoginDetails._dsData = processor.ToDataTable(resu
DataTable dataTable = new DataTable { TableName = "stateorigin" };
string strFullPath = System.IO.Path.Combine(Sys
LoginDetails._dsData.Write
_rptDoc.Load(System.IO.Pat
//Pass the dataset to the report
_rptDoc.SetDataSource(Logi
//Pass the Report Document object to the viewer
crystalReportViewer1.Repor
}[/code]
The first 3 lines executes without error and gets data from a table in database. (see previous post if required to see the data retrieved from database)
However when i got to the line " LoginDetails._dsData.Write
See error screen below:
Grateful for your help
Olukay
I understand that this is not easy to debug and help with but I'm posting some screenshots...hopefully someone can give me an idea where to look and how to do this...
(My first day of working with Crystal Reports and I'm not a CR developer )
1. The report looks like this. You see the tab "Main Report"? I want to add another tab but I don't know how this tab is built. I did a search in the code for "Main Report" and I don't find it. Did a search in stored procs and I don't see "Main Report". Did a search in our Web Services code and I don't see the word "Main Report"
2. The report itself looks like this and I see the file
3. This is the Windows Forms that's the container. Maybe I need to check all the User Controls but still....where is that tab coming from?
It's ok if no one can help. I know it's hard to debug it without the code. I can ask my manager if it's ok to give the code and someone here could tell us how this all comes together.
(My first day of working with Crystal Reports and I'm not a CR developer )
1. The report looks like this. You see the tab "Main Report"? I want to add another tab but I don't know how this tab is built. I did a search in the code for "Main Report" and I don't find it. Did a search in stored procs and I don't see "Main Report". Did a search in our Web Services code and I don't see the word "Main Report"
2. The report itself looks like this and I see the file
3. This is the Windows Forms that's the container. Maybe I need to check all the User Controls but still....where is that tab coming from?
It's ok if no one can help. I know it's hard to debug it without the code. I can ask my manager if it's ok to give the code and someone here could tell us how this all comes together.
Working on my first Crystal Report code. It was done by another developer and now I have to make changes to it.
The datasource is a stored proc. I added a new column.
How can I bind the column from the stored proc to the field? The other fields are already there. It's the Phone field I need to add.
The datasource is a stored proc. I added a new column.
How can I bind the column from the stored proc to the field? The other fields are already there. It's the Phone field I need to add.
I'm monitoring traffic into a facility in real-time and events typically occur in a specific sequence [1-15-10-3] Please refer to insert below. My goal is to group (isolate the mentioned 4 events) so I can determine the total time each transaction took. i.e. referring to the first transaction from below, the vehicle was detected @ eventid1 ( (12:04:05am) and completed his transaction @ eventid3 (12:05:24) = 1min19seconds). There are instances where the sequence is only [1-10-3] and also as visible things can go wrong and you see a [1-1-15-10-3].
The challenge is that I have no field available that identifies a specific transaction and all I have is the expected sequencing of eventid's. I need assistance grouping/isolation a set or completed transaction so I can do the math.
The challenge is that I have no field available that identifies a specific transaction and all I have is the expected sequencing of eventid's. I need assistance grouping/isolation a set or completed transaction so I can do the math.
I am trying to create a .NET report using Crystal Reports.
The 3 steps required to create the report is as shown in the screen below
The first step is to create the DataSource as in the 2 steps below
STEP1 Defining the Report Content
Using the debugger Step1 above appears ok and I am able to go into the method below that actually
writes the dataset.
In STEP2 below the stored procedure tested separately works selecting 2 records from the database (see records below)
STEP2 Loading the DataSet
The 3 steps required to create the report is as shown in the screen below
The first step is to create the DataSource as in the 2 steps below
STEP1 Defining the Report Content
private void CreateDataSet()
{
//Creates a new dataset, 2 datatables and adds data to them
_dsData = new DataSet("Employee");
byte[] arrBytes;
System.IO.MemoryStream ms;
using (DataTable dt = new DataTable("Employee"))
{
dt.Columns.Add("Staff_no", typeof(string));
dt.Columns.Add("Surname", typeof(string));
dt.Columns.Add("Firname", typeof(string));
dt.Columns.Add("midinit", typeof(string));
dt.Columns.Add("DepartmentID", typeof(string));
dt.Columns.Add("Sex", typeof(string));
dt.Columns.Add("GradeID", typeof(string));
GlobalConfig.Connection.CreateEmployeeDataTable((DataTable)(dt));
_dsData.Tables.Add(dt);
}
////Creates a relation between the 2 DataTables
//_dsData.Relations.Add("relCountryStates",
// _dsData.Tables["Countries"].Columns["ID"],
// _dsData.Tables["States"].Columns["IDParent"]);
}
Using the debugger Step1 above appears ok and I am able to go into the method below that actually
writes the dataset.
In STEP2 below the stored procedure tested separately works selecting 2 records from the database (see records below)
STEP2 Loading the DataSet
Crystal Reports
35K
Solutions
15K
Contributors
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
Top Experts In
Crystal Reports
-
1
Mike McCracken15,100 points -
2
Éric Moreau8,150 points -
3
Ido Millet3,100 points -
4
Scott McDaniel (EE MVE )3,050 points -
5
kaufmed3,050 points -
6
Chinmay Patel3,050 points -
7
Chris Stanyon3,050 points -
8
Partha Mandayam2,900 points -
9
James06281,000 points -
10
AmitGK42 points -
11
JasonDove24 points -
12
slfede24 points -
13
emcevoy23 points