Recent content by pamgdevlin

Thanks so much for your help!!!

Say I have a text field with 5 words, each separated by a space.....for example: Mary had a little lamb Using a query, what would be the best way to pull out the third "word" 'a'?? Any suggestions would be appreciated. Thanks

Thanks so much!!!

I have a daily report that shows quantity of part codes shipped each day in the month (please see below) 8/1 8/2 8/3 8/4 xx5502 5 7 9 2 xx4473 0 0 12 8 xx1700 1 2 3 4 Because I have "{DESPATCH_NOTES.DESPATCH_DATE} in MonthToDate" in the selection expert, the report starts over for the next...

Thank you Alex....sometimes I have to be hit on the head to see the obvious....I usually avoid using the group header because I like to have the name on each page in case the data produces multiple pages for each agency, however, in this case putting the name in the group header will work as...

Help.... Have a report with page break after my group footer (have name in page header so logo repeats on every page, but each page has different agency name on it). Report ends fine without a blank page, but if I place a subreport in the report footer, the name of the agency on the previous...

lbass, Thanks.....I was over-thinking this and making it much more difficult than it actually was! Worked perfectly!

Help please.... I have to create a report that shows sales grouped by product size, by day, in the current month, displayed horizontally on the page...for example product size 9/1 9/2 9/3 9/4 size 10 3 5 7 9 size 12 2 4 6 8 Can someone give me an idea of...

Help...Would like to use a formula using either the first day of a month or the last day of a month. I know I need to use something like: DateSerial(Year(Date()),Month(Date()),0) for last day, but I know this is not the correct syntax. Can someone give me some help Thanks Tamgdevlin

I'm working in Crystal 8.5 grouping and summing the historical quantities of products for specific months and my main report looks like this: JAN FEB MAR APR MAY JUN 380005 123 555 76 678 55 99 Since July data is in a different table, I'm using a subreport to add...

lbass, Sorry, I'm new to all of this...however, you are an inspiration!!! As I was reading your last post, it dawned on me that I needed to change the line to read counter := recordnumber and it worked. Thanks so much for your advice and patience.

lbass, Below is the original formula you gave me for the rankings...works great except I need the count to skip when 2 percentiles are the same: 98.1% 1 97.3% 2 97.3% 2 95.0% 4 I tried the second formula you gave me changing line 3 to read counter := groupnumber which didn't work...

Thanks lbass, the ranking formula was especially helpful!! In response to your question...I do need the rank to skip to the next number if there are two of the same rank; what should I do to accomodate that change?

Help!!! I have created a report that sums the sales for 7 regions for the months of July 04 and July 03. I then created a formula to show the percentage of July 04 sales vs the July 03 sales and I want the regions to sort in descending order based on that formula. However, when I try to do a...