Re: How conditionally skip stuff on a report?

You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.

The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.

Re: How conditionally skip stuff on a report?

Steve	19 Oct 2009 15:02
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

Mark

19 Oct 2009 07:50

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

Steve

18 Oct 2009 20:34

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

Gina Whipp

18 Oct 2009 20:04

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?

Signature

Gina 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

Steve	18 Oct 2009 18:49
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

Gina Whipp

18 Oct 2009 01:46

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?

Signature

Gina 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

Steve

17 Oct 2009 21:26

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

Jeff Boyce

17 Oct 2009 18:47

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

Steve

17 Oct 2009 00:12

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

Jeff Boyce

16 Oct 2009 23:49

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

Steve

16 Oct 2009 23:30

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

Jeff Boyce

16 Oct 2009 22:09

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

Steve

16 Oct 2009 18:35

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

Jeff Boyce

16 Oct 2009 18:11

As asked, the original poster wished to "skip that record", not (merely) the
control/blank...

Regards

Jeff Boyce
Microsoft Access MVP

Signature

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.

> 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

Steve

16 Oct 2009 16:17

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

ray anselmi

16 Oct 2009 13:04

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

Quick links: