Search found 14 matches

by Andrew_Bokelman
Tue Sep 07, 2004 3:49 pm
Forum: R&R ReportWorks Users
Topic: Report Crashes
Replies: 5
Views: 3614

==> RE: Report Crashes

Yes. If I set a filter the results in a small number of records, or I set the print option to only print a few pages, then I get no crash.
by Andrew_Bokelman
Wed Aug 25, 2004 12:25 pm
Forum: R&R ReportWorks Users
Topic: Report Crashes
Replies: 5
Views: 3614

Report Crashes

R&R SQL Edition Version 10.0, Build 10.0.011 running on Windows 2K Service Pack 4 with half gig RAM and 51 gig free hard disk space.____I have a report connected via ODBC to an Oracle Table with a couple of joins within that table. I^ve queried this source with no problems using other software. ...
by Andrew_Bokelman
Wed Feb 04, 2004 2:38 pm
Forum: R&R ReportWorks Users
Topic: Path of Related File?
Replies: 1
Views: 1605

Path of Related File?

Using the RR version 10 for dbf. When I look in the Relations list I have no way of knowing where the file is that the relationship is set to. Searching for the file doesn^t help, because there might be two files with the same name in different places.____Is there a way to get a list of the relation...
by Andrew_Bokelman
Thu Nov 06, 2003 12:24 pm
Forum: R&R ReportWorks Users
Topic: Use tables from two sources
Replies: 2
Views: 2234

Use tables from two sources

Using Version 10.0 Build 10.0.011 R&R SQL____I click File|Datasource connections, and add two data sources. Then I start to create a new report and it asks me for one of the data sources. So I pick the one that has the master table. Then I try to set a relation to the second data source and it i...
by Andrew_Bokelman
Thu Jul 03, 2003 5:54 pm
Forum: R&R ReportWorks Users
Topic: Read database with no relation?
Replies: 1
Views: 1909

Read database with no relation?

I want to set up a database with two fields and one record in which I will enter a start_range date and an end_range date. I want a bunch of my reports to be able to see these dates to use in calculations, filters, and labels. And my reason for wanting a one-record database is I can quickly change a...
by Andrew_Bokelman
Thu May 22, 2003 11:32 am
Forum: R&R ReportWorks Users
Topic: Can^t Use Blank Dates
Replies: 4
Views: 1946

=> RE: Can^t Use Blank Dates

I^m having the same problem. It will work with an existing blank date expression in a query, but it won^t let you add a new one or modify an existing one. The workaround I^m using is to create a calculated field called "blankdate" with the expression: { / / }. Except I did mine with four s...
by Andrew_Bokelman
Mon May 12, 2003 12:22 pm
Forum: R&R ReportWorks Users
Topic: Fatal Error and Cause
Replies: 2
Views: 2109

==> RE: Fatal Error and Cause

That fixed it! I also read up on RR().
by Andrew_Bokelman
Fri May 09, 2003 4:38 pm
Forum: R&R ReportWorks Users
Topic: Fatal Error and Cause
Replies: 2
Views: 2109

Fatal Error and Cause

R&R for Windows, SQL Edition__Version 10.0, Build 10.0.012____Running under:__Microsoft Windows 98__Second Edition__4.10.2222 A ____The report is hooked to an Access database. There is a calculated field called prisort that uses the expression: DIST + STR(PRIORITY) ____DIST is a character field ...
by Andrew_Bokelman
Tue Oct 02, 2001 2:49 pm
Forum: R&R ReportWorks Users
Topic: Remove dollar sign and commas
Replies: 2
Views: 2185

=> RE: Remove dollar sign and commas

Thanks. I don^t know how I missed that function, but I did. Thanks for the clear example.
by Andrew_Bokelman
Mon Oct 01, 2001 4:03 pm
Forum: R&R ReportWorks Users
Topic: Remove dollar sign and commas
Replies: 2
Views: 2185

Remove dollar sign and commas

I have a text field that contains dollar amounts with a dollar sign and one or more commas. I want to use the val() of this field but I need to get rid of the junk first. ____What would be a function or functions I can use to strip out a dollar sign and all commas. Removing everything that is not 0 ...