473,808 Members | 2,797 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Printing underlines on subreport data

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
2 1377
ma**********@ho tmail.com (Ellen Manning) wrote in message news:<da******* *************** ***@posting.goo gle.com>...
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
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********@hotm ail.com (Pieter Linden) wrote in message news:<bf******* *************** ****@posting.go ogle.com>...
ma**********@ho tmail.com (Ellen Manning) wrote in message news:<da******* *************** ***@posting.goo gle.com>...
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1414
by: Josh Nikle | last post by:
I have a subreport that displays the addresses of suppliers. Its source table has fields for the name, street, city/state, and ZIP code for easier querying. However, for display purposes, I put the city/state and ZIP together and put that value in txtCityAndState. When I run the report, the print preview looks perfect. When I print it, though, txtCityAndState is blank. I've tried putting the same code I used to fill this textbox in the...
3
2256
by: Ellen Manning | last post by:
I've got an unbound text box on a subreport that doesn't display all it's data. At most the data may be 50 words long. The text box is 2" wide and only enough text to fill the width once is printed. I verified thru debug that all of the data is getting put into the text box. Am I doing something wrong here? Thanks for any help or advice.
1
1744
by: Melissa | last post by:
Sorry if this becomes a repeat! I am having trouble with my newsreader and don't know if this got posted yeserday or not or if anyone responded. A form in my database has multiple subforms. If any subform has no data, the borders of the subform still display on screen and also are printed if I print the main form. Reports are different. If a subreport has no data, the borders of the subreport do not appear in Print View nor do they print...
10
7553
by: sara | last post by:
I am STUCK! I have an Access2000 report; main report and subreport. The sub report is 2 columns, with a footer controlled by a value in a field. The Report Footer should have SUM of values in the report. My problem is that the Report footer of the Subreport doesn't print! The main report prints fine; the sub-report prints fine, except there
5
2205
by: Tom | last post by:
I have a subreport that can contain one or two pictures per page. The subreport is similar to an appendix to the main report. The recordsource contains a field "IncludeInReport" (Yes/No) for each picture record. What code do I use and where does it go to prevent printing the subreport if there are no picture records marked "Yes" in the "IncludeInReport" field? Thanks, Tom
0
1352
by: Mbishr | last post by:
i add a print button to print the report and the on demand Subreport crystal i try this code in the button crReportDocumentForex.PrintToPrinter(1, False, 1, 99) but it print the main report regardless the viewer view the main or the subreport . and i try crReportDocumentForex.OpenSubreport("Details").PrintToPrinter(1, True, 1, 11) but it print the subreport without any data regardless the viewer view the
2
2914
by: Simon | last post by:
Dear reader, In case a report is a sub report the Report Header of the sub report is printed in the report but the Page Header of the sub report will not be printed. This is the same for Page Footer of the sub report. Is there a possibility to force printing Page Header and Page Footer of a sub report.
3
9418
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
1
1410
by: DThreadgill | last post by:
Hi all! I have one Main Report with 6 subreports. The titles for these subreports are all in the detail section of the Main report above each subreport and the headers of each subreport is in the report header section. My question: When viewing or printing the report, is there a way to get the headers to also print on the next page if the subreport spans two pages? Thanks in advance!
0
9600
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10628
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10373
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10374
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10113
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9195
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6880
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5547
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
3011
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.