2. You SQL select your rec(s) into a cursor, depending on user wishes, and use this as the source to your report. Make sure, if you do, you remove your report's table fronm its DE and, in the fields' properties, remove the table name from the field name.
>I got few queries relating to the report:
>
>1. How can I insert image in report. I have generated a supplier report, in which near the country field I want to insert country flag. The flag images is saved in d:\vfas\pictures\world\flag. I saved almost all the countries flag in that directory with its country name.
>
>Suppose if the user type in country field 'CANADA', the file is saved in the directory like "canada_flag.jpg". I joined "_flag.jpg" with the field.
>How can I put this in report. Please help.
>
>2. Before displaying this Supplier Report, I just wanted to put a form in which it should ask the user whether he wants to display all records or a particular record. How can I do so. I have generated a form but I want to attached with report, i.e. if I click on report the form should display first. How can I do so. Please suggest.
>
>Thanks/Regards
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.