Search results for query: *

I have a very strange issue in Informatica. I have an input value that is getting flipped to a different value, the following value which contains a double dash gets flipped to upside-down question marks when inserted into an Oracle 10g database table. The incoming value within a...

For some reason certain records are being dropped from the report. I am using CR 11.5 (R2), with a Lotus Notes 7 view as the datasource for a report, I am using an ODBC connection with the Notes SQL Driver 3.02 to connect to this view. When I go directly into Notes and look at the view I can...

I am using CR 11.5 (R2), with a Lotus Notes 7 view as the datasource for my report, I am using an ODBC connection with the Notes SQL Driver 3.02 to connect to this view. For some reason certain records are being dropped from the report. When I go directly into Notes and look at the view I can...

I have a report that uses a cross-tab to display the data. The source of data for the report is a SQL Server view. The report is supposed to display the sum of the lengths of time that a service request spent in various statuses. The status field is the column field, row field is the request...

I have a subreport that has a Crystal command as it's datasource, this command is a union query. I would like to pass a parameter from the main report into the WHERE clause of the first select of the union query. I can't get anything to work. Let me explain a little about what I am trying to...

I am using Crystal 11.5 with Lotus Notes 7 views as datasources for my report. I am trying to create a report that returns data starting with the previous business day. I was working on a function that does that, but I need to consider our corporate holidays. Here is a draft of the function...

Is it possible to have the cross-tab control display sums of the row values and also display averages of the columns? If you change the type of summation in any of the totals fields, it changes it for the whole report. Crystal Server XI R2 SP 1. Thanks

I am having trouble with the colors on a bar chart. I have a chart that displays a series of paired bar charts, displaying the number of new and closed service requests for each month over a 13 month period. So in the chart expert I have 2 values in the "on change of" box (month and type - the...

I have a problem with a cross-tab report that seems similar to that found in thread149-1029079, but it is not quite the same. I have a table that holds history records for service requests, so a set of these records for each particular request would show all of the activity during the life...

Is it possible to change the page orientation from portrait to landscape based on the data? I have a crosstab report and depending upon the data I can get anywhere from 4 or 5 columns up to 15 or 16 columns. Portrait orientation will allow for 11 columns max, I would like to use portrait when...

Is it possible to have completely independent If statements in one record selection formula? I am using Crystal 11.5 with a SQL Server 2000 database using ODBC. The datasource for the report is several SQL Server tables, and 4 crystal commands that create lists of values for the parameters...

I have a situation with parameters that I need help with. I am using Crystal XI (v 11.5.3.417), with SQL Server 2000 database. I have a report whose main datasource is a stored procedure, and secondary datasources that are Crystal Command objects, used as lookups to get distinct lists of...

I am using Crystal XI sp2 with a SQL Server 2000 database. I have a report that uses date parameters (start date and end date), from a stored procedure (the SP being the data source for the report). These are input parameters of the SP that are being used to set a time frame within which the...

I have a Crystal report where I need to produce counts of service requests per month for a 13 month period. I have a rather complicated solution that will produce the data based on the current date (using getdate()). Now the users would like to be able to select the end date for the report...

I am using Crystal XI with Lotus Notes 7 as the datasource. I am using the Lotus NotesSQL driver 3.02 to connect to the Notes data using ODBC. It doesn't appear that the SQL commands can be used when using this connection to Notes data, "Add Command" does NOT appear as an option like it does...

I have what should be a simple problem. I have stacked bar chart that shows cycle times for different tasks for people within a department. I have the user select the department as a parameter when opening the report. I use the department as the Group By field on the report and the chart is...

I get an error message with a SQLState = 42920, which says that you can't have a Group By clause in an embedded Select statement. My problem is that I can have multiple tbl2.fldB values for each tbl2.fldA value. If I don't restrict it somehow I get an error that the subselect is returning...

I am performing a union query, and the fields and datatypes match up and I produce output. My problem is that I sometimes get exact duplicate records, I would like to eliminate these. The data I want could be in either of 2 tables, if it is not in the first one then I want to look in the...

I have a table in which I initially use an insert statement to populate all of the rows but only some of the fields in the table. I then want to update the rest of the fields using a separate update. The way I am doing this is to run a series of Select Into statements to fill variables, then...

I have a situation in which I am initially inserting a set of records into a table (tableA) and then, using a series of updates I need to update a field (tableA.field1) in the same table which was not populated during the initial insert. I am plannining on using the For Update Of and Where...