Search results for query: *

Hi , great I'll try that too. The problem with the "Script out of range" was that the ActiveWorkbook.Connections("MSP_RECON") was incorrectly named. I kept looking at problems with my datat type declarations Once this was changed the VBA worked perfectly. Thanks to all for youe help! Carlo

Hi, Thanks for the quick response. I added a file to my original post (and again in this one). I database is a SQL database (on a MS 2013 server). In EXCEL I just choose Command Type as SQL and add my query. From what I understand of the VBA.. StartDate = Sheets("Sheet1").Range("D2").Value...

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

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

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

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

Hi, Thanks for the quick response. I used the formula: Left ({MT_PP_Employee_View_All.MT_Employee_ID_Text},6) = Left ({tblPatient.fstrPatientNum},6) and now I get the information I want. I was under the impression that Crystal would handle the joins if the fields were the same type(string in...

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

Hi Turkbear, The data is from our scheduling application (kronos ) and data is in our data warehouse (MS SQL server). The field is defined as char(24), not null. I wrote the query in SQL (MS 2005 Management server) and placed it in Crystal. I use other parameters (date, employee numbers...)...

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

Hi RTag, Thanks for your quick response. I tried this by choosing a new connection > ADO > SQL Native Client. After entering the server and database and checking the "integrated security" I get an error: ADO error: error code ox80040e73 Desc: Format of the initalization string does not conform...

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

Hi, I solved this problem by not using a sub-reports. It just took too much time to re-calculate every request to the subreport. I re-did my SQL query (nesting all the queries instead of using tables) and now it's very quick (40 seconds). Thanks for the help

Hi Dell, No, the subreport is linked to the main report on employee number on the detail level. I tried running it at the group level(main) to detail(sub) and it takes just as long. Thanks

Thanks hilfy. Your response answers a lot of questions. What I'm trying to do is track employees in our PR system that got multiple entries in error then report which timecard it happened in. If I cross the original SQL queries I'll get multiples of the original enteries and this will be...

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