Search results for query: *

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

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...

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...

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...

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...