Monday, March 12, 2012

Getting query associated with a dataset

Is it possible to get the post-processed query that is associated with a
dataset?
I need to see the SQL or MDX query that is produced *after* the IIF(), Code,
Parameters, etc. have been evaluated.
For example, immediatley after I create the report (via CreateSubscription)
I would like to see the database query that it will use for the report.
Thanks,
BillNot sure if this is what you are looking for, but in RS 2000 you could just
add a textbox in the report which contains exactly the same expression as
the dataset query. Running the report shows you the expression evaluation
result.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"billd" <billd@.discussions.microsoft.com> wrote in message
news:1BCDF646-E322-4F8F-AB86-28AD812A090A@.microsoft.com...
> Is it possible to get the post-processed query that is associated with a
> dataset?
> I need to see the SQL or MDX query that is produced *after* the IIF(),
Code,
> Parameters, etc. have been evaluated.
> For example, immediatley after I create the report (via
CreateSubscription)
> I would like to see the database query that it will use for the report.
> Thanks,
> Bill
>
>|||I also would be interested in seeing this. When I write ASP code, I usually
allow flags to be passed to the web page which forces queries and other
logging into to be output as comments in the web page. This really helps
the debugging process.
And right now I'm having terrible problems connecting to and querying an
AS400 data source, and this info would be very useful.
Daniel Williams
"billd" <billd@.discussions.microsoft.com> wrote in message
news:1BCDF646-E322-4F8F-AB86-28AD812A090A@.microsoft.com...
> Is it possible to get the post-processed query that is associated with a
> dataset?
> I need to see the SQL or MDX query that is produced *after* the IIF(),
> Code,
> Parameters, etc. have been evaluated.
> For example, immediatley after I create the report (via
> CreateSubscription)
> I would like to see the database query that it will use for the report.
> Thanks,
> Bill
>
>|||Thanks. Clever idea.
What do you think the best way would be to get te contents of the textbox
back to the calling application? (I use the Render API call now to display
the report).
If I set the the textbox to "hidden" I do not get the textbox in the
returned HTML fragment.
Bill
"Robert Bruckner [MSFT]" wrote:
> Not sure if this is what you are looking for, but in RS 2000 you could just
> add a textbox in the report which contains exactly the same expression as
> the dataset query. Running the report shows you the expression evaluation
> result.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "billd" <billd@.discussions.microsoft.com> wrote in message
> news:1BCDF646-E322-4F8F-AB86-28AD812A090A@.microsoft.com...
> > Is it possible to get the post-processed query that is associated with a
> > dataset?
> >
> > I need to see the SQL or MDX query that is produced *after* the IIF(),
> Code,
> > Parameters, etc. have been evaluated.
> >
> > For example, immediatley after I create the report (via
> CreateSubscription)
> > I would like to see the database query that it will use for the report.
> >
> > Thanks,
> > Bill
> >
> >
> >
>
>

No comments:

Post a Comment