Search results for query: *

Hi all, Crystal Reports 2011 Crystal Server 2011 In a number of reports I’ve connected to a SQL Server 2008 database using OLE DB (ADO). I have been given a SQL Server account that I’m to use for all reports to connect to the database. I’m prompted to enter the User ID and Password on the...

Hi All, Crystal 12.2.0.290 I make changes to the Displayed Label of the Axis label of a Chart and to the format size. I then exit Crystal reports and when I re open the report all, bar one, of the Displayed labels have reverted back to the default, and their size has changed. Yes, I am...

I’m unable to connect to Integration Services from the SQL Server Management Studio. However the Network Administrator can. I can connect to Database Engine using Windows Authentication. Where is the connection access to Integration Services from SQL Server Management Studio administered? cheers

Hi all I have numerous flat files (csv) that I want to use a Data Flow in a ForEach Loop Container to extract and then insert into a single SQL Server 2005 table. All the flat files have a number of columns that contain common data. The flat files also have a number of columns that are unique...

I have a loop that is meant to transform data from multiple ODBC sources into a single SQL database/table ... but it is not working. Without the loop the transform works fine for one ODBC source. I have eight proprietary databases that have exactly the same database name, table names and...

In a Derived Column transformation I want to transform a date such that if it is a null then replace it with 1753-01-01 otherwise keep the date value. However I’m getting an error. I’m using the following expression: ISNULL( [hrs_client_dob] ) ? 1753-01-01 00:00:00.000 : [hrs_client_dob]...

Is there a way of using SSIS to extract data from a web page? Or is there a way of using SSIS to extract data from a html file? Cheers gmhm

I’m getting the following error message with a DataReader source: The column <column name> does not have a matching source column in the DataReader schema. The DataReader source’s Connection Manager is an Ado.Net connection. The Ado.Net connection has the Provider set to .NetProviders\ODBC...

I need to extract data from tables in a database that I can only access via ODBC. I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database. However I’m unable to add this connection as a Data Flow Source. There is no ODBC Source option...

I have numerous Transform Data Tasks in which I’m logging exceptions to files that I’ve set in the Options tab. All exception files are located on the same server and folder structure (currently it is \\flafile001\datawarehouse$\DatamartErrorLogs\). This folder structure has changed several...

Is there a easy way of inserting a statistical equation into a Word document? For example p = v(p(1-p)/n) … but I would like the p(1-p) to be displayed above the division symbol (a horizontal line) and the division symbol above the n. I could use tables and hide borders (except the line to...

How can I insert letters of the Greek alphabet into a Word document? I want to use these letters for statistical notation. Examples include the Greek letters for alpha, pi and sigma. Thanks

When opening a View I get ODBC SQL ServerTimeout expired. What setting can be changed to increase the amount of time? Cheers

In a Select statement I want to convert the values in a numeric field to numeric values with the number of decimals equal to the value of another field. I’ve tried: CONVERT (decimal(18 , CurrentDecimal), Price) But I get an error message “Invalid or missing expression”. Price field is...

How do I get jpeg images into a formula? I want a report to display one of 3 jpeg images, depending on the value of a field. I'd love to say something like the following in a formula: if fieldA = 1 then jpeg1 else if fieldA =2 then jpeg2 else jpeg3 As a get around, I have the 3 jpeg images...

My report has 2 Groups. Group Footer 1 (GF1) has two sections: GF1a and GF1b. Group Footer 2 (GF2) is hidden (Drill Down Ok) I want to suppress GF1a if the user has not drilled down to GF2. That is, the user initially can only see GF1b. Then, if the user does drill down to GF2 (from...

I need to redesign a report so that it does not use variables. The need for removing variables is because I must insert a chart, where the layout of the chart shows the numbers from a formula containing variables. Crystal Reports does not allow the chart layout to show formulas that contain...

Does anyone know if I can use a formula to calculate the Maximum & Minimum Manual settings for the Scale in a Gauge chart? Thanks

Does anyone have a suggestion for the following parameter issues? We’re using CE 8.5 & CR 8.5. Both soon to be upgraded to 9. 1. We have a number of reports, where the parameter is a default list of codes (eg project codes). Users typically do remember the codes. We want to allow them to...

Why does the following formula produce the value 0 for all records? It should display 0.5 whileprintingrecords; numbervar g; numbervar array h := [1, 0.5, 0.75, 0.25, 0.666, 0.333]; numbervar counter; for counter := 1 to 2 do ( redim preserve h[counter]; g := h[counter]; ); g