Viewing 15 posts - 166 through 180 (of 200 total)
Is it perhaps not passing the Invoice PK to the subreport? In the main report, right click on the cell/textbox that contains the subreport and go to Properties. ...
March 13, 2014 at 4:42 pm
Would something like this work?
=IIF(Fields!Employee.Value Is Nothing, "0", SUM(IIF(Fields!Employee.Value = "FullTime",1,0),"Production") ) --- This will give the sum of Fulltime employees
=IIF(Fields!Employee.Value Is Nothing, "0", SUM(IIF(Fields!Employee.Value = "Partime",1,0),"Production") )---- This will...
March 13, 2014 at 4:19 pm
One-at-a-time is the only way I know how to change data sources. AKAIK you can only multiselect reports to either delete or move them.
February 28, 2014 at 12:04 pm
You might be able to condense a couple of steps by changing the subscription to Windows File Share output instead of email. You can specify the folder you're currently...
February 27, 2014 at 12:35 pm
You can start with taking out the TOP 1's and see where that gets you. You might still have some restructuring to do, though. I would try to...
February 26, 2014 at 3:03 pm
IN SSRS, go to the Data Source definition for the data source the report is using. In Properties, select the "Credentials stored securely in the report server" radio button,...
February 26, 2014 at 12:58 pm
Do you think it could have something to do with the 18 "SELECT TOP (1)" statements? 🙂 The function of a "SELECT TOP (1)" is to return only...
February 26, 2014 at 12:52 pm
The "the credentials used to run the report are not stored" is referring to the dataset used to run the reports. Since it is set to Windows Integrated Security,...
February 25, 2014 at 11:56 am
It may be that you haven't defined MDEP within the select - it's having to call all the way up to the UPDATE statement to find it, and that's outside...
February 25, 2014 at 10:44 am
Here is an article on dataset execution order that may trigger some ideas:
http://blogs.msdn.com/b/robertbruckner/archive/2008/08/07/dataset-execution-order.aspx
February 20, 2014 at 5:43 pm
AFAIK, the interface is not configurable in terms of adding new columns. You could enter "Details" into the Description (in Properties/General tab) of any details reports, as the Description column...
February 19, 2014 at 3:29 pm
I don't see how the * value behaves differently from NULL; it seems extraneous. Either a calculated value equals @Device, or there was no numeric @Device value entered.
(Cast(DeviceType as...
February 13, 2014 at 12:35 pm
Nice analysis, Grant! While this hypothetical assumes the order of the WHENs don't have any logical significance, it should be emphasized for any folks new to CASE statements that...
February 13, 2014 at 10:20 am
That looks right to me. You might not need the space between the quotes for the blank:
=IIF(Fields!PreviousAddress.value = fields!CurrentAddress.value,"",Fields!PreviousAddress.Value)
February 12, 2014 at 3:18 pm
What choice of parameters would result in Null values being included in the results? Should they be included no mater what state(s) the user selects, or only if the...
February 11, 2014 at 3:24 pm
Viewing 15 posts - 166 through 180 (of 200 total)