Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lynchg

    Characters being switched within Informatica

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

    Missing Records on Crystal Report from Notes View

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

    CR 11.5 with Lotus Notes Data is Dropping Rows

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

    Bug in Cross-Tab Control?

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

    Bug in Cross-Tab Control?

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

    Bug in Cross-Tab Control?

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

    Bug in Cross-Tab Control?

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

    Bug in Cross-Tab Control?

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

    Feeding parameter value into command object

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

    Feeding parameter value into command object

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

    Feeding parameter value into command object

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

    Feeding parameter value into command object

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

    Feeding parameter value into command object

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

    Finding Last Business Day

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

    Selecting records on maximum(date+time) field

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

    Finding Last Business Day

    Is the type of code in your example only valid in Crystal syntax in a formula? I need to continue in the loop until I have stepped back enough days to arrive at a valid business date, and then return that date, or evaluate a date field on my report based on the result of the loop. The looping...
  17. lynchg

    Finding Last Business Day

    If I am not mistaken the left join would exclude any records with a timestamp in the holiday dates list from the report entirely. I didn't explain it quite enough in detail, but I DO want to include data from holidays, I just don't want the report data time range to begin on a holiday date. I...
  18. lynchg

    Finding Last Business Day

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

    Formate the Y axis caption on chart report

    Have you tried using a formula field to format the date value and then use that formula field as your grouping field. You can use the ToText function in your formula to format the date as you wish. Like: ToText(yourDate,"MMM-yyyy")
  20. lynchg

    Sums and Averages in the Same Cross-tab?

    I tried the horizontal option, that tends to push me out to a second horizontal page when the data create a lot of columns. I'd rather stretch the report vertically than horizontally, having the columns span more than one page within one grid is worse than having the rows get pushed to a second...

Part and Inventory Search

Back
Top