Running a Saved Query Behind the Scenes

[AjarnMark]

I have used SQL Reporting Services to build a few custom reports for my company, issuing SQL SELECTs directly against the databases. Now I have a scenario where the report that we want to build is based on a saved query that is already defined in Fortress. Is there an easy way that I could call for the execution of a Saved Query directly in SQL?

[lbauer]

Is this a History query or a query in Item tracking?

[AjarnMark]

Item Tracking.

[lbauer]

There is no easy way to do this. You might be able to run the query in Fortress, then capture the query structure in SQL Profiler. Contact me off-line at support at sourcegear.com, Attn: Linda for more details. Please include a link to this forum post.

[AjarnMark]

Yes, I have done a little profiling already and hoped that there was something simpler that I was missing.

Ah well, thanks anyway.