Musician Forum - Band Discussion Board - BandMix

So, at work they have 3 or 4 different databases that they want to make a single report from, based on each employees activity.

I scowl at them, then I interrupted them, "You idiots! It can't be done. Jimmy Danger couldn't even pull that off!"

Then I walked back to my area.
[/code]

gtZip wrote:So, at work they have 3 or 4 different databases that they want to make a single report from, based on each employees activity.

I scowl at them, then I interrupted them, "You idiots! It can't be done. Jimmy Danger couldn't even pull that off!"

Then I walked back to my area.
[/code]

point taken..

gtZip wrote:So, at work they have 3 or 4 different databases that they want to make a single report from, based on each employees activity.

I scowl at them, then I interrupted them, "You idiots! It can't be done. Jimmy Danger couldn't even pull that off!"

Then I walked back to my area.
[/code]

One report/Multi DBs? That's easy...! But I believe you, about Jimmy HA!

lol, I didn't know you did that stuff Dog.
I'll use your name tomorrow...

Apparently you guys know what I can do precisely. Do you know what I'm doing right now?

Sleeping.

I wasn't poking fun, I just thought I'd let you know that I invoked the name to irritate some guys at work.
You're national.

Ah got it. I suppose infamy is preferred over anonymity. BTW did you just use ODBC? That's generally what I do, but there are 3rd party products (Data Junction) that provide easy ways to retrieve data from different sources. Right now I'm getting up to speed on MS ASP.NET MVC 4.5. With the departure of my supervisor we're stepping back from Rails and will probably be all Microsoft in the future.

If you can't export from each into a common format, then you need to look at conversion software/updates that will allow that.
I did all my DB work back in the DOS days, took hours to set up things compared to the minutes it takes now with pre-packaged aps.

can be done. Easily. Just create a GUI that makes calls to each individual DB based on whatever tables/criteria they want. I believe crystal reports can do that, although not sure if it can create a merged report from different sources, but I've seen proprietary utilities that could.

Yes Crystal can do that, like I said you just set up the the data sources using ODBC. We don't use Crystal anymore, just SSRS but they both do the same thing. The tricky thing we have going on is we have to pull data from and stay in sync with a mainframe. They've been migrating off from it for years but management really doesn't want to so it's FUBAR. There is no support for it, we actually bought an identical system we use for parts when needed.

Cool, you used ruby?
I learned it (for the most part) before Rails was born. When rails blew up it changed the community and I lost interest.

I wouldn't think Graphical 'anything' would be the answer though... lots of boilerplate unneeded code in my experience with non database oriented GUI thingys.

Either there's something fairly complicated going on, or they are fairly dumb... My SQL experience is next to nothing, but nothing I've read so far has been complicated.
And... Even in VBA on our systems, there's all sorts of Crystal hooks.

I don't know what their problem is, but it's fun to crank their tail about it.

ODBC, VB - Aiiiiiiiiiii. I'm back in the nineties!

Talbot

I can ignore all that bullshit and work with my hands . . .



At least for now.