If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excluding Report Sections
Hello,
Working on a contract generating program. I have a table of contents listing many articles (1-20) and attachments (A-M). On some contracts all articles apply, on others i need to select which will apply. I use Text boxes in the report so I can have the article text and include another field, such as effective _date, for example. The problem i want to solve is: 1. How do i allow the user to select in the report which sections to exclude. 2. If a section is excluded, I need to replace its title in the table of contents to RESERVED 3. Then the article section within the contract replace the standard wording with the word RESERVED. |
#2
|
|||
|
|||
Excluding Report Sections
This is just a general idea and is fairly short on specifics, but maybe it
will give you some conceptual ideas that you can execute: If you have anything like a "Table of Contents" table that lists your Section/Attachment options, you could add a T/F field called "Print?" to that (and if you don't have such a table, maybe you should?). Then, you'll need some sort of interface that would: - Set Print? to True for all sections, etc. upon opening (I assume this would be the default) - Allow the user to de-select items as they wish, which would set Print? to False. - (Open the report?) In the query that your report is based on, add the Print? field. You'd then need to add code to your report that would react appropriately to the value of Print? for each section/attachment, etc. Hard to say exactly where this code would go without more specifics, but it'll probably be the Format event of Header section(s) and/or the Detail section. Ex: If Me.[Print?] = False Then Me.txtTitleTextBox = "RESERVED" Else Me.txtTitleTextBox = rs!Title End If Alternatively (and much easier if it works for your report setup), you may be able to do most of what you need in the report query, without adding code to the report. For instance, If you have a field in your query called Title that you want to change if Print? = False: Title: IIf([Print?], SourceTable.Title,"RESERVED") That way the proper value would, for each record, automatically go into any text box on your report that already uses Title as the ControlSource. HTH, -- George Nicholson Remove 'Junk' from return address. "Zachry1" wrote in message ... Hello, Working on a contract generating program. I have a table of contents listing many articles (1-20) and attachments (A-M). On some contracts all articles apply, on others i need to select which will apply. I use Text boxes in the report so I can have the article text and include another field, such as effective _date, for example. The problem i want to solve is: 1. How do i allow the user to select in the report which sections to exclude. 2. If a section is excluded, I need to replace its title in the table of contents to RESERVED 3. Then the article section within the contract replace the standard wording with the word RESERVED. |
#3
|
|||
|
|||
Excluding Report Sections
Thanks George, you've given me some good ideas. Let's see of i can make it
work... "George Nicholson" wrote: This is just a general idea and is fairly short on specifics, but maybe it will give you some conceptual ideas that you can execute: If you have anything like a "Table of Contents" table that lists your Section/Attachment options, you could add a T/F field called "Print?" to that (and if you don't have such a table, maybe you should?). Then, you'll need some sort of interface that would: - Set Print? to True for all sections, etc. upon opening (I assume this would be the default) - Allow the user to de-select items as they wish, which would set Print? to False. - (Open the report?) In the query that your report is based on, add the Print? field. You'd then need to add code to your report that would react appropriately to the value of Print? for each section/attachment, etc. Hard to say exactly where this code would go without more specifics, but it'll probably be the Format event of Header section(s) and/or the Detail section. Ex: If Me.[Print?] = False Then Me.txtTitleTextBox = "RESERVED" Else Me.txtTitleTextBox = rs!Title End If Alternatively (and much easier if it works for your report setup), you may be able to do most of what you need in the report query, without adding code to the report. For instance, If you have a field in your query called Title that you want to change if Print? = False: Title: IIf([Print?], SourceTable.Title,"RESERVED") That way the proper value would, for each record, automatically go into any text box on your report that already uses Title as the ControlSource. HTH, -- George Nicholson Remove 'Junk' from return address. "Zachry1" wrote in message ... Hello, Working on a contract generating program. I have a table of contents listing many articles (1-20) and attachments (A-M). On some contracts all articles apply, on others i need to select which will apply. I use Text boxes in the report so I can have the article text and include another field, such as effective _date, for example. The problem i want to solve is: 1. How do i allow the user to select in the report which sections to exclude. 2. If a section is excluded, I need to replace its title in the table of contents to RESERVED 3. Then the article section within the contract replace the standard wording with the word RESERVED. |
#4
|
|||
|
|||
Excluding Report Sections
George, one more question.
i am using a memo field and i would like to inset several variables within the text inside the memo field so it reads correctly, for ex: "This work will execute" [start_date] "and is to be completed not later than" [120 days] "or i will sue you for" [200,000] "dollars" So i want to insert the content of several variables within a memo field. "George Nicholson" wrote: This is just a general idea and is fairly short on specifics, but maybe it will give you some conceptual ideas that you can execute: If you have anything like a "Table of Contents" table that lists your Section/Attachment options, you could add a T/F field called "Print?" to that (and if you don't have such a table, maybe you should?). Then, you'll need some sort of interface that would: - Set Print? to True for all sections, etc. upon opening (I assume this would be the default) - Allow the user to de-select items as they wish, which would set Print? to False. - (Open the report?) In the query that your report is based on, add the Print? field. You'd then need to add code to your report that would react appropriately to the value of Print? for each section/attachment, etc. Hard to say exactly where this code would go without more specifics, but it'll probably be the Format event of Header section(s) and/or the Detail section. Ex: If Me.[Print?] = False Then Me.txtTitleTextBox = "RESERVED" Else Me.txtTitleTextBox = rs!Title End If Alternatively (and much easier if it works for your report setup), you may be able to do most of what you need in the report query, without adding code to the report. For instance, If you have a field in your query called Title that you want to change if Print? = False: Title: IIf([Print?], SourceTable.Title,"RESERVED") That way the proper value would, for each record, automatically go into any text box on your report that already uses Title as the ControlSource. HTH, -- George Nicholson Remove 'Junk' from return address. "Zachry1" wrote in message ... Hello, Working on a contract generating program. I have a table of contents listing many articles (1-20) and attachments (A-M). On some contracts all articles apply, on others i need to select which will apply. I use Text boxes in the report so I can have the article text and include another field, such as effective _date, for example. The problem i want to solve is: 1. How do i allow the user to select in the report which sections to exclude. 2. If a section is excluded, I need to replace its title in the table of contents to RESERVED 3. Then the article section within the contract replace the standard wording with the word RESERVED. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |