473,320 Members | 1,838 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.

crystalreport with sql select

Hi,
In asp.net I am trying to generate a crystal report by the method showing
below.But no data is showing in the report..for this what settings i have to
do in crystal report.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection(connectionString)
Dim comd As New SqlCommand()
comd.Connection = con
comd.CommandText = "select suppid,invno,amt from spfile where
suppid ='"&textbox1.text&"'
con.Open()
Dim adp As New SqlDataAdapter(comd)
Dim dts As New DataSet()
adp.Fill(dts)
con.Close()
Dim cr3 As New CrystalReport1()
cr3.SetDataSource(dts)
CrystalReportViewer1.ReportSource = cr3
CrystalReportViewer1.DataBind()
CrystalReportViewer1.Visible = True
End sub
--
Thanks
Aug 24 '06 #1
1 941
=?Utf-8?B?c2hpZg==?= <ns*****@hotmail.comwrote in
news:F1**********************************@microsof t.com:
In asp.net I am trying to generate a crystal report by the method
showing below.But no data is showing in the report..for this what
settings i have to do in crystal report.
did you design the template?
Aug 24 '06 #2

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

Similar topics

0
by: s-galit | last post by:
i read on the msdn site that the crystalReport is dynamic does someone know if its possible to hide a column on the crystalReport dynamicly?? how? where i can get examples? thanks
0
by: s-galit | last post by:
hi, i have a formula parameter in my crystalReport how can i initalize the parameter so that in every line in the crystalReport the parameter will have a different string? how to get to line in...
0
by: s-galit | last post by:
hi, is it possible to give a different value to a formula field in the crystalReport (i mean a different value in every row in the crystalReport) ? if yes then how can i get to a row? thanks in...
3
by: redneon | last post by:
I've populated a DataSet in my C# program and verified that it contains the data I passed it. I've then created a blank CrystalReport and set it's DataSource to my DataSet. Then I created a...
1
by: Jason Huang | last post by:
Hi, Would someone tell me how to open a CrystalReport in my ASP.Net C#? We can use the Show method to open a windows form, but what method should we use for opening a CrystalReport? Thanks for...
2
by: Don Wash | last post by:
Hi All! I've been searching everywhere for a simple sample of producing a bar graph using CrystalReport by specifying SQL Query, and I've found none of it! I find so many complex samples with so...
0
by: agcabutotan | last post by:
Hi to everyone. I am new in this thread, please help me. I'm having difficulty with CrystalReport.Net. I have a completed project written and compiled in VB.Net (and I used CrystalReport.Net in...
1
by: mhsasono | last post by:
Hi all, Has anybody experienced with CrystalReport? My question is: Does CrystalReport have capability to print the Microsoft Word document? Reason: I want to know CrystalReport capability...
0
by: amri | last post by:
How to define CrystalReport object in ASP.NET ? I take a CrystalReportViewer & CrystalReportSource........& their name is in CrystalReport is respectively CrystalReportViewer1 & ...
0
by: amri | last post by:
How to define CrystalReport object in ASP.NET ? I take a CrystalReportViewer & CrystalReportSource........& their name is in CrystalReport is respectively CrystalReportViewer1 & ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.