473,320 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Crystal Reports and DataSets

Hello all:

I am not sure if this is the right place to post this but I could not
find a specific Crystal Reports forum in the Microsoft forums nor the
Business Objects website.

Anyways, I am trying to find the best way to get data from several
tables into a single report. We have a series of records in one table
that relate to various jobs that we are bidding. We have another table
that has records of the many contractors that we deal with. These two
tables are setup in a many-to-many relationship so that we have an
interim table that links the two called bidstocontractors that contains
an id for each record made up of a bidid and a contractor id.

So on some reports we need to pull data relating to a job, but also the
records of the other table as well when needed. I have a DataSet that
contains all the tables but I'm not sure how to get the data for both
tables to display (for instance when I have a parameter setup to select
a subset of data). I am not even sure it is even possible.

Thanks for any direction you can give me.

- John -
Jul 21 '05 #1
3 1648
You can set the report's datasource to a dataset, which is in the "More
Data Sources" section. To set the report to use a dataset, you either
select an XML file describing the dataset or a class representing the
data. You can use the IDE to create a typed dataset, providing you
both options: XML and a class. If you do not want to use a typed
dataset in your code, then just create one for the sole purpose of auto
generating the XSD file. Use the SetDataSource method of the Crystal
report object so set the source during runtime.

Jul 21 '05 #2
Boyd Ferris wrote:
You can set the report's datasource to a dataset, which is in the "More
Data Sources" section. To set the report to use a dataset, you either
select an XML file describing the dataset or a class representing the
data. You can use the IDE to create a typed dataset, providing you
both options: XML and a class. If you do not want to use a typed
dataset in your code, then just create one for the sole purpose of auto
generating the XSD file. Use the SetDataSource method of the Crystal
report object so set the source during runtime.

I have done this and already have it working to the point of getting the
data from one of the tables that are in the DataSet, but I need data
from two tables. Does Crystal support table joins. I can see that it
allows you to view the SQL query that it gets the data from but can you
edit this?
Jul 21 '05 #3
Crystal supports table joins and filters. Use Visual Linking Expert to
create joins on your tables and use "Edit Selection Formula" context
menu to apply a filter to the information. (You can edit the selection
criteria by right clicking an empty spot on the report and selecting
the Report menu option.)
Good luck,

Boyd

Jul 21 '05 #4

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

Similar topics

5
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
3
by: oscar | last post by:
is there a way of integrating mysql databases into the .net crystal reports? in the report wizard i have options for sql databases, but nothing for mysql. is there a plugin i'm missing for it? ...
3
by: lee_mcknight | last post by:
I am using Crystal Enterprise V9. I have a report that needs to have multiple datasets as the datasource(s) on a single subreport (some common lookup data I need to join to is stored in a seperate...
7
by: TJoker .NET | last post by:
I'm developing an VB.NET Windows Forms application that uses CR for VS.NET (original version shipped with VS.NET 2002 - my VS.NET has the latest SP installed, no SPs for CR). My reports get their...
7
by: sdibello | last post by:
Hi All, I have a windows application. I've built a report section that fills typed datasets and builds crystal reports off those datasets. They work fine on my local dev machine, however on other...
9
by: Doug | last post by:
Simple question, hoping for a quick answer: Using Visual Studio .NET 2003 and Crystal Reports 10, is it possible to connect to a SQL Server 2000 database using Windows Authentication/Integrated...
9
by: Altman | last post by:
I am currently using ASP.Net 2003 and will be upgrading to 2005 sometime in the near future. I have been having issues with using Crystal Reports that were included with .Net to handle my...
0
by: studboyshabbir | last post by:
Dear All, I am not sure, I am asking this question under right thread but pls help. I am facing following Problem. I'm developing an VB.NET Windows Forms application that uses CR for VS.NET...
1
by: =?Utf-8?B?QW5kcmVhcw==?= | last post by:
Our company have one asp.net 2.0 web application using c# as code behind and one C++ windows application. Both applications are using Crystal Reports (v 10) as report engine. The web app. just...
7
by: Jlo | last post by:
Hi, I have a c# winforms application. When I call the report file, it shows me all the records in the table. How can I make it to call only a particular range. i have the following code...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.