I have a report that displays a number of fields to display a summary report. One of the fields I want to display on my report isn't part of the main query (For some condition it can be part of that query so I calculate it in a different query)
I have to display fields from both queries on one report.
For main query I have datasource assigned to it so it works fine.
However, for other fields that I want to print on same report is problem for me.
I am sure about follwoing when my query will exeute
1.... First query will display four record always.
2... Second query can have min of 0 and max of four records
3... Both queries are related to one and other
Problem:
When I use one label on report and try follwoing code
Expand|Select|Wrap|Line Numbers
- far1 = NS.Fields(3)
- NS.MoveNext
- far2 = NS.Fields(3)
- NS.MoveNext
- far3 = NS.Fields(3)
- NS.MoveNext
- far4 = NS.Fields(3)
- Sections("Section1").Controls("gst1").Caption = far1
- Sections("Section1").Controls("gst1").Caption = far2
- Sections("Section1").Controls("gst1").Caption = far3
- Sections("Section1").Controls("gst1").Caption = far4
If I use four labels : It repeat four times to each of them.
I have tried a number of techniques but no luck.
Please help me
Thanks in advance