Hi all you Infomaker gurus (by choice or by circumstance),
I've got a bunch of Infomaker reports that are using a DataSource select to get their data rather than a stored procedure. In hopes of getting those eventually migrated to SSRS and also getting all my code in one place (finding all the tricksy code for v11 migration has been fun) I want to change most of them to use stored procedures. Is there a way of doing this in an already created report or is it easier just to make a new report and copy/recreate all the layouts in it?
Thanks!
Heather
I am so not an infomaker guru, (which possibly makes the following self-fulfilling) but on the handful of occasions I wanted to swtich an IM report from a select to a stored procedure, I found it was faster and easier to bail on IM altogether and just create the procedure and go straight into SSRS-ing it.
Switching to stored procedures would be a great point at which to switch to SSRS. I am finding that it's a great time to enhance & improve old sprocs, too. (Has it really been more than three years since I wrote some of these. Yikes!)
Thanks guys - that was my eventual thought, but since I'm still on the SSRS learning curve if there was an *easy* way to switch out the data set I would keep them in IM. It seems there isn't, so those will be the reports I'll tackle first!
- Heather