| Groups | Blog | Home |
sql server reporting services : How to tell reporting services not to change my query
"beautifier" ? The particular query I am working on right now gets so re-written that it is much more dificult to read and understand. I would like it to be left the way I enter it. Is it possible, or Microsoft knows best? thanks
But it dosen't work if I use vb.net codes like "Paramtere!param1.Value"
,,right? Thanks [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:O05ueipJFHA.4056@TK2MSFTNGP14.phx.gbl... > Go to the generic query window (hover over the buttons to the left of the > ... to find the right button). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "RayAll" <RayAll@microsft.com> wrote in message > news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... >> can someone tell me if it is possible to turn off Reporting Services >> query "beautifier" ? The particular query I am working on right now gets >> so re-written that it is much more dificult to read and understand. I >> would like it to be left the way I enter it. Is it possible, or Microsoft >> knows best? >> >> thanks >> >> > >
What's the disadvantge of using direct queries in my report rather than just
calling an storedprocedure. Thanks [quoted text, click to view] "RayAll" <RayAll@microsft.com> wrote in message news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... > can someone tell me if it is possible to turn off Reporting Services query > "beautifier" ? The particular query I am working on right now gets so > re-written that it is much more dificult to read and understand. I would > like it to be left the way I enter it. Is it possible, or Microsoft knows > best? > > thanks > >
Thanks for your help.
I got you , so RS mapps @Param to Paramters!paramter1.value ,,right? Thanks [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:e9JN6AqJFHA.2956@TK2MSFTNGP12.phx.gbl... > You can still use query parameters in your query. Be sure you understand > the difference between query parameters and report parameters. RS creates > the report parameter automatically for you (most of the time, in the > generic query design that sometimes is not the case). So you can still do > this in the generic query designer: > > select a.somefield, b.someother field from table1 a inner join table2 b on > a.joiningfield = b.joiningfield where a.anotherfield = @Param > > Note that @Param will cause RS to create a report parameter called Param. > > You can also go against stored procedures. I do both all the time. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "RayAll" <RayAll@microsft.com> wrote in message > news:uGPCrlpJFHA.3132@TK2MSFTNGP12.phx.gbl... >> But it dosen't work if I use vb.net codes like "Paramtere!param1.Value" >> ,,right? >> >> Thanks >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> news:O05ueipJFHA.4056@TK2MSFTNGP14.phx.gbl... >>> Go to the generic query window (hover over the buttons to the left of >>> the ... to find the right button). >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> "RayAll" <RayAll@microsft.com> wrote in message >>> news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... >>>> can someone tell me if it is possible to turn off Reporting Services >>>> query "beautifier" ? The particular query I am working on right now >>>> gets so re-written that it is much more dificult to read and >>>> understand. I would like it to be left the way I enter it. Is it >>>> possible, or Microsoft knows best? >>>> >>>> thanks >>>> >>>> >>> >>> >> >> > >
Go to the generic query window (hover over the buttons to the left of the
.... to find the right button). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "RayAll" <RayAll@microsft.com> wrote in message news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... > can someone tell me if it is possible to turn off Reporting Services query > "beautifier" ? The particular query I am working on right now gets so > re-written that it is much more dificult to read and understand. I would > like it to be left the way I enter it. Is it possible, or Microsoft knows > best? > > thanks > >
You can still use query parameters in your query. Be sure you understand the
difference between query parameters and report parameters. RS creates the report parameter automatically for you (most of the time, in the generic query design that sometimes is not the case). So you can still do this in the generic query designer: select a.somefield, b.someother field from table1 a inner join table2 b on a.joiningfield = b.joiningfield where a.anotherfield = @Param Note that @Param will cause RS to create a report parameter called Param. You can also go against stored procedures. I do both all the time. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "RayAll" <RayAll@microsft.com> wrote in message news:uGPCrlpJFHA.3132@TK2MSFTNGP12.phx.gbl... > But it dosen't work if I use vb.net codes like "Paramtere!param1.Value" > ,,right? > > Thanks > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:O05ueipJFHA.4056@TK2MSFTNGP14.phx.gbl... >> Go to the generic query window (hover over the buttons to the left of the >> ... to find the right button). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "RayAll" <RayAll@microsft.com> wrote in message >> news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... >>> can someone tell me if it is possible to turn off Reporting Services >>> query "beautifier" ? The particular query I am working on right now gets >>> so re-written that it is much more dificult to read and understand. I >>> would like it to be left the way I enter it. Is it possible, or >>> Microsoft knows best? >>> >>> thanks >>> >>> >> >> > >
If RS creates the report parameter it will be whatever you name the query
parameter, case sensitive. If you are going against ODBC data source then it is unnamed ( you use a ? as the placeholder) and RS creates the report parameter as Parameter1, Parameter2. If named (SQL Server) then if you named it @SomethingSpecial then the report parameter would be SomethingSpecial and the mapping is to Parameters!SomethingSpecial.Value Play with it some and it will make sense. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "RayAll" <RayAll@microsft.com> wrote in message news:Ovyq$eqJFHA.3340@TK2MSFTNGP14.phx.gbl... > Thanks for your help. > > I got you , so RS mapps @Param to Paramters!paramter1.value ,,right? > > Thanks > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:e9JN6AqJFHA.2956@TK2MSFTNGP12.phx.gbl... >> You can still use query parameters in your query. Be sure you understand >> the difference between query parameters and report parameters. RS creates >> the report parameter automatically for you (most of the time, in the >> generic query design that sometimes is not the case). So you can still do >> this in the generic query designer: >> >> select a.somefield, b.someother field from table1 a inner join table2 b >> on a.joiningfield = b.joiningfield where a.anotherfield = @Param >> >> Note that @Param will cause RS to create a report parameter called Param. >> >> You can also go against stored procedures. I do both all the time. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "RayAll" <RayAll@microsft.com> wrote in message >> news:uGPCrlpJFHA.3132@TK2MSFTNGP12.phx.gbl... >>> But it dosen't work if I use vb.net codes like "Paramtere!param1.Value" >>> ,,right? >>> >>> Thanks >>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >>> news:O05ueipJFHA.4056@TK2MSFTNGP14.phx.gbl... >>>> Go to the generic query window (hover over the buttons to the left of >>>> the ... to find the right button). >>>> >>>> >>>> -- >>>> Bruce Loehle-Conger >>>> MVP SQL Server Reporting Services >>>> >>>> "RayAll" <RayAll@microsft.com> wrote in message >>>> news:ewB3lBpJFHA.4092@tk2msftngp13.phx.gbl... >>>>> can someone tell me if it is possible to turn off Reporting Services >>>>> query "beautifier" ? The particular query I am working on right now >>>>> gets so re-written that it is much more dificult to read and >>>>> understand. I would like it to be left the way I enter it. Is it >>>>> possible, or Microsoft knows best? >>>>> >>>>> thanks >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |