Search results for query: *

I'm using Crystal Reports 2008 with an ODBC connection to a SQL database. Most everything I need is in a table called RECEIPT_LINES. I have a few tables inner joined to it so I can give some user friendly info (for example, the department's name vs code). I'm trying to show every Store even...

cancel the request for help, sorry. argh, I just figured out that CurrentFieldValue is really what I was supposed to write, not the value I wanted summarized. total "D'Oh!" WhilePrintingRecords; numbervar Top := CurrentFieldValue; False

I think my case is like this one so I will add on here. I'm using CR 8.5 and am connecting to a Gupta SQL db I followed a link in this FAQ http://www.tek-tips.com/faqs.cfm?fid=995 which helped me get started with calculating a percent in a crosstab. I have 3 summarized fields. I need the 3rd...

Hi LB- I used the linking expert but it shows in the query too. I'm glad it did because you caught the problem with the order of the tables. I got handed other projects so I haven't had time to finish the report and various configurations but I've already saved 30 min on the report due to...

Man, that's a great link to have. I understand some of it but unfortunately, some of it is over my head. I saw that you guys were talking about changing the order of things in the WHERE clause so I went to database > show SQL query dialog and switched the store_no = 1 and department <> '97'...

Hey again LB- Not sure what I was looking at before but, of course, how you said to do it was right. I put it back to nothing added to the original end date and +1 (not +2) on the previous year's end date. The report ended up taking about 1:45. Is that the DateAdd function adding all of that...

Thanks LB! I was worried about adding the 1 without knowing why (in case that ended up biting me later). Since my <= turned into < on both (last year and this year's) end dates, I ended up doing this: ( ( {RECEIPT_LINE.SALES_DATE} >= {?startDate} and ({RECEIPT_LINE.SALES_DATE} <=...

Hi and thanks in advance for any help you can give. Information: --CR 8.5 --Gupta SQL db --2 of my parameters are for start and end date --attempting to also select same start and end date but 1 year before --parameters I entered were 6/19/07 and 6/21/07 --results show in cross tab but with...

hi madawc. thank you for your speedy reply. i apologize for the time it took me to get back with an update. the crosstab and the running total suggestions nailed both of my biggest issues. that was awesome. now the report shows the comp sales AND looks good. sweet! thank you for taking...

i'm new to crystal and this forum and apologize up front for making up my own syntax to try to explain what i mean. i'd love any help anyone can offer. background: i have a report that shows sales for 3 diferent quarters. there are 3 groupings: product department, time period sold, and product...