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 dencom 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: *

  • Users: olrac
  • Content: Threads
  • Order by date
  1. olrac

    Excel 2010 -- adding date parameters to the SLQ query via the Connections properties

    Hi, I'm very new to VBA for EXCEL 2010. I wrote a query with a where clause : WHERE TC.TimeCardDateTime = '2015-07-08' and then a VBA piece: Private Sub RefreshQuery() With ActiveWorkbook.Connections("MSP_RECON").OLEDBConnection .CommandText = "EXECUTE...
  2. olrac

    Displaying detail when grouping at different levels

    Hi, I'm having problems displaying details when using conditional groupings. Example: line type earn-code hours d 0074 25 d 0074 25 d 0074 25 GF 2 75 (total) d 0075 35 d 0075 35 GF2 70 GF1...
  3. olrac

    Crystal Reports - Dynamic parameters

    Hi, I'm just starting out using Dynamic parameters. I set ine up based on groupings of place site names. It works but the pick list is missing all sites starting with "A". When I add the range "... Brooks Landing" the sites starting with "A" appear on the report. Any ideas. Thanks
  4. olrac

    unhandled exception crw32.exe. Access violation reading location

    Hi, I get this error every once in awhile: unhandled exception crw32.exe. Access violation reading location 0x00000020 Oddly enough it seems to correct itself after a few days of not using the Crystal Reports application. But now it's been 3 days . Any ideas onhow this is to be fixed? Thanks
  5. olrac

    Crystal XI field linking

    Hi, I am trying to link two tables on the same field (employee_number). The employee numbers in the tables are the same but of different lenghts (on is 6 and the other is 50). When I run the report it will not pickup anthing from the the table with the 50 char string (I used a left join). Is...
  6. olrac

    Database Vendor code 102

    Hi, I am trying to pass a string parameter 15 characters long: RCC.RGCC_Code = {?Cost_centre}. The string I type in is 91.71.11520000 but I keep getting the error message database vendor code 102. Any ideas? I use Crystal Version 11.0 Thanks
  7. olrac

    Crystal Reports - Dynamic parameters

    Hi, I'm getting "batch" and "filter" buttons when I create a dynamic parameter fo pick department codes. Is it because my pick list is too large? How can I expand this or remove this? Thanks
  8. olrac

    Crystal XI report with a subreport taking a long time to complete (2h

    Hi, I'm new to this forum and appreciate any help. I created a main Crystal report using SQL query plus a subreport via an SQL view. The link is via employee number. Separately the reports take no more than a few minutes but linked via a subreport ... it goes on for hours. Question: 1 - Does...

Part and Inventory Search

Back
Top