.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Passing Dataset to a crystal report..
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-crystal' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Praveen Kumar
-- Moved from [aspngfreeforall] to [ngfx-crystal] by Tim Musschoot <Click here to reveal e-mail address> --

Hello Everyone,
How can i pass a dataset to a crystal report.And also
will it be possible to pass a arraylist to the crystal
report for display.

Thanks in advance.

Praveen B

=====
Praveen Kumar B
Intellect Data Systems
R T Nagar
Bangalore - 560 032

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
Reply to this message...
 
    
Eric Landes (VIP)
Praveen,
See if this helps for the dataset issue:
http://www.aspalliance.com/corporatecoder/Articles2002/CrystalNetWDataset=
as
px if you download the source that should get you started. Also check =
out
the walkthroughs available at support.crystaldecisions.com (Although =
last I
checked I didn't find a dataset walkthrough available).

As for the arraylist, why not populate your dataset with the arraylist?
That is certainly possible.

HTH
*************************=20
Eric Landes=20
Senior Programmer/Analyst member of the ASPFriends.com Moderator team=20
For Articles on Crystal.Net, Datagrids and more check out
http://www.aspalliance.com/corporatecoder/
*************************=20
All statements expressed are my own, and do not reflect the opinion of =
my
employer, unless stated otherwise.=20

-----Original Message-----
From: Praveen Kumar [mailto:Click here to reveal e-mail address]
Sent: Tuesday, July 09, 2002 1:27 AM
To: ngfx-crystal
Subject: [ngfx-crystal] Passing Dataset to a crystal report..

-- Moved from [aspngfreeforall] to [ngfx-crystal] by Tim Musschoot
<Click here to reveal e-mail address> --

Hello Everyone,
How can i pass a dataset to a crystal report.And also
will it be possible to pass a arraylist to the crystal
report for display.=20

Thanks in advance.

Praveen B

=3D=3D=3D=3D=3D
Praveen Kumar B
Intellect Data Systems
R T Nagar
Bangalore - 560 032

__________________________________________________

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com
Reply to this message...
 
    
PennJ@compex.com
here is the code that i used:     

     Dim MyReport As New CrystalReport5()
SqlDataAdapter1.Fill(DataSet41, "Events")
MyReport.SetDataSource(DataSet41)
CrystalReportViewer1.ReportSource = MyReport

Events is the name of the table in the dataset.

-----Original Message-----
From: Praveen Kumar [mailto:Click here to reveal e-mail address]
Sent: Tuesday, July 09, 2002 2:27 AM
To: ngfx-crystal
Subject: [ngfx-crystal] Passing Dataset to a crystal report..

-- Moved from [aspngfreeforall] to [ngfx-crystal] by Tim Musschoot <Click here to reveal e-mail address> --

Hello Everyone,
How can i pass a dataset to a crystal report.And also
will it be possible to pass a arraylist to the crystal
report for display.

Thanks in advance.

Praveen B

=====
Praveen Kumar B
Intellect Data Systems
R T Nagar
Bangalore - 560 032

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT
Reply to this message...
 
    
Sam Gardiner
I used very similar code but I have problems.

I find that when I run this code I get a request to logon to the database when I try to show the report (just after the message box), which is ridiculous as the report is connected to a dataset, not the database.

The dataset is definately populated as I can verify by writing it to a file.

dim myData as DataSet1
.
.

MyAdapter.Fill(MyData, "folios") MyData.WriteXml("c:\foo.xml") oRpt.SetDataSource(MyData) MsgBox("about to show connect report viewer to report")
CrystalReportViewer1.ReportSource = oRpt

the strange thing is, that if I put this:

oRpt.SetDataSource(MyData.Tables("folio"))

then it all works! But I can't make this work when I have more than one table in the dataset.

help!

--------------------------------
From: Sam Gardiner
Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification