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 |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2013-06-04 : 10:15:59
|
| Hi,I have report ,table in the report have column :avr evolutionn1 1?n2 2?2?=(n2-n1)\n1*100%haw i can do it this in the report(querry)Thanks a lot |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-04 : 13:09:31
|
| =(ReportItems!n2textboxname.value-ReportItems!n1textboxname.value)/IIF(ReportItems!n1textboxname.value>0,ReportItems!n1textboxname.value,Nothing)and make format to % in textbox properties------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2013-06-05 : 10:21:58
|
| sorry ,i have not table ,i have matrix,what I can do? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-05 : 13:54:08
|
quote:
Originally posted by nord
sorry ,i have not table ,i have matrix,what I can do?
thats not a problem so far as all the textboxes are inside the same container.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
how i can write this in the report?