I have two tables:



exchange(exc_code,exc_desc) (Exchange code and exchange description)



exchange_rate(exr_code, exr_valu, exr_date) (Exchange code, excange rate value, exchange rate date)





I want to display on one grid the following information: (exr_code is a foreign key to exc_code)



exr_code,exc_desc,exr_valu,exr_date





What is the best way to achive this? I tried to read the forms and manages to create a new custom field on a BO but still it cannot be displayed in the grid.



Could you please give me a simple example?



Best Regards

Yes, report data should be limited by any parameter. You can do a simple test with a plain .Net project not SF and see if you will get the same out of memory error with a data table and your "SELECT *" statement. Of course the BO & BSS classes should add some overhead on the memory since they do more stuff than the plain data table, but I believe the most rececent SF release address several memory leaks in this regard.





Using a parameter form dialog to capture End User parameter and pass that to the report engine. I have been using the SF BrowseDialog in the same fashion as the StrataFlix project but I have also asked SF team to create a dialog for reporting purpose generic enough like the BrowseDialog.





I agree it could be tricky, but I think that if SF produce a BrowseDialog for reporting purpose this issue may be covered. You can see the discussion here

Edhy Rijo