Filtering

Comments

• AlexTZ

  November 2009 edited 11:11AM

  Hello,
  
  You have to pass the selected combobox value to a report parameter, before you run a report:
  
  report1.SetParameterValue("selectedItem", the_selected_item)
  
  and use this paramater in the databand's filter, something like this:
  
  [MyTable.MyColumn] == [selectedItem]
• visualise01

  November 2009 edited 11:11AM

  Thanks that worked great.
  
  One other question
  
  How can I load a saved report through my on preview window, I have tried:
  
  ReportSelectedPersonal.Preview = frmPreview.PreviewControl1
  ReportSelectedPersonal.Load(Application.StartupPath & "\reports\Avery5321-Selected-Personal.frx")
  ReportSelectedPersonal.Show()
  frmPreview.ShowDialog()
  
  But it appears blank.
  
  If I take out the 1st and 4th line, it works, but it uses the built in preview.
• AlexTZ

  November 2009 edited 11:11AM

  Hello,
  
  I have tried to reproduce it in the demo.exe project. I've changed the code a little:
  

      Private Sub DesignReport()
          Dim form As Form = New Form
          Dim preview As PreviewControl = New PreviewControl
          preview.Parent = form
          preview.Dock = DockStyle.Fill
  
          FReport = New Report
          FReport.Preview = preview
          FReport.Load(tvReports.SelectedNode.Tag.ToString())
          RegisterData()
          FReport.Show()
          form.ShowDialog()
      End Sub
  

  
  Now, when I click the "Design the report" button, the new form with the preview is opened.
• visualise01

  November 2009 edited 11:11AM

  AlexTZ wrote: »

  Hello,
  
  I have tried to reproduce it in the demo.exe project. I've changed the code a little:
  

      Private Sub DesignReport()
          Dim form As Form = New Form
          Dim preview As PreviewControl = New PreviewControl
          preview.Parent = form
          preview.Dock = DockStyle.Fill
  
          FReport = New Report
          FReport.Preview = preview
          FReport.Load(tvReports.SelectedNode.Tag.ToString())
          RegisterData()
          FReport.Show()
          form.ShowDialog()
      End Sub
  

  
  Now, when I click the "Design the report" button, the new form with the preview is opened.

  
  Thanks for that.
  
  I think you have misunderstood, I dont want a user to load or edit or design a report. All I want is my *.frx to appear in my preview window.
• AlexTZ

  November 2009 edited 11:11AM

  No, I have understood you correctly. This code demonstrates how to show a report in a separate window with PreviewControl on it.
• visualise01

  November 2009 edited 11:11AM

  AlexTZ wrote: »

  No, I have understood you correctly. This code demonstrates how to show a report in a separate window with PreviewControl on it.

  
  My apologies, I just thought becuase there was no reference to "Application.StartupPath & "\reports\Avery5321-Selected-Personal.frx" (myreport), then it wouldn't work, but I will try.