Search found 18 matches

by DAVE_I
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: 3653

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...
by DAVE_I
Thu Aug 13, 2015 8:04 am
Forum: R&R ReportWorks Users
Topic: Connecting to SQL 2008 database
Replies: 2
Views: 3280

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...
by DAVE_I
Mon Dec 09, 2013 5:32 pm
Forum: R&R ReportWorks Users
Topic: RRW.SRT options
Replies: 3
Views: 3713

==> 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.:-(
by DAVE_I
Sun Dec 08, 2013 12:49 pm
Forum: R&R ReportWorks Users
Topic: User-SQL report and ParameteRR field
Replies: 1
Views: 2782

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...
by DAVE_I
Fri Jul 25, 2008 8:27 am
Forum: R&R ReportWorks Users
Topic: Distributing reports using OCX
Replies: 0
Views: 1533

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...
by DAVE_I
Sun Jul 20, 2008 10:06 am
Forum: R&R ReportWorks Users
Topic: Using RRW.OCX under .NET
Replies: 4
Views: 2558

====> 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...
by DAVE_I
Tue Oct 02, 2007 9:05 pm
Forum: R&R ReportWorks Users
Topic: Cannot access master table
Replies: 1
Views: 1436

=> 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.;-)
by DAVE_I
Tue Oct 02, 2007 7:57 pm
Forum: R&R ReportWorks Users
Topic: Send dates from VB.NET to WHERE
Replies: 0
Views: 1240

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...
by DAVE_I
Sun Sep 30, 2007 6:41 pm
Forum: R&R ReportWorks Users
Topic: Cannot access master table
Replies: 1
Views: 1436

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...
by DAVE_I
Sun Sep 30, 2007 5:56 pm
Forum: R&R ReportWorks Users
Topic: Can^t change DataDirectory
Replies: 1
Views: 1490

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