Search results for query: *

The following works but I would like to figure out how to use "Array" like I do in Crystal i.e. ...in ["A","B","C"]. Thanks! '********************************************************************** ' Visual Basic Transformation Script...

I would like to filter data to get the "last full month" only. How can this be done in DTS? Thanks!

WITH NO CORRESPONDING FIELD IN THE SOURCE TABLE. I.E. "A" TO BE POPULATED IN THE FIELD "ORG" IN THE DESTINATON TABLE, STANDING FOR ORGANIZATION A. So when pumping data from multiple databases with the same file structure into one table, I want to id the organiztion from...

The following query works fine until I try to add another criteria to filter out: not like "S*" or not like "L*" (When I do it ignores both criteria) ------------------------------------------------------------ SELECT [T1 Net Data].INVOICE_NUMBER, Min([T1 Net...

I summarized billing data group by date. Calculated a "running total distinct count" which works fine. What I am trying to do now is to compute the cumulative % of distinct record count to the total record count. Example: DATE RT_Distinctcount % to total RT 09/01/01...

I found a solution on the crystaldecisions website under "businessdays". You must download a file "businessdays.zip". Once you have loaded the exec. file it looks like this: (as you see below it loads a text file for holidays)...

How would one calculate the number of weekdays (or if possible business days) in a given month? Thanks,

I have CR 8.5, using Running Totals expert I created running totals and dropped the formula in the page footer and it works great. However I would like to reset the RT at each page number change, there is no grouping in my report. Thanks for your help!