Search results for query: *

Hi all, I'm using SQL Server 2005 and am currently experiencing an intermittent problem when trying to run a udf. The udf accepts 2 dates as parameters, and calculates the work time between based on working days, bank holidays etc. The problem i have is that sometimes calling the function...

Hi All, Currently migrating Seagate Info 7 reports to Crystal XI, and have come across something odd. My reports are based on Infoview/Business View, and when i migrate the old report to the new Business View, the datetime fields migrate as date fields. Has anyone ever come across this...

Hi all, Using Crystal Report Server XI R2, Crystal XI Professional. I've got a report that uses a sql command/query within the repository to access an oracle database via ODBC. Using the CRXI client, i can open the report, click refresh and it prompts me to select the correct ODBC DSN, then...

Hi, I was wondering if anyone knew a way of scheduling multiple reports to be sent in a single email? I've tried to use the object package functionality, but this will still send an email for each report since it's just a group of reports as such. Any ideas gratefully received. Thanks in advance

Hi, I am upgrading a few access tables into SQL 2000, and wondered if anyone knew an easy way of extracting the index creation sql for each of the tables within the database. Any guidance most appreciated. Thanks

hi all, i'm upgrading a seagate 7 installation to xi. The v7 install has numerous groups, for which folder security is setup within Info Desktop. Try as i might, i can't find the link within Cinfo.mdb to get from the folder objects within ci_infoobjects to the groups in ci_grpinfo, via the...

Hi, I have a few linked tables in huge access databases, and i'm trying to determine the table sources. Is there a way to access this info using vba, as i'm trying to avoid having to get access documenter installed by our desktop support bods. Any help greatly appreciated Cheers Paul

I have an SSIS Package with a data flow (called say df1), containing OLEDB source (called say src) and SQL Server Destination (called say dst). I'm trying to dynamically assign the table name from the OLEDB source to a variable (say var1) and the table name from the SQL Server destination to...

Hopefully someone will be able to help with the problem below. I'm migrating a 2000 DTS Package to SSIS, and was wondering how to mimic the below behaviours of the DTS package in my SSIS package (migration using BIDS encapsulates the below in a Execute DTS task, and i'm trying to rebuild using...

I am currently working with DTS to pull data from a very large SAP backend on Oracle. When i create a data transform between the Oracle Data source (using either ODBC connection or OLEDB) and the SQL Server destination it is taking an eternity to return the data transform dialog box...

Hi, Is it possible to have a group tree level that is used solely for navigation and not used to drill down in CR7.5? More detail; I have 5 groups within the report; 1. Company Level 2. Regional 1 3. Regional 2 4. City 5. Engineer I want the drill down enabled at levels 1,2,3 and 5, but more...