Birthday List

Posted by Steve on June 26, 2006, 6:22 pm

Please log in for more thread options

I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional
information) I collect customers' dogs' names and birthdays (up to 4 dogs per
customer). Each month I would like to mail customers birthday cards/promos
based on their pet's birthday.

My problem is that my report criteria is quite lengthy. I have to set each
"Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to
06/30/1997" etc. Then I have to do the same multiple entries for 3 more
"Birthday" fields.

Is there a way to just use a Filter of only the Month Range without a
specific year? That way I could simply generate a list of all dogs in month
of June without regard of 1998,1999..etc. Any help would be great. Thanks

Posted by Glenn Adams [MVP - Retail Mgmt on June 27, 2006, 10:41 am

Please log in for more thread options

What report are you starting from?

You can customize the report to include a filterable column that is
based on the Month DATEPART (DATEPART is a SQL function).

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

Steve wrote:

> I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional

> information) I collect customers' dogs' names and birthdays (up to 4 dogs per

> customer). Each month I would like to mail customers birthday cards/promos

> based on their pet's birthday.

> My problem is that my report criteria is quite lengthy. I have to set each

> "Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to

> 06/30/1997" etc. Then I have to do the same multiple entries for 3 more

> "Birthday" fields.

> Is there a way to just use a Filter of only the Month Range without a

> specific year? That way I could simply generate a list of all dogs in month

> of June without regard of 1998,1999..etc. Any help would be great. Thanks

Posted by Steve on June 27, 2006, 11:21 am

Please log in for more thread options

Thanks Glenn for your response. I am using the standard labels list in
Crystal reports. How exactly would you customize that report.

Also, do you have any suggestions regarding a primer for SQL (books website,
etc.)

Thanks again.

"Glenn Adams [MVP - Retail Mgmt]" wrote:

> What report are you starting from?

> You can customize the report to include a filterable column that is

> based on the Month DATEPART (DATEPART is a SQL function).

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information.

> Steve wrote:

> > I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional

> > information) I collect customers' dogs' names and birthdays (up to 4 dogs per

> > customer). Each month I would like to mail customers birthday cards/promos

> > based on their pet's birthday.

> >

> > My problem is that my report criteria is quite lengthy. I have to set each

> > "Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to

> > 06/30/1997" etc. Then I have to do the same multiple entries for 3 more

> > "Birthday" fields.

> >

> > Is there a way to just use a Filter of only the Month Range without a

> > specific year? That way I could simply generate a list of all dogs in month

> > of June without regard of 1998,1999..etc. Any help would be great. Thanks

Posted by Glenn Adams [MVP - Retail Mgmt on June 27, 2006, 12:21 pm

Please log in for more thread options

Sorry, I don't do Crystal. You can edit the reports, but I believe that
you need a copy of the Crystal software (Version 8) to do it.

SQL Server Books Online at msdn.microsoft.com is a great resource for
SQL Server...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

Steve wrote:

> Thanks Glenn for your response. I am using the standard labels list in

> Crystal reports. How exactly would you customize that report.

> Also, do you have any suggestions regarding a primer for SQL (books website,

> etc.)

> Thanks again.

> "Glenn Adams [MVP - Retail Mgmt]" wrote:

>> What report are you starting from?

>> You can customize the report to include a filterable column that is

>> based on the Month DATEPART (DATEPART is a SQL function).

>> Glenn Adams

>> Tiber Creek Consulting

>> http://www.tibercreek.com

>> glenn@tibercreek.com

>> ----------------------------------------------

>> Please DO NOT respond to me directly but post all responses here in the

>> newsgroup so that all can share the information.

>> Steve wrote:

>>> I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in additional

>>> information) I collect customers' dogs' names and birthdays (up to 4 dogs per

>>> customer). Each month I would like to mail customers birthday cards/promos

>>> based on their pet's birthday.

>>>

>>> My problem is that my report criteria is quite lengthy. I have to set each

>>> "Birthday" field with a range "06/01/1996 to 06/30/1996" "06/01/1997 to

>>> 06/30/1997" etc. Then I have to do the same multiple entries for 3 more

>>> "Birthday" fields.

>>>

>>> Is there a way to just use a Filter of only the Month Range without a

>>> specific year? That way I could simply generate a list of all dogs in month

>>> of June without regard of 1998,1999..etc. Any help would be great. Thanks

Posted by j on June 27, 2006, 8:30 pm

Please log in for more thread options

We can do this custom report for you. Please contact us if you are
interested.

Jamieson Gill
www.savitas.net

> Sorry, I don't do Crystal. You can edit the reports, but I believe that

> you need a copy of the Crystal software (Version 8) to do it.

> SQL Server Books Online at msdn.microsoft.com is a great resource for SQL

> Server...

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information.

> Steve wrote:

>> Thanks Glenn for your response. I am using the standard labels list in

>> Crystal reports. How exactly would you customize that report.

>> Also, do you have any suggestions regarding a primer for SQL (books

>> website, etc.) Thanks again.

>> "Glenn Adams [MVP - Retail Mgmt]" wrote:

>>> What report are you starting from?

>>>

>>> You can customize the report to include a filterable column that is

>>> based on the Month DATEPART (DATEPART is a SQL function).

>>>

>>> Glenn Adams

>>> Tiber Creek Consulting

>>> http://www.tibercreek.com

>>> glenn@tibercreek.com

>>> ----------------------------------------------

>>> Please DO NOT respond to me directly but post all responses here in the

>>> newsgroup so that all can share the information.

>>>

>>> Steve wrote:

>>>> I am running HQ w/ 2 SO's 1.3. I own a pet related biz, and (in

>>>> additional information) I collect customers' dogs' names and birthdays

>>>> (up to 4 dogs per customer). Each month I would like to mail customers

>>>> birthday cards/promos based on their pet's birthday.

>>>> My problem is that my report criteria is quite lengthy. I have to set

>>>> each "Birthday" field with a range "06/01/1996 to 06/30/1996"

>>>> "06/01/1997 to 06/30/1997" etc. Then I have to do the same multiple

>>>> entries for 3 more "Birthday" fields.

>>>> Is there a way to just use a Filter of only the Month Range without a

>>>> specific year? That way I could simply generate a list of all dogs in

>>>> month of June without regard of 1998,1999..etc. Any help would be

>>>> great. Thanks