first row only
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
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
Comments
Your databand is probably not connected to a datasource. Doubleclick the databand and select appropriate datasource.
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?
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");
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()
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