473,403 Members | 2,354 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,403 software developers and data experts.

Crystal Report from multiple tables

RAF
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

Nov 22 '05 #1
2 8937
Crystal Reports does not read tables into the record
source. The only way to set the source is by using
multiple datasets.

rpt.SetDataSource(ds1.Tables(0))
rpt.SetDataSource(ds2.Tables(0))

Crazy I know, but that's what you have to do.

Shawn
-----Original Message-----
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

.

Nov 22 '05 #2
RAF
hi

It is still not working it generates following error
"
Logon failed.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details:
CrystalDecisions.CrystalReports.Engine.LogOnExcept ion:
Logon failed.
"
regards RAF
-----Original Message-----
Crystal Reports does not read tables into the record
source. The only way to set the source is by using
multiple datasets.

rpt.SetDataSource(ds1.Tables(0))
rpt.SetDataSource(ds2.Tables(0))

Crazy I know, but that's what you have to do.

Shawn
-----Original Message-----
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

.

.

Nov 22 '05 #3

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

Similar topics

0
by: Sameer | last post by:
Hello I have a simple crystal report. Report is displayed using CrystalReportViewer control in a web form. It works fine. There is one problem with the database connection logic. Whenever I...
4
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO...
7
by: Phin | last post by:
I need your HELP! I've seen all the posts on using Crystal Reports within vs.net (vb.net) and changing a SQL query at runtime. When I tried to pass in a dataset into the crystal report at...
1
by: Maria | last post by:
Hello! I am new to Crystal reports an I have problems passing parameters form outside to Crystal report an creating a report with data from more than one table This is the problem: I have to...
3
by: Richard Hallgren | last post by:
Hi, I have a project that uses Crystal Reports (VS .Net included) and the System.Data namespace. I've managed to deploy the project and to get Crystal Report working on my clients XP based...
2
by: Alpha | last post by:
I have a C# program that user would select several search criteria and then outputs to the Crystal Report. A message is output to user if no matching record is found. In my code I also clear,...
0
by: BATISTA | last post by:
Hi , I am working in c# with crystal report XI. I read an example about dynamic image location .. 1) In that we have a xml xchema file with two fields n amed country--datatype is string,...
1
by: RJN | last post by:
Hi I'm new to VS.Net Crystal Report. I'm using data sets as the source for crystal report. I've a dataset which has 2 data tables. The first table's schema is like this Ptid String Prid...
3
by: FeveZ | last post by:
I've been stuck on a problem now for ages and i'm about ready to pack my project in because of it lol. OK here is my scenario. I have an existing Crystal Report, which I have added to my...
0
by: bonita | last post by:
In my ASP.NET page, I have 2 checkboxes for users to choose which crystal report they want to display. These two reports use different tables. If report1 has been choosen and displayed in the...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
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...
0
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,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.