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 |
|
tikus
Starting Member
31 Posts |
 Posted - 2005-01-04 : 17:30:47
|
| Hello, can we have Global Variable in the report? If so, how do I do it? Thanks a lot!! |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-04 : 21:40:45
|
quote:
Originally posted by tikus
Hello, can we have Global Variable in the report? If so, how do I do it? Thanks a lot!!
Hello,The only globals you will find in RS is in the field properties panel under "Globals" there you will find the following:ExecutionTimePageNumberTotalPagesReportNameetc...To reference it simply do the following:="Page " & Globals!PageNumber & " of " & Globals!TotalPagesAs far as defining your own RS is not like access, there are no event handlers, the only real code is the xml.JonA new beat on the web -- http://www.web-impulse.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-05 : 12:23:58
|
| I suppose you could create a calculated field and hard code it with a value.Tara |
|
|
|
tikus
Starting Member
31 Posts |
Posted - 2005-01-06 : 16:07:19
|
| thanks a lot! |
|
|
|
|
|
|
How to create a Global Variable?