RB Grouping question

Yahoo Archive
1
Thank you, thank you, thank you to Carol, Jon and Sarah

You people are really great!!

Rick

Rick Gors wrote:

> I have a simple report to print the partbin and partnumber, desc, etc.
>
> I first grouped on the partbin and set it to print once. This is
> fine.
>
> Now I want to start a new page every time the first letter of the
> partbin changes.
>
> I figured I needed to make a user defined formula to "drop" or "strip"
>
> or somehow ignore the balance of the characters. But of course I'm
> unable to determine the correct function or command to acheive this.
>
> Any pointers out there? Troy? Sarah? Santa?
>
> Thanks in advance!!
>
> Rick Gors
> MR/MMIS
> Osco
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
[Image]

>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
I have a simple report to print the partbin and partnumber, desc, etc.

I first grouped on the partbin and set it to print once. This is fine.

Now I want to start a new page every time the first letter of the
partbin changes.

I figured I needed to make a user defined formula to "drop" or "strip"
or somehow ignore the balance of the characters. But of course I'm
unable to determine the correct function or command to acheive this.

Any pointers out there? Troy? Sarah? Santa?

Thanks in advance!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]
3
FirstLetterBinNum


substring(BinNum,1,1)


First Group by FirstLetterBinNum (Reset Page)
Then Group by BinNum

-----Original Message-----
From: Rick Gors [SMTP:rgors@...]
Sent: Thursday, August 23, 2001 2:41 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Grouping question

I have a simple report to print the partbin and partnumber, desc,
etc.

I first grouped on the partbin and set it to print once. This is
fine.

Now I want to start a new page every time the first letter of the
partbin changes.

I figured I needed to make a user defined formula to "drop" or
"strip"
or somehow ignore the balance of the characters. But of course I'm
unable to determine the correct function or command to acheive this.

Any pointers out there? Troy? Sarah? Santa?

Thanks in advance!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]


------------------------ Yahoo! Groups Sponsor

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable access.
)
(1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
4
SUBSTRING(PartBin.BinNum,1,1) will return the first character in the bin
number.
-----Original Message-----
From:
sentto-20369-23149-998595700-jhellebuyck=stremel.com@...
[mailto:sentto-20369-23149-998595700-jhellebuyck=stremel.com@...
.com]On Behalf Of Rick Gors
Sent: Thursday, August 23, 2001 2:41 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Grouping question


I have a simple report to print the partbin and partnumber, desc, etc.

I first grouped on the partbin and set it to print once. This is fine.

Now I want to start a new page every time the first letter of the
partbin changes.

I figured I needed to make a user defined formula to "drop" or "strip"
or somehow ignore the balance of the characters. But of course I'm
unable to determine the correct function or command to acheive this.

Any pointers out there? Troy? Sarah? Santa?

Thanks in advance!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
5
Hi Rick,

Here's what I would do:

Create a calculated field called FirstLetter with a calculation of:
(SUBSTRING(BinNum,1,1)

Then create a sort and group by FirstLetter. This sort should come before
your PartBin sort. Under the Attributes for the FirstLetter Group, click
the 'Reset Page' option. Email me if you have questions.

HTH,

Sarah


-----Original Message-----
From: Rick Gors [mailto:rgors@...]
Sent: Thursday, August 23, 2001 3:41 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RB Grouping question

I have a simple report to print the partbin and partnumber, desc, etc.

I first grouped on the partbin and set it to print once. This is fine.

Now I want to start a new page every time the first letter of the
partbin changes.

I figured I needed to make a user defined formula to "drop" or "strip"
or somehow ignore the balance of the characters. But of course I'm
unable to determine the correct function or command to acheive this.

Any pointers out there? Troy? Sarah? Santa?

Thanks in advance!!

Rick Gors
MR/MMIS
Osco


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/