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

Printing underlines on subreport data

P: n/a
Using A2K. I've got a subreport that can have up to 3 lines of data.
The user wants all lines underlined even if there's no data. Any idea
how to do this? Below is an example of the desired results:

Fund #: 1234-56 Name: An Account Amount: $50.00
------- ---------- ------
Fund #: 8989-89 Name: Account 89 Amount: $76
------- ---------- ------
Fund #: Name: Amount:
------- ---------- ------
This data is entered into a subform and kept in a separate table from
the main report's data. The original thinking was that there could be
more than 3 funds. The only way I can think of is to remove the
subform and allow them to enter only 3 funds, putting the 3 funds in
the same table as the rest of the form. Thanks for any help or
advice.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ma**********@hotmail.com (Ellen Manning) wrote in message news:<da*************************@posting.google.c om>...
Using A2K. I've got a subreport that can have up to 3 lines of data.
The user wants all lines underlined even if there's no data. Any idea
how to do this? Below is an example of the desired results:

Fund #: 1234-56 Name: An Account Amount: $50.00
------- ---------- ------
Fund #: 8989-89 Name: Account 89 Amount: $76
------- ---------- ------
Fund #: Name: Amount:
------- ---------- ------
This data is entered into a subform and kept in a separate table from
the main report's data. The original thinking was that there could be
more than 3 funds. The only way I can think of is to remove the
subform and allow them to enter only 3 funds, putting the 3 funds in
the same table as the rest of the form. Thanks for any help or
advice.


base that part of the report on an outer join?
Nov 13 '05 #2

P: n/a
Thanks for your reply, Pieter. I ended up just placing lines on the
report and the placing the subreport over the lines. It took me maybe
15 minutes to get the alignment just right.

I thought about doing away with the subform that allows them to enter
unlimited fund #'s and allow them to only enter 3 funds. But then I'd
have to change all the reports and it just seemed easier to do it the
other way. And, if for any reason, they decide they need more than 3
fund numbers, all I have to do is delete the lines (or add more) and
they're all set.

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
ma**********@hotmail.com (Ellen Manning) wrote in message news:<da*************************@posting.google.c om>...
Using A2K. I've got a subreport that can have up to 3 lines of data.
The user wants all lines underlined even if there's no data. Any idea
how to do this? Below is an example of the desired results:

Fund #: 1234-56 Name: An Account Amount: $50.00
------- ---------- ------
Fund #: 8989-89 Name: Account 89 Amount: $76
------- ---------- ------
Fund #: Name: Amount:
------- ---------- ------
This data is entered into a subform and kept in a separate table from
the main report's data. The original thinking was that there could be
more than 3 funds. The only way I can think of is to remove the
subform and allow them to enter only 3 funds, putting the 3 funds in
the same table as the rest of the form. Thanks for any help or
advice.


base that part of the report on an outer join?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.