Recent content by whitakaster

Been there, done that!! :) We use a user defined table-valued function in SQL Server to translate a date range phrase, i.e. MTD, YTD, PRIOR 30 DAYS, LAST MONTH, LAST QUARTER, etc. and return StartDate and EndDate fields back to the report's stored proc to filter with. So, the crystal report...

I've had no luck myself. Business Objects does offer a course through their eLearning focused on Crystal Analysis, which looks good. I'll be signing up this month. I know in the past Crystal Decisions offered a CBT on CD, but that option is not available anymore, probably since they wanted to...

Yep, you are dealing with "orphaned" footers, which is a crystal glitch you have to accomodate for by using a fake header and variables to show/suppress this fake header, which will pair up with the orphaned footer. The kb article that details the steps...

We are using CE 8.5 ... Is there any way to automate the batch deleting/uploading of the report files in CE? Any command line approach? This is something that is very tedious for the number of builds and changes we go through. Currently, IT has to manually approach this task for each of our...

That did it! I wasn't including references to ADO. Thanks for the direction Rob.

I am new to VBA, and was passed some code to start looking through so we can create a Word mail merge invoice with a details section. This partial code was pulled straight out of a book, so I don't know why this isn't compiling properly. Errata what? I am using Word 2002. The first 5 lines are...

Never mind... This was a case where the Crystal "Chart Help" stated that trend lines could be generated using XY scatter graphs, but ultimately it was a "typo" that version 9 supposedly doesn't have in it's help documentation. So...No, you can't create a trend line using an...

I am trying to find out if trend lines are possible using the XY Scatter graphing format. I first just combined two graphs by underlaying one and making the other with a transparent background. This worked perfectly to combine just the trend line from a linear form of a graph and the XY...