Viewing 15 posts - 91 through 105 (of 454 total)
If you have visibility Hidden = True for the row then definitely will not show up. As David mentioned make sure you are selected the row that you want to...
October 12, 2007 at 10:42 am
On the Data Tab of your report go to the properties of your dataset, parameters tab and have the value set to @MultiParamList= Parameters!MultiParamList.Value and since you have already defined...
October 12, 2007 at 10:36 am
If you have date column that audits the insert time, then you can use this column to validate the records that are inserted after your previous job execution time and...
October 12, 2007 at 9:51 am
It does make sense if you are using the processing to calculate the values that you already have handy and if the second sp uses these values for further processing,...
October 12, 2007 at 9:47 am
If you want to display something like >= 20/09/2007 on your report you need to have the expression as =">= 20/09/2007"
October 12, 2007 at 7:49 am
Sorry, but can you be more clear on your question as to what is your exact requirement.
October 12, 2007 at 7:43 am
Yes, probably you can have header text as a parameter driven display. If you are calling it from a different report pass the header text and if it is called...
October 12, 2007 at 7:41 am
The scope of the temp table is local to the stored procedure and it will not create any multi-user conflicts if the same procedure is accessed by mutlitple users at...
October 12, 2007 at 7:07 am
Please find a very good article on Reporting Services Installation and configuration at http://www.informit.com/articles/article.aspx?p=357694&seqNum=6
October 12, 2007 at 6:53 am
It is very weird that you are prompted to login on everytime you want to open a new query. Does your Database Connection session stay alive. I mean are you...
October 12, 2007 at 6:38 am
You need to buy a SQL Server Enterprise Version License you can either go Server and CAL based licensing model or Processor based licensing model based on your requirements.
October 12, 2007 at 6:24 am
Yes, its a good suggestion you don't really need to have a cursor to build the insert script. Also if it can be modified to build the script for the...
October 12, 2007 at 4:07 am
You go to Services and go the SQL Server Instance Properties and Go to Log on tab and give the authentication setting to use a domain account. Log on to...
October 11, 2007 at 6:45 am
This is a nice article on how to create your own permanant calendar table and probably you should be able to script your stored procedure based on this.
October 11, 2007 at 6:17 am
Viewing 15 posts - 91 through 105 (of 454 total)