Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.
Solved
Is it possible to send dataset,datatable directly to crystal report
Posted on 2004-08-17
It will apprecaite if someone can tell how i can pass, dataset or dataview or a datatable to crystal report directly. I m having one calculated table on my form. i want to print that table data through crystal report. So how is it possible to send that table to crystal report directly instead of saving on server and then crystal report fetch data from server.
thanks in advance
thanks in advance
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
6 Comments
Active today
see "reporting from datasets" at http://msdn.microsoft.com/msdnmag/issues/02/05/Crystal/default.aspx
'this is the right way for showing data in crystal report and dataset or datagrid cant sent to
'report directly
cn.ConnectionString = "Server=eteam08;Database=d
cn.Open()
cmd1.Connection = cn
cmd1.CommandType = CommandType.Text
cmd1.CommandText = "select * from tblCustomer"
oda1.SelectCommand = cmd1
oda1.Fill(ods, "Customer")
Dim rpt As New CrystalReport1
rpt.SetDataSource(ods.Tabl
CrystalReportViewer1.Repor
'report directly
cn.ConnectionString = "Server=eteam08;Database=d
cn.Open()
cmd1.Connection = cn
cmd1.CommandType = CommandType.Text
cmd1.CommandText = "select * from tblCustomer"
oda1.SelectCommand = cmd1
oda1.Fill(ods, "Customer")
Dim rpt As New CrystalReport1
rpt.SetDataSource(ods.Tabl
CrystalReportViewer1.Repor
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray.
The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should. An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 11 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.