SynapseDirect

Just a plug for open source -- Sun Report Builder is relatively new to the OpenOffice suite.  It's an extension that's installed to "stock" OpenOffice.  Looks a lot like Access, does grouping, etc, and has a QBE tool.  "Stock" OpenOffice Base does have a QBE tool, but they have improved it in recent releases.

---

Jerry, have you actually used it to query the Synapse database?

If so, how hard was it?

---

Graham Chiu
Beta Downloads and Documentation Wiki

Graham:

Jerry, have you actually used it to query the Synapse database?

If so, how hard was it?

I haven't used an RDBMS to connect to remr.fdb at all yet (other than isql when we were working on the Synapse LivePC).  I have used OpenOffice BASE for other projects, however.  It's QBE tool works pretty much just like Access.  My main criticism of BASE so far (I haven't used it with OpenOffice 2.4 at all) is that the HSQLDB database engine works fine and is fast, but the OpenOffice Writer as a report and form tool is very slow. I haven't used Sun Report Builder yet, but have read about it and It's supposed to be OK -  I'm hoping its' significantly faster than OO Writer.   I will try it soon and report as to how well it actually seems to work with Synapse.

---

jparkdo:

Just a plug for open source -- Sun Report Builder is relatively new to the OpenOffice suite.  It's an extension that's installed to "stock" OpenOffice.  Looks a lot like Access, does grouping, etc, and has a QBE tool.  "Stock" OpenOffice Base does have a QBE tool, but they have improved it in recent releases.

Might be interesting to bundle a customized version of OO with Synapse.   

---

Graham:

There isn't a way to query on this field at present.

But a 3rd party tool like Crystal Reports could build the report for you.

 

Used crystallreports standard edition X1 and i am not able to open the database. Cannot find a .FDB file format in the drop down menu. Is it possible to change to file extension?

---

I see an "all files" in the drop down.

Firebird doesn't use the file extension ... so you could rename it as long as you also change your System DSN in the ODBC manager.

 

---

Graham Chiu
Beta Downloads and Documentation Wiki

Actually I would have thought Crystal Reports would allow you to use the DSN rather than open the database directly.

This means you either would create a DSN on one of the client PCs, or run it on the Server.

Disclaimer: never used CR

---

Graham Chiu
Beta Downloads and Documentation Wiki

qilin:

I am doing the search manually using MS Access now.

 qilin, how do you open a firebird databse with MS Access?

---

I downloaded OpenOffice.org 2.4 and connected okay to the Synapse database.

I was able to build simple queries but I think I am going to have to do some reading to see how joins are done.

---

Graham Chiu
Beta Downloads and Documentation Wiki