Search found 9 matches

by ABessey
Wed Sep 02, 2015 12:04 pm
Forum: R&R ReportWorks Users
Topic: Connecting to SQL 2008 database
Replies: 2
Views: 3317

=> RE: Connecting to SQL 2008 database

Are The fields in the table NChar, Nvarchar?__I think that R&R cannot display some of the new SQL2008 Data types including the NVarchar types which are Unicode.__These data types just show up on preview as blank.__Use Varchar or Char or use the SQL convert function to change them. (SQL Report)__
by ABessey
Wed Dec 10, 2008 9:53 am
Forum: R&R ReportWorks Users
Topic: multiple outer (left) joins
Replies: 2
Views: 1756

==> RE: multiple outer (left) joins

Can you name any ODBC Drivers that R&R can use which support multiple Left outer joins and are Microsoft sql 2005 compatibility (90) Compliant ?____Will future versions of R&R use fully comlpliant left Outer joins__Ie Not "*=" and "=*" that will work with Microsoft sql 20...
by ABessey
Fri Sep 12, 2003 8:30 am
Forum: R&R ReportWorks Users
Topic: Problem with R&R V10+
Replies: 2
Views: 1797

==> RE: Problem with R&R V10+

The problem with not in list handling blanks oddly is caused by Nulls in the data field to be tested. Nulls can not be evaluated in sql with standard server settings and should be tested also as in:__(myfield not in list ^xx^,^yyy^,^zzzz^ OR myfield is null).____A Null is not the same as a blank. Yo...
by ABessey
Thu Aug 21, 2003 4:15 am
Forum: R&R ReportWorks Users
Topic: RR10+ Patch Negative Picture Prob
Replies: 1
Views: 1270

RR10+ Patch Negative Picture Prob

Just Tried the new Patch for R&R 10 (Version 10.1.012) __by chance I used a report with a Picture from field embedded in it it points to a jpeg source which used to work but now displays negative on all pictures (5000 ). ____I can see no preference settings to change this.____The report is an au...
by ABessey
Mon May 12, 2003 10:10 am
Forum: R&R ReportWorks Users
Topic: Does RR10+ Fix Out of mem Err^s.Etc
Replies: 0
Views: 1217

Does RR10+ Fix Out of mem Err^s.Etc

I have seen you new ad for the stepup for R&R 10 ,__Does it fix the main bugs I suffer from with v10.02__sql/xbase (Previous Posting), or has it just got extra features?____Will the new ODBC drivers Particularly the Microsoft SQL replacement allow more than one database to be accessed at one tim...
by ABessey
Wed Apr 30, 2003 7:32 am
Forum: R&R ReportWorks Users
Topic: Out of memory during preview
Replies: 2
Views: 1615

Out of memory during preview

When is the out of memory during preview in RR10 going to be fixed, it is making life impossible at the moment and I have had to go back to ver 9, as restarting the application every time is not helpfull.____I also suffer with Users crashing when accessing printers using the OCX from delphi, when &q...
by ABessey
Fri Dec 06, 2002 10:19 am
Forum: R&R ReportWorks Users
Topic: Out of memory During preview
Replies: 7
Views: 3435

Out of memory During preview

I am currently working with 1 memo/text field carrying a small amount of text ,plus a few normal char fields in R&R 10.1 (patched) ,attatched to 1 table on MSSQL 7 using an ODBC connection to the server. MDAC 2.7____Running under Win2k wkststation with 1 gig memory.____If I preview through the d...
by ABessey
Thu Oct 10, 2002 4:03 am
Forum: Enhancements / Suggestions / General Comments
Topic: R&R SQL 9, field alignment Bug
Replies: 2
Views: 2126

R&R SQL 9, field alignment Bug

I have had problems in Version 9 with the odd data field suddenly becoming shorter in length, and when clicked on shooting off to the left side of the screen where it wont let go of the margin. When looking at its properties I have found that the alignment is gone. IE no left/right or justify are se...
by ABessey
Thu Jul 05, 2001 10:39 am
Forum: R&R ReportWorks Users
Topic: Problem Adding an extra MSSQL7 database to report
Replies: 1
Views: 1357

Problem Adding an extra MSSQL7 database to report

In a report using a single MSSQL7 ODBC datasource I need to__ add another datasource to access other tables, my data source/__database dropdown box in the joins window is empty, I can see__the tables in the original but can not add an extra datasource/__database.__I have been doing this for years in...