Using aliases - 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

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Using aliases

Author

Topic

tom2163
Starting Member

2 Posts

Posted - 2012-09-25 : 07:03:14

Hi all,
I had a problem with trying to create a report where I needed to reference the same coloumn for 2 different rows of information, as seen here http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ece9ce89-b7f9-485b-80cc-35c608aef64d/?prof=required
Now the lookup method works fine, but as I've said I think it could lead to some serious performacne issues when used in a live environment so I'm just wondering if anyone knows a way of doing it where I don't have to return all the values first and then search through them.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-25 : 12:52:34

the two fields are coming from same dataset or different datasets?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

tom2163
Starting Member

2 Posts

Posted - 2012-09-26 : 04:03:27

The same dataset

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources