1 Report for 9 databases

[lanm]

The web application I have has nine databases (and it's only going to get larger in number), and for each database we have the same report, but the dataset is set to that database's table.

What I'd like to do, and I'm almost sure it can be done, is look at the session object when the user logs into the application, and see which database they're using from a dropdown list they choose on the first page. With this db session object, I'd like to pass a parameter for the report to point to that database table. This way, I only have 1 report, rather than 9.

Is this possible? I can't imagine it isn't!

I've got the HitchHicker's Guide, and if it's in there, I'm totally overlooking it!

Thanks!

 

[TheBlondOne]

Hi there,

Did you get anywhere with this?

If not one thing that might be possible (say might because i'm not too sure) is to make a stored procedure to enable you to select databases.

I know when we were on a client site we created a stored procedure which when run with parameter values, populated different tables with date, For example, if you ran the stored procedure for Inspector, only the inspector tables were populated, if we used learndirect, only the learndirect tables were populated.

It might be a long shot but it might be worth investigating this option, as if you can populate different tables with a param then maybe you can select different databases.

Its a long shot but its probably worth looking at.

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[lanm]

TheBlondOne!

Love that quote 'bout skydiving!

Nah, nothin' yet. I've been swamped with other stuff. I'll try that and let you know.

Thanks!

 

[TheBlondOne]

Thanks Ianm, let me know how it goes when you've had a look.

Have fun

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )