Hello,
I'm trying to create a pricelist for a new product line. My issue is that the products are sold based on size. There are 4 set sizes with set prices and 1 variable size priced by square foot. The products have a root name. It is the same for each product pattern but suffixed by /A, /B, /C, /D, /E to denote the different sizes available.
Example:
Carpet Pattern called "Circles"
6' x 9' = "Circles/A"
8' x 10' = "Circles/B"
9' x 12' = "Circles/C"
10' x 14' = "Circles/D"
Custom/sq ft = "Circles/E"
The pattern names in the database are as noted in the above example. I have grouped on the root pattern name by creating a formula called "sting length", equated as: =length{Pattern.Name}
I then used this formula in a srting command called "Pattern" equated as: left({Pattern.Name},{@string length}-2). This removes '/x' from the end of the sting. I then group on the {Pattern} formula.
I do this because we display an OLE object, in this case and image of the pattern. It only needs to be displayed once, not for each size (We suppress the OLE image with a <> {Pattern} so it diplays only once per corresponding record).
I would like the database pattern names diplayed beside the image with a description and price but can't achieve this due to group 1 only pulling the first record of that field. I've tried grouping on the database pattern name as group 2 then displaying details with multiple columns and toggling on the format groups with multiple columns option but the limited formating structures can't achieve the desired format. I want this report to be functional as additional product lines are added/dropped and prices are updated and as such do not want to rely on manual formula fields to display pattern names and prices.
Desired format:
sections not listed are not an issue
Group 1 - {Pattern}
Group 1 Header - OLE Image along with each sized pattern names 'Circle/X' displayed in a vertical list for each size, description and price records diplayed beside each corresponding pattern size.
Details - suppressed - same as group 1 desired format except the OLE image is repeated for each record. I only need the image once hence group 1.
Group 1 footer - blank - space to separate records in the group 1 header for aethetic purposes.
Is there a way to do this? Maybe a formula that works similar to a running total except for strings, reset on the {Pattern} formula I created and grouped on? Local variable arrays? Anything please and thanks!!!
Thanks!!!
Paul
I'm trying to create a pricelist for a new product line. My issue is that the products are sold based on size. There are 4 set sizes with set prices and 1 variable size priced by square foot. The products have a root name. It is the same for each product pattern but suffixed by /A, /B, /C, /D, /E to denote the different sizes available.
Example:
Carpet Pattern called "Circles"
6' x 9' = "Circles/A"
8' x 10' = "Circles/B"
9' x 12' = "Circles/C"
10' x 14' = "Circles/D"
Custom/sq ft = "Circles/E"
The pattern names in the database are as noted in the above example. I have grouped on the root pattern name by creating a formula called "sting length", equated as: =length{Pattern.Name}
I then used this formula in a srting command called "Pattern" equated as: left({Pattern.Name},{@string length}-2). This removes '/x' from the end of the sting. I then group on the {Pattern} formula.
I do this because we display an OLE object, in this case and image of the pattern. It only needs to be displayed once, not for each size (We suppress the OLE image with a <> {Pattern} so it diplays only once per corresponding record).
I would like the database pattern names diplayed beside the image with a description and price but can't achieve this due to group 1 only pulling the first record of that field. I've tried grouping on the database pattern name as group 2 then displaying details with multiple columns and toggling on the format groups with multiple columns option but the limited formating structures can't achieve the desired format. I want this report to be functional as additional product lines are added/dropped and prices are updated and as such do not want to rely on manual formula fields to display pattern names and prices.
Desired format:
sections not listed are not an issue
Group 1 - {Pattern}
Group 1 Header - OLE Image along with each sized pattern names 'Circle/X' displayed in a vertical list for each size, description and price records diplayed beside each corresponding pattern size.
Details - suppressed - same as group 1 desired format except the OLE image is repeated for each record. I only need the image once hence group 1.
Group 1 footer - blank - space to separate records in the group 1 header for aethetic purposes.
Is there a way to do this? Maybe a formula that works similar to a running total except for strings, reset on the {Pattern} formula I created and grouped on? Local variable arrays? Anything please and thanks!!!
Thanks!!!
Paul