"ODBC reporting software" Topic
All members in good standing are free to post here. Opinions expressed here are solely those of the posters, and have not been cleared with nor are they endorsed by The Miniatures Page.
For more information, see the TMP FAQ.
Back to the Computer Stuff Plus Board
|streetline ||01 Oct 2011 1:06 a.m. PST|
I'm after some software to run some historical and real time reports on an access 97 db – I've used crystal in the past so something similar would be great, but my old copy of crystal doesn't work on XP pro. I have no budget for this at all yet
Is there anything like the old free Seagate 7 that would work on XP?
| Saber6 ||01 Oct 2011 2:50 p.m. PST|
Can't you pull a copy into a more recent version of Access? Many of the features of Crystal are in the newer versions of Access.
| Ditto Tango 2 3 ||02 Oct 2011 4:09 p.m. PST|
Heck, just use A97. It depends on what you are after. To me, absolutely no offence meant to you or saber6, (I've been working with Access since version2 as a front end connected via ODBC to an Oracle database since 1995) but I can't imagine using Crystal against an mdb. It's pretty easy to get whatever you need from Access itself.
If there's anything you want to know about Access, post here or pm me here. I'm currently on holiday for a couple of weeks and don't have "access" to a copy of Access, but a lot of stuff I can tell you opff the top of my head.\
|pphalen ||02 Oct 2011 6:32 p.m. PST|
Why not link to the Access DB via ODBC direcly in Excel?
|SpaceCudet ||03 Oct 2011 2:20 a.m. PST|
What the Snowman said – IMO Access reports are easier to use and get just as good a result as Crystal. I've always been amazed that Microsoft has never made it a stand alone product.
|streetline ||03 Oct 2011 9:26 a.m. PST|
I'll give it shot then, cheers all. I'm used to using crystal to point at other stuff so it was just what I was used to