Recent content by lynchg

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 should also state that the problem that I was having initially has been resolved. That problem was really with my querying, I added a field to my view that holds the total time per team per status. The problem that I have now is that sometimes some of the time-spent values are not displaying...

The cross-tab control is in the group footer of the work team field. A work team is assigned to work on a service request (SR), it is possible that during the lifetime of an SR that it could be passed from one team to another. The users select the dept and team (or possibly all teams within a...

I can fix this by grouping and summing in the view and not relying on the cross-tab to come up with the sums of time segments that each SR spent in each status. I was just curious as to why the cross-tab control wasn't doing it properly, it seems like a bug to me. The example that hit me as I...

Below is the SQL for the view that is the source of the data for the report, and also for the cross-tab control. This data deals with a service request system for our IT dept, a service request (SR), is usually a small job to address a specific problem or some smal IT job that isn’t large...

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...

lbass, I did not originally enter a default value for the parameter and so the parameter didn't "stick" in either the command window or the field explorer. I went back into the command window, entered a default value, saved it, saw that the parameter now appeared in the field explorer along...

Here it is: SELECT CORP_MBR_ID, MEASURE_CLASS, MEASURE_NAME, MIN_REQUIREMENT, SRVC_FROM_DATE, DISPLAY_CODE, NUM_TO_DISPLAY, AGE_MONTHS FROM DM101.PED_WORK WHERE CORP_MBR_ID = '{?pCORP_MBR_ID}' UNION ALL SELECT CORP_MBR_ID, MEASURE_CLASS, MEASURE_NAME, MIN_REQUIREMENT, SRVC_FROM_DATE...

Thanks for your help. But I am still having some trouble getting this to work. I followed your instructions to create the parameter in the command, double-clicked on it and it was properly placed in my where clause. I closed out of the command editing window and the Database Expert, the newly...

lbass, in thread thread 766-1419039 you mention that you can use parameters in the SQL in a command. I was hoping there would be an example of the syntax, but there isn't. That is exactly what I am trying to do. If someone could post an example of that I would really appreciate it. Thanks

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...

LB, I spent a lot of time trying to use basic syntax for the initial formula in the subreport and I couldn't get it to work. So I decided to leave it as crystal syntax and use basic for the LastBusinessDate function. It looks like it is working. I pushed it back to Labor Day weekend by...

It sounds like you just need group and/or report totals. Just use the 'Insert Summary' button in the toolbar at the top of the design screen. You can use the wizard to insert totals on groups and totals for the whole report. All of the date calculations you have done shouldn't affect the...