Search found 18 matches
- Fri Sep 25, 2015 4:19 pm
- Forum: R&R ReportWorks Users
- Topic: R&R Runtime VERY slow to launch when more than 1 table involved
- Replies: 0
- Views: 4722
R&R Runtime VERY slow to launch when more than 1 table involved
I^m using R&R 12.5 with an access database. I^ve been using the same reports against the same database for quite a while. On 1 user^s PC (XP) when a report is launching that has more than 1 table, R&R appears on the taskbar, but the report then hangs. It^s possible that if the user would wai...
- Thu Aug 13, 2015 8:04 am
- Forum: R&R ReportWorks Users
- Topic: Connecting to SQL 2008 database
- Replies: 2
- Views: 4914
Connecting to SQL 2008 database
I^m trying to build a report (beginning with 1 table only which contains basic employee information) using a table in SQL 2008. I built the ODBC connector using SQL Native Client. When I use R&R (v12.5) I drop a few fields on the detail row and run it without any filters. What^s weird is that on...
- Mon Dec 09, 2013 5:32 pm
- Forum: R&R ReportWorks Users
- Topic: RRW.SRT options
- Replies: 3
- Views: 5363
==> RE: RRW.SRT options
I used the COMPARECASE=COMBINED to treat upper and lowercase identically for sorting/grouping purposes. What I discovered was that on a Windows 7 PC and an Access database (MDB) resulted in incredible slowness.:-(
- Sun Dec 08, 2013 12:49 pm
- Forum: R&R ReportWorks Users
- Topic: User-SQL report and ParameteRR field
- Replies: 1
- Views: 3866
User-SQL report and ParameteRR field
I have a User-SQL report that I created which works fine with this SQL statement:__SELECT VTLG.LASTNAME, VTLG.FIRSTNAME, VTLG.SEX, VTLG.AGE, VTLG.DATEON, VTLG.DATEOFF__FROM VTLG__WHERE (_((VTLG.DATEON)<=#12/31/2012#) AND ((VTLG.DATEOFF)>=#12/01/2012#)OR___((VTLG.DATEON)<=#12/31/2012#) AND ((VTLG.DAT...
- Fri Jul 25, 2008 8:27 am
- Forum: R&R ReportWorks Users
- Topic: Distributing reports using OCX
- Replies: 0
- Views: 1973
Distributing reports using OCX
I^m using .net and running R&R Infinity created reports quite nicely on the PC that I^ve got the full R&R installed on. However, I^m trying to follow the instructions to distribute these to other users. The database is an MDB. Do I just need to distribute the files on pages 320-322 of the SQ...
- Sun Jul 20, 2008 10:06 am
- Forum: R&R ReportWorks Users
- Topic: Using RRW.OCX under .NET
- Replies: 4
- Views: 3541
====> RE: Using RRW.OCX under .NET
Here^s my basic approach:__1) I have the runtime details about all the reports in a dbf file__2) I have screens appropriate for the various reports built where I prompt the user for some parameters for their selected reports__3) in the code below, I^ve already obtained parameters from the user on th...
- Tue Oct 02, 2007 9:05 pm
- Forum: R&R ReportWorks Users
- Topic: Cannot access master table
- Replies: 1
- Views: 2052
=> RE: Cannot access master table
I discovered the problem: I needed to create an ODBC datasource for dbase and point it to the folder where I had sent the dbf files.;-)
- Tue Oct 02, 2007 7:57 pm
- Forum: R&R ReportWorks Users
- Topic: Send dates from VB.NET to WHERE
- Replies: 0
- Views: 1682
Send dates from VB.NET to WHERE
I^m using Infinity and the OCX controls to run reports. I have a screen in my app where I prompt the user for a string to filter on and a couple of dates (using Calendar controls). I need to send those values to a couple of reports which will run sequentially. Since I struggled but finally succeeded...
- Sun Sep 30, 2007 6:41 pm
- Forum: R&R ReportWorks Users
- Topic: Cannot access master table
- Replies: 1
- Views: 2052
Cannot access master table
I^m using R&R Infinity for SQL. Most of my reports are based on an MDB, however I^ve created one report that uses 2 dbf files as the source data (no MDB involved in this report). I^m using the OCX controls to run the report. I^ll end up distributing the reports and application and am not sure wh...
- Sun Sep 30, 2007 5:56 pm
- Forum: R&R ReportWorks Users
- Topic: Can^t change DataDirectory
- Replies: 1
- Views: 2005
=> RE: Can^t change DataDirectory
I found my problem. For some reason, it needed this syntax:__Me.RSReport1.DataDirectory() = s_ApplicationStartupPath____Most of the report objects do not need the "()" after the name.