Fields in charting - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Fields in charting

Author

Topic

yoggi123
Starting Member

29 Posts

Posted - 2005-01-14 : 10:40:22

Hi,

I am working on some charts and I am using the following code:

CREATE TABLE #Temp1 (themonth varchar(12), theyear varchar(12), averagedaystofilltotal float, averagefillratetotal float,
delaytimetotal float, responsetimelagtotal float)

INSERT INTO #Temp1(themonth, theyear, averagedaystofilltotal, averagefillratetotal, delaytimetotal, responsetimelagtotal)
EXEC rptStatsGraphicalYEARoverYear @Location, @FromDate, @ToDate

Create table #Temp2(averagedaystofilltarget float, averagefillratetarget float, responsetimelagtarget float)
INSERT INTO #Temp2(averagedaystofilltarget, averagefillratetarget, responsetimelagtarget)
EXEC Test1

SELECT * FROM #Temp1
Select * from #Temp2

drop table #Temp1
drop table #Temp2

How can I make it so that the fields for using in the chart correspond to both select statements? Right now I am either getting the fields from the first select statement or the second but not both, how can I make this work?

Thanks

jhermiz

3564 Posts

Posted - 2005-01-14 : 10:59:25

RS supports one dataset, so you will have to write a procedure or view to merge the two together.
This question is asked way too many times and the answer is you cant!

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources