first row only

talaattito

please i have problem
im used Fastreport.NET 1.0.203
when i show report only first row show
this is my code

---

con()
sql = "select * from qryBoxInOut where sanadtype=true order by dateofinsert"
rec.Open(sql, cn, ADODB.CursorTypeEnum.adOpenStatic)
Dim path As String = ""
Dim rep As New Report
rep.Load("..\..\Reports\RptSanadInBox.frx")
path = Application.StartupPath & "\Data\CarSysDb.accdb"
rep.Dictionary.Connections(0).ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path
Dim table As TableDataSource = rep.GetDataSource("qryBoxInOut")
table.SelectCommand = sql
rep.Show()

---

please i whant help

AlexTZ

Hello,

Your databand is probably not connected to a datasource. Doubleclick the databand and select appropriate datasource.

stepson

why only one row,
to me is do the some thing

my code:
rptNir.Load("D:\My Documents\Visual Studio 2008\Projects\GeststocVBNET\rptNir.frx")
rptNir.Dictionary.Clear()
rptNir.Dictionary.Connections.Add(strConn)
rptNir.Dictionary.Report.RegisterData(ds)
rptNir.Show()


and it's showing only one row (dataset ul have more rows )

any idee?

AlexTZ

Hello,

You have the same problem: the databand is not connected to a datasource. You may use the following code to connect it:

(rptNir.FindObject("Data1") as DataBand).DataSource = rptNir.GetDataSource("name_of_datasource");

stepson

thnx
that was


rptNir.Load("D:\My Documents\Visual Studio 2008\Projects\GeststocVBNET\rptNir.frx")
rptNir.Dictionary.Clear()
rptNir.Dictionary.Report.RegisterData(ds, "RaportNir")


dbDataBand1 = rptNir.FindObject("Data1")
dbDataBand1.DataSource = rptNir.GetDataSource("RaportNir")

rptNir.Show()

Master japoj

The stepson's answer works.

The correct way is
<!--fonto:Courier New--><span style="font-family:Courier New"><!--/fonto-->rptNir.Dictionary.Report.RegisterData(ds, "RaportNir")
<!--fontc--></span><!--/fontc-->

Instead
<!--fonto:Courier New--><span style="font-family:Courier New"><!--/fonto-->rptNir.RegisterData(ds, "RaportNir")
<!--fontc--></span><!--/fontc-->


Regards