Why is FlexReport calling recordsource Twice?

Why is FlexReport calling recordsource Twice?

Posted by: paul on 17 September 2018, 9:14 am EST

• 

  paul

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 September 2018, 9:14 am EST

  Hi,

  I have a FlexReport definition which includes a view name in the recordsource (see attached). When previewing the report I can see that the recordsource, dbo.cdvEnquiry, is being called twice. I am trying to limit calls to a cloud based DB for performance reasons, is there any way I can modify the report to only call the DB once?

  test.zip

  Thanks
  
  Paul

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 18 September 2018, 5:55 am EST

  Hello Paul,

  I could not observe any issue with your report (without the data). Can you please add dummy data to a file and share it back so that I can observe the issue at my end as well and assist you correctly?
  
  Further, I used the attached report getting data from a view from C1Nwind.mdb, shipped with the product. No issue was observed with this report as well.

  Best Regards,
  
  EshaDemoReport.zip

• 

  paul

  • Post Options:
  • Link
    Copy

  Posted 20 September 2018, 5:57 am EST

  Hi Esha,

  We have got around this issue by changing the RecordSource to "select * form dbo.cdvEnquiry " and changing the RecordSourceType from Auto to Text. The record source is now only being called once.

  Regards
  
  Paul

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 20 September 2018, 11:11 pm EST

  Thanks for sharing your solution, Paul.
  
  It’ll help other users who run into this issue.

  Best Regards,
  
  Esha