report builder ad hoc reporting

Using SS2000 data with RS2005. If I build a report with report builder, is
there a way to see what query the report builder is using to generate the
report? I've built a model and created a report from the model. If I create a
query in query analyzer to check the results that are generated by the report
builder report, I'm off by quite a bit. If I could see the query that the
report builder is generating maybe I could figure out where the problem is.
Thanks,
--
Dan D.Take a look at the RDL file. You can either save this file to disk using the
Report Builder File : Save To File menu option.
"Dan D." wrote:
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I create a
> query in query analyzer to check the results that are generated by the report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem is.
> Thanks,
> --
> Dan D.|||I tried that. I searched for the word 'query' and the only thing I saw was a
section that had the column names. Do you think the query itself is in there?
Thanks,
--
Dan D.
"Bruce Johnson [MSFT]" wrote:
> Take a look at the RDL file. You can either save this file to disk using the
> Report Builder File : Save To File menu option.
>
> "Dan D." wrote:
> > Using SS2000 data with RS2005. If I build a report with report builder, is
> > there a way to see what query the report builder is using to generate the
> > report? I've built a model and created a report from the model. If I create a
> > query in query analyzer to check the results that are generated by the report
> > builder report, I'm off by quite a bit. If I could see the query that the
> > report builder is generating maybe I could figure out where the problem is.
> >
> > Thanks,
> > --
> > Dan D.|||use the profiler to see the query executed by report builder against your
database.
Also report builder can log the query:
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
good luck.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E2DDBECB-7F70-486D-9555-EA2112810DCA@.microsoft.com...
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I
> create a
> query in query analyzer to check the results that are generated by the
> report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem
> is.
> Thanks,
> --
> Dan D.|||infact the complex query is already in the report model. you will get just
the simple query of all the columns and the filter condition. You can have a
look at the report model table as well.
Amarnath
"Dan D." wrote:
> Using SS2000 data with RS2005. If I build a report with report builder, is
> there a way to see what query the report builder is using to generate the
> report? I've built a model and created a report from the model. If I create a
> query in query analyzer to check the results that are generated by the report
> builder report, I'm off by quite a bit. If I could see the query that the
> report builder is generating maybe I could figure out where the problem is.
> Thanks,
> --
> Dan D.|||Will this work for Oracle as well. We have installed SP2, so are not
using linked tables - going against Oracle directly.
- Steve
Jeje wrote:
> use the profiler to see the query executed by report builder against your
> database.
> Also report builder can log the query:
> http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
> good luck.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E2DDBECB-7F70-486D-9555-EA2112810DCA@.microsoft.com...
> > Using SS2000 data with RS2005. If I build a report with report builder, is
> > there a way to see what query the report builder is using to generate the
> > report? I've built a model and created a report from the model. If I
> > create a
> > query in query analyzer to check the results that are generated by the
> > report
> > builder report, I'm off by quite a bit. If I could see the query that the
> > report builder is generating maybe I could figure out where the problem
> > is.
> >
> > Thanks,
> > --
> > Dan D.