By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,644 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,644 IT Pros & Developers. It's quick & easy.

About Sections in DataReports

P: 274
Hi everyone
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

When I use one label on report and try follwoing code
Expand|Select|Wrap|Line Numbers
  1.  far1 = NS.Fields(3)
  2.  NS.MoveNext
  3.  far2 = NS.Fields(3)
  4.  NS.MoveNext
  5.  far3 = NS.Fields(3)
  6.  NS.MoveNext
  7.  far4 = NS.Fields(3)
  8. Sections("Section1").Controls("gst1").Caption = far1
  9. Sections("Section1").Controls("gst1").Caption = far2
  10. Sections("Section1").Controls("gst1").Caption = far3
  11. Sections("Section1").Controls("gst1").Caption = far4
Same value is printed four times
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
Dec 16 '07 #1
Share this Question
Share on Google+
1 Reply

P: 274
I think nobody understand what I want? =_= Worried
Dec 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.