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.
| Author |
Topic |
|
MukeshKumar
Starting Member
1 Post |
 Posted - 2011-08-12 : 03:33:27
|
| In my report,I have taken two different tables with two different dataset.and i want to calculate variation as(1-(fields!textbox1.value/fields!textbox1.value))*100.It gives error such as 'report item expressions can only refer to field within the current dataset scope' How can i calculate this?I am not creating any group. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-12 : 07:28:47
|
| As far as I know, SSRS does not support getting data from more than one dataset in one data region. There are workarounds, but they seem ugly (in my humble opinion, of course). Take a look at this page - they discuss the workarounds. Look for the section "Getting Data from Different Sources". |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-08-12 : 09:18:28
|
| I think the only viable solution is to merge the two data sets together in to one *before* you run the report. In other words: create one sql query out of the two... I have not managed to get this to work in any other way.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
|
|
|
Calculation in Report using sql server 2005