 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2009How conditionally skip stuff on a report?
Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx When you say "skip", do you mean "don't show ANY of the fields in a record that has nothing in the [Comments] field? If so, use a query! Exclude rows with "blanks" (now the tough part ... "blank" could mean Null, or zero-length string, or spaces ... they all look blank to me!). Your query needs to exclude any of those possibilities. Regards Jeff Boyce Microsoft Access MVP  SignatureDisclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > Good morning, > I saw the article "How conditionally display stuff on a report?", however [quoted text clipped - 9 lines] > How to detect and Automatically install MSXML > http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve santus@penn.com > Good morning, > I saw the article "How conditionally display stuff on a report?", however [quoted text clipped - 9 lines] > How to detect and Automatically install MSXML > http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx As asked, the original poster wished to "skip that record", not (merely) the control/blank... Regards Jeff Boyce Microsoft Access MVP SignatureDisclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > Hello Ray, > [quoted text clipped - 18 lines] >> How to detect and Automatically install MSXML >> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Read a little closer! He doesn't want to see a blank line when there is no comment. This is the same as is typically done when there are Address1 and Address2 fields in an address and there is no Address2. Steve santus@penn.com > As asked, the original poster wished to "skip that record", not (merely) > the control/blank... [quoted text clipped - 26 lines] >>> How to detect and Automatically install MSXML >>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Steve Here's a direct quote from the OP - "How do I get the report to skip that record. " Yes, the OP also mention the blank..., but asked a direct question about skipping a record. My initial response asked the OP for clarification, whether "skip" meant the entire record or just the field. Regards Jeff > Read a little closer! He doesn't want to see a blank line when there is no > comment. This is the same as is typically done when there are Address1 and [quoted text clipped - 33 lines] >>>> How to detect and Automatically install MSXML >>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx The OP said " When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record." A record would not just include a comment field. The record would include at least one or more fields. Just because the comment field is blank does not mean the report should not display other info in the record. Like many posts to the newsgroups, terms are misused. I interpret the OP's question to mean he does not want to see the blank line left by the comment field when there is no comment. Just like not wanting to see a blank line when there is no Address2. I'm not saying you are wrong! Steve > Steve > [quoted text clipped - 48 lines] >>>>> How to detect and Automatically install MSXML >>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx We're in agreement, then ... We need to know how the OP is defining his terms to offer an suitable approach. Regards Jeff B. > The OP said " When the report prints, it prints a blank line if the > comment is blank (obviously). How do I get the report to skip that [quoted text clipped - 64 lines] >>>>>> How to detect and Automatically install MSXML >>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Yes, we are in agreement on defining terms. The issue is your second post in this thread. I don't appreciate you criticizing my suggested solution. You could have let well enough alone with your first response without criticizing my response. We had different solutions and the OP could have chosen the one he wanted or came back and asked another question. You attacked my post which violates the Rules of Conduct for an MVP. I would appreciate you not doing that again. Regards, Steve > We're in agreement, then ... > [quoted text clipped - 73 lines] >>>>>>> How to detect and Automatically install MSXML >>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx >You attacked my post which violates the Rules of Conduct for an MVP. He commented on your lack of profesionalism. >I would appreciate you not doing that again. > Steve and we would appreciate you following the rules and stop pimping your limited skills. John... Visio MVP I strive to behave in concordance with the Rules of Conduct, so I'd appreciate learning what is it about my "second post in this thread" that you've interpreted as an attack on your proposed solution? Regards Jeff Boyce Microsoft Access MVP > Yes, we are in agreement on defining terms. > [quoted text clipped - 86 lines] >>>>>>>> How to detect and Automatically install MSXML >>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx The fact that you posted it as a response to my post implicitly criticizing my proposed solution. All you did was to cause Visio John to interject a defamatory comment. Now let's drop it - it's done and over! Regards, Steve >I strive to behave in concordance with the Rules of Conduct, so I'd >appreciate learning what is it about my "second post in this thread" that [quoted text clipped - 96 lines] >>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx You are paranoid. I was responding to you and only you. So does "done and over" really mean you are going to stop pimping your services? I doubt it. John... Visio MVP > The fact that you posted it as a response to my post implicitly > criticizing my proposed solution. All you did was to cause Visio John to [quoted text clipped - 106 lines] >>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx It's over when and because you say it is?! How did my response "implicitly criticize" your proposed solution? If you don't provide an explicit description, how do you expect me to be able to change my behavior? I accept responsibility for my posts and behavior. I don't have the power to "cause ... John" to post. Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > The fact that you posted it as a response to my post implicitly > criticizing my proposed solution. All you did was to cause Visio John to [quoted text clipped - 106 lines] >>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Can't you read? I said in my post " Now let's drop it - it's done and over!" You just want to continue to drag this on to invite Visio John to reply again. Maybe you will get Arno R or Leith Wilby to reply too. Then will you be happy? Regards, Steve > It's over when and because you say it is?! > [quoted text clipped - 133 lines] >>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Yes Sir! We all bow to your command... Pitiable... Jeff > Can't you read? I said in my post " Now let's drop it - it's done and > over!" [quoted text clipped - 144 lines] >>>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx ... and one more thing. Even if my response "implicitly criticized" your proposed solution, how do you bridge the obvious gap to considering that an attack? Are you suggesting that anyone who disagrees with you or criticizes something you propose is attacking you? SignatureRegards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > The fact that you posted it as a response to my post implicitly > criticizing my proposed solution. All you did was to cause Visio John to [quoted text clipped - 106 lines] >>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Just like you can't drop it; there was no need to respond to my post as you did other than to get your dig in me! Regards, Steve > ... and one more thing. Even if my response "implicitly criticized" your > proposed solution, how do you bridge the obvious gap to considering that [quoted text clipped - 115 lines] >>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx > Just like you can't drop it; there was no need to respond to my post as you did other > than to get your dig in me! > > Regards, > > Steve Now who's clinically obsessive here... ?? haha hilarious! You really make my day... Regards, Arno R BTW: You did take your pills ?? I am afraid not ... And one more thing, aren't you going to answer my question in my other post? Regards, Steve > ... and one more thing. Even if my response "implicitly criticized" your > proposed solution, how do you bridge the obvious gap to considering that [quoted text clipped - 115 lines] >>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx I can't. You told me to drop it... Jeff > And one more thing, aren't you going to answer my question in my other > post? [quoted text clipped - 122 lines] >>>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx OK, you're as slippery as a lizard. As an MVP you still have the responsibility to not only strive to behave in concordance with the MVP Rules of Conduct but to also admonish other MVPs that breach the MVP Rules of Conduct. The next time Visio John posts his non-professional defamatory and libelous statement against me in one of the MS public newsgroup, let's see if you have the integrity to admonish him. Regards, Steve >I can't. You told me to drop it... > [quoted text clipped - 126 lines] >>>>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Jeff, As an MVP you have the responsibility to not only strive to behave in concordance with the MVP Rules of Conduct but to also admonish other MVPs that breach the MVP Rules of Conduct. Do you condone the conduct of Visio John? Regards, Steve >I strive to behave in concordance with the Rules of Conduct, so I'd >appreciate learning what is it about my "second post in this thread" that [quoted text clipped - 96 lines] >>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Steve, I'd like to know where these MVP Rules of Conduct are, as my awareness is of the Rules of Conduct that govern these newsgroups... which applies to everyone, you know the ones you ignore, not just MVP's. Of course, I probably won't get and answer from you... Can anyone else tell me where these seperate rules are? SignatureGina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm > Jeff, > [quoted text clipped - 107 lines] >>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx You track all my posts. You have seen the URL posted more than once. Regards, Steve > Steve, > [quoted text clipped - 118 lines] >>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx That would be for EVERYONE, not for just MVP's. So I guess that explains why you consistently ignore them, you don't think they apply to you? SignatureGina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm > You track all my posts. You have seen the URL posted more than once. > [quoted text clipped - 124 lines] >>>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Once again you earn the "B" word!!!!!!!!!!!!!!! You track all my posts. You have seen the URL for Rules Of Conduct for MVPs posted more than once. Of course, don't ask Jeff Boyce; he doesn't know what they are or chooses not to follow them. Regards, Steve > That would be for EVERYONE, not for just MVP's. So I guess that explains > why you consistently ignore them, you don't think they apply to you? [quoted text clipped - 127 lines] >>>>>>>>>>>>> How to detect and Automatically install MSXML >>>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx don't suppose any of you guys/gals have time to look at my post "Report Footer, multi-column rpt", would you? Thanks, Mark > Once again you earn the "B" word!!!!!!!!!!!!!!! > [quoted text clipped - 136 lines] > >>>>>>>>>>>>> EggHeadCafe - Software Developer Portal of Choice > >>>>>>>>>>>>> How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx Hi Mark, I just responded!! Steve > don't suppose any of you guys/gals have time to look at my post "Report > Footer, multi-column rpt", would you? [quoted text clipped - 186 lines] >> >>>>>>>>>>>>> > http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx LOL. I still don't have answer to my question. I would like to skip the record completely. Not just set height to zero, etc.... If the value of a field in the record is blank, skip printing the record. Thnaks. Hi Mark,I just responded!!Steve 19-Oct-09 Hi Mark, I just responded!! Steve Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Web Services - SOAP / Multiple Recordsets http://www.eggheadcafe.com/tutorials/aspnet/a3eefdc8-55c7-4101-be16-e93ab938dc36 /web-services---soap--mu.aspx Did you try my suggestion? Use a query to feed the report. In the query, exclude those records. Regards Jeff Boyce Microsoft Access MVP SignatureDisclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > LOL. I still don't have answer to my question. I would like to skip the > record completely. Not just set height to zero, etc.... If the value of [quoted text clipped - 14 lines] > Web Services - SOAP / Multiple Recordsets > http://www.eggheadcafe.com/tutorials/aspnet/a3eefdc8-55c7-4101-be16-e93ab938dc36 /web-services---soap--mu.aspx Ray Do you have a solution to your question? SignatureRegards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. > Good morning, > I saw the article "How conditionally display stuff on a report?", however [quoted text clipped - 9 lines] > How to detect and Automatically install MSXML > http://www.eggheadcafe.com/tutorials/aspnet/9db92980-4f3a-4243-b411-04094072c374 /how-to-detect-and-automat.aspx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.