473,769 Members | 2,365 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Example creating Table in Crystal Report

Hi,

i need to get an example, to create a Table in my Crystal Report only by
having a Dataset. Can someone give me an small example please.

Thx for help

regards

Fabian
Nov 17 '05 #1
2 10648
Hi,
Just create the dataset as usual, then create a new instance of your report
( CR create a class with the same name of the report ) and then use
SetDataSource( dataset ) to assign your dataset to it.
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Fabian" <Fa****@discuss ions.microsoft. com> wrote in message
news:80******** *************** ***********@mic rosoft.com...
Hi,

i need to get an example, to create a Table in my Crystal Report only by
having a Dataset. Can someone give me an small example please.

Thx for help

regards

Fabian

Nov 17 '05 #2
Hi,

Ok, this i did before, but how do I now create the table into my loaded CR ?

My current Source :

DataSet ds = new DataSet("Sells" );
ReportDocument rd = new ReportDocument( );
rd.Load("F:\\cr Rechnung.rpt"); //my CR
rd.SetDataSourc e(ds);
I now need a way to say something like this :
rd.Section1.add table(name "table1", coloums 3, rows 4);
rd.Section1.tab le1.rows[0].coloums[0].text = "Cell 0,0";
Please help me... thx

Fabian

"Ignacio Machin ( .NET/ C# MVP )" wrote:
Hi,
Just create the dataset as usual, then create a new instance of your report
( CR create a class with the same name of the report ) and then use
SetDataSource( dataset ) to assign your dataset to it.
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Fabian" <Fa****@discuss ions.microsoft. com> wrote in message
news:80******** *************** ***********@mic rosoft.com...
Hi,

i need to get an example, to create a Table in my Crystal Report only by
having a Dataset. Can someone give me an small example please.

Thx for help

regards

Fabian


Nov 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
10072
by: cj | last post by:
Has anyone come across the following error in running a Crystal Report in ASP.NET using the Crystal Reports Web Viewer control... CrystalDecisions.CrystalReports.Engine.InvalidArgumentException: Error in File c:\..\..\..\..\InvoiceReport.rpt: Invalid table number. It happens when trying to set the location for each table in the report 1 For Each objReportTable In rptInvoice.Database.Tables 2 Dim objTableLogOnInfo As...
1
7777
by: CrystalDBA | last post by:
I usually design applications in SQL Server and Crystal Reports. I now need to create a crystal report on an MS Access database. I have two tables: Services: Date datetime Entry text Amount number (should be 4 records)
1
6331
by: Shelby | last post by:
Problem: My company generates its own data export from a propietary database. These (free) tables can be read in C#.NET using a Visual FoxPro driver (vfpoledb). I can read each of the six tables into its own datatable, modify them, and add them to a dataset. It take approximately 15 minutes to pass that dataset to Crystal Reports (45 minutes if the report uses three subreport datasets). Then it takes over 7 hours for Crystal to...
3
2505
by: Amar | last post by:
I have a abc.PRG file in visual foxpro 8.0. I can run this file using visual foxpro environment and it creates a table X.dbf in the same folder where this program file is and populates some data in the table. I am now using VB.NET to run this abc.PRG file through VB.net environment. (Equivalent method to perform same as "DO abc.prg" command in foxpro). My code for this is as below. This code runs on click of a button in Vb.net.: Dim Fox...
4
2930
by: Ryan | last post by:
I'm trying to create a report (similar to access) in VB 2005. It appears that Crystal Reports is the recommended method. I created a Crystal Report, set up the data connection (using the Wizard -selected from an existing project datasource which, by the way, works fine on my Datagrids). The report preview, however, outputs absolute junk. The FirstName field populates with colors (Green, Silver, Fuchsia, etc), the LastName field...
1
11044
by: Rodo | last post by:
Hi all, I'm trying to generate a simple crystal report without a database. Several people mention the use of a dataset. Someone mention in a msdn forum that I could use the SetParameterValue to easily fill the fields in a simple report. So. I looked at datasets and I think I'll try this way first. I'm pretty new and I still don't understand much of this stuff. So. here is what I did . and it is not working :-(. 1.-create new windows...
5
2533
by: KewlToyZ | last post by:
Good day, I am stuck in a strange situation. SQL 2000 Server, creating a stored procedure to use in Crystal Reports 11. I am trying to build a report without creating a table or temprorary table in the database. Not too bad but ugly nonetheless. I succedded in creating the process using multiple stored procedures, but the report takes hours to run in Crystal which more less indicates I failed to get a workable solution. I have a few...
4
3678
by: sklett | last post by:
I've developed an ERP application that we use internally and works quite well. I receiving more and more requests from users to print various transactions, order forms, search results, etc. I haven't decided what the best way to do this is because I don't have much experience with generating printable forms. Early on I knew one of my modules would need to print a clear report so I used the open source SharpPDF library to generate the...
3
1771
by: Paulo | last post by:
Hi, how can I create web reports? I need to create grouping, subtotals, totals, etc... Must I use gridview? Generating <tableand <tris the best solution? Using asp.net C# 2.0 Thanks
0
9586
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10210
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9990
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9861
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8869
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5298
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5446
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3956
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.