Viewing 15 posts - 1 through 15 (of 96 total)
I am so sorry for your loss. You wrote such a nice tribute to Tom. This is such a caring community that I am grateful to be a part of.
January 31, 2018 at 8:19 am
Thank you Sue for the insight. I understand that data mods for Reporting Services are not recommended, but we needed to disable users for compliance reasons. I had created a...
January 10, 2018 at 11:23 am
You have to put an expression on the text box. Go to Text Box properties, Visiblity, click on the fx button to the right of Show or hide based on...
January 5, 2018 at 1:21 pm
January 5, 2018 at 1:04 pm
I have a feeling that it doesn't like the subquery. Maybe this would work?
SET
January 5, 2018 at 12:57 pm
Thanks for the article! It is good info to see the capability of SSIS. It is ok not to have specific info. I understand the point now...
December 15, 2016 at 8:27 am
I have a question about this. We have fields with the data type of NVARCHAR because there are special characters in them.
If you are converting them to...
December 15, 2016 at 8:03 am
I read that on average, it takes adults 32 times of doing anything to make it a habit!!
I need a combination of things to learn best, but I remember most...
September 23, 2016 at 8:37 am
I would try this one:
IIF((Parameters!GP.Value = "A480" or Parameters!GP.Value = "A485") and (Fields!FA_ACCT.Value = 170 or Fields!FA_ACCT.Value = 171 or Fields!FA_ACCT.Value = 200 or Fields!FA_ACCT.Value = 380), 1,
IIF((Parameters!GP.Value <>...
October 16, 2015 at 12:23 pm
Reports created with report builder have a model as a data source. The query I posted lists all the models and their associated reports.
You can use that...
October 1, 2015 at 9:12 am
the report Server database in the Catalog table has a Type field.
Here is what that means:
1 = folder
2 = report (both rdl and report builder)
3 = file (Word, Excel, PDF,...
September 30, 2015 at 2:57 pm
Sorry, I missed the requirement to be distinct.
Are you able to use the CountDistinct function?
Here is the syntax: CountDistinct(expression, scope, recursive) --Recursive parameter is optional
I think this is how the...
September 28, 2015 at 8:56 am
Do you have grouping? If you put an expression in the group footer, and set the visibility for that row the same as the row that expands, it should show...
September 28, 2015 at 8:15 am
david5515 (9/23/2015)
I am currently trying to puzzle out how to count all of the distinct instances of yes and no from a lookup I have done.
The lookup is =IIF(Lookup(Fields!Supplier_Code.Value,Fields!Supplier_Code.Value,Fields!First_Name.Value,"DataSet2")="","No","Yes")
However...
September 28, 2015 at 7:58 am
patrickmcginnis59 10839 (7/17/2015)
There was this one company that had hawaiian shirt days. Ultimately though the company headquarters burnt to the ground.
If they move my desk one more time, I am...
July 17, 2015 at 8:21 am
Viewing 15 posts - 1 through 15 (of 96 total)