| Groups | Blog | Home |
sql server reporting services : need help in reporting services
i have a report in which data is populated using 6 Stored Procedures, now the problem is before i execute these stored procedures i need to execute one more stored procedure which fills in the data in the table to which the 6 SP's refer to. is there any way to mention the order in which the SP's are executed.. i tried to put every thing in a single stored procedure and create single table which has all the fields contained in the 6 SP's and fill it up.. but i get some null values in some of the fields.. when i retrieve the values in the report i get few empty rows.. is there any way to filter out these empty rows.. i suppose these empty rows are nothing but null values in the database table.. i desperately need help in this matter.. if any further details are required.. i will be grateful to provide you the information.. thanking u ADITYA
One thing that works today (undocumented and could change in future
versions) is that the datasets are created in the order in the RDL file. You could open up the rdl file in an editor and make sure the first dataset you need is the very first one. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Adi" <gvar369@gmail.com> wrote in message news:1170808057.132856.268780@h3g2000cwc.googlegroups.com... > hi all > i have a report in which data is populated using 6 Stored Procedures, > now the problem is before i execute these stored procedures i need to > execute one more stored procedure which fills in the data in the table > to which the 6 SP's refer to. is there any way to mention the order in > which the SP's are executed.. > i tried to put every thing in a single stored procedure and create > single table which has all the fields contained in the 6 SP's and > fill it up.. but i get some null values in some of the fields.. when i > retrieve the values in the report i get few empty rows.. > is there any way to filter out these empty rows.. i suppose these > empty rows are nothing but null values in the database table.. i > desperately need help in this matter.. if any further details are > required.. i will be grateful to provide you the information.. > thanking u > ADITYA >
hey Bruce thanks for the reply.. i tried it but i don't understand why
i don't get any data from the SP's now.. when i click on view report it throws out an error stating.. query execution failed for data set 'account'. invalid object name 'tmpmain'.. so i created a the table which is stated as the object name.. but all in vain.. i still don't have any data in the report.. when i check the table 'tmpmain', it has data in it.. the data set 'account' mentioned above which failed was supposed to execute its SP after another SP 'tmp_final' which fills up the tmpmain table. i have a question here.. do reporting service try to execute the data sets parallely or is it done one after the other.. the reason i am asking is.. the SP tmp_final usually takes a min or 2 to execute.. but i get the above mentioned error immediately after i click on view report... Aditya On Feb 6, 9:12 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com> [quoted text, click to view] wrote: > One thing that works today (undocumented and could change in future > versions) is that the datasets are created in the order in the RDL file. You > could open up the rdl file in an editor and make sure the first dataset you > need is the very first one. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Adi" <gvar...@gmail.com> wrote in message > > news:1170808057.132856.268780@h3g2000cwc.googlegroups.com... > > > hi all > > i have a report in which data is populated using 6 Stored Procedures, > > now the problem is before i execute these stored procedures i need to > > execute one more stored procedure which fills in the data in the table > > to which the 6 SP's refer to. is there any way to mention the order in > > which the SP's are executed.. > > i tried to put every thing in a single stored procedure and create > > single table which has all the fields contained in the 6 SP's and > > fill it up.. but i get some null values in some of the fields.. when i > > retrieve the values in the report i get few empty rows.. > > is there any way to filter out these empty rows.. i suppose these > > empty rows are nothing but null values in the database table.. i > > desperately need help in this matter.. if any further details are > > required.. i will be grateful to provide you the information.. > > thanking u > > ADITYA
You could have more than one thing going on here. RS gets field
configuration. In your SPs put in this statement: set FMTONLY OFF Did you check the rdl, is it in the order that you want? I don't think it goes parallel. I think it executes one after another. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Adi" <gvar369@gmail.com> wrote in message news:1170887222.515054.225220@v45g2000cwv.googlegroups.com... > hey Bruce thanks for the reply.. i tried it but i don't understand why > i don't get any data from the SP's now.. when i click on view report > it throws out an error stating.. query execution failed for data set > 'account'. invalid object name 'tmpmain'.. so i created a the table > which is stated as the object name.. but all in vain.. i still don't > have any data in the report.. when i check the table 'tmpmain', it has > data in it.. the data set 'account' mentioned above which failed was > supposed to execute its SP after another SP 'tmp_final' which fills up > the tmpmain table. i have a question here.. do reporting service try > to execute the data sets parallely or is it done one after the > other.. the reason i am asking is.. the SP tmp_final usually takes a > min or 2 to execute.. but i get the above mentioned error immediately > after i click on view report... > Aditya > > On Feb 6, 9:12 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com> > wrote: >> One thing that works today (undocumented and could change in future >> versions) is that the datasets are created in the order in the RDL file. >> You >> could open up the rdl file in an editor and make sure the first dataset >> you >> need is the very first one. >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Adi" <gvar...@gmail.com> wrote in message >> >> news:1170808057.132856.268780@h3g2000cwc.googlegroups.com... >> >> > hi all >> > i have a report in which data is populated using 6 Stored Procedures, >> > now the problem is before i execute these stored procedures i need to >> > execute one more stored procedure which fills in the data in the table >> > to which the 6 SP's refer to. is there any way to mention the order in >> > which the SP's are executed.. >> > i tried to put every thing in a single stored procedure and create >> > single table which has all the fields contained in the 6 SP's and >> > fill it up.. but i get some null values in some of the fields.. when i >> > retrieve the values in the report i get few empty rows.. >> > is there any way to filter out these empty rows.. i suppose these >> > empty rows are nothing but null values in the database table.. i >> > desperately need help in this matter.. if any further details are >> > required.. i will be grateful to provide you the information.. >> > thanking u >> > ADITYA > >
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 |