first row only

edited May 2012 in FastReport .NET
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

Comments

  • edited 4:59AM
    Hello,

    Your databand is probably not connected to a datasource. Doubleclick the databand and select appropriate datasource.
  • stepsonstepson Rou
    edited 4:59AM
    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?
  • edited 4:59AM
    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");
  • stepsonstepson Rou
    edited 4:59AM
    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()
  • edited 4:59AM
    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.