Search found 9 matches
- Wed Sep 02, 2015 12:04 pm
- Forum: R&R ReportWorks Users
- Topic: Connecting to SQL 2008 database
- Replies: 2
- Views: 4918
=> 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)__
- Wed Dec 10, 2008 9:53 am
- Forum: R&R ReportWorks Users
- Topic: multiple outer (left) joins
- Replies: 2
- Views: 2324
==> 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...
- Fri Sep 12, 2003 8:30 am
- Forum: R&R ReportWorks Users
- Topic: Problem with R&R V10+
- Replies: 2
- Views: 2340
==> 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...
- Thu Aug 21, 2003 4:15 am
- Forum: R&R ReportWorks Users
- Topic: RR10+ Patch Negative Picture Prob
- Replies: 1
- Views: 1600
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...
- 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: 1597
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...
- Wed Apr 30, 2003 7:32 am
- Forum: R&R ReportWorks Users
- Topic: Out of memory during preview
- Replies: 2
- Views: 2004
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...
- Fri Dec 06, 2002 10:19 am
- Forum: R&R ReportWorks Users
- Topic: Out of memory During preview
- Replies: 7
- Views: 4795
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...
- Thu Oct 10, 2002 4:03 am
- Forum: Enhancements / Suggestions / General Comments
- Topic: R&R SQL 9, field alignment Bug
- Replies: 2
- Views: 2901
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...
- Thu Jul 05, 2001 10:39 am
- Forum: R&R ReportWorks Users
- Topic: Problem Adding an extra MSSQL7 database to report
- Replies: 1
- Views: 1729
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...