Viewing 15 posts - 76 through 90 (of 1,345 total)
The problem is the way you formatted your tablix
Your Header row is probably within the Group.
You can tell this by looking at the tablix and see the ( on the...
December 6, 2012 at 8:44 am
This is an easy and common problem.
In our dataflow task, you need to add the Derived column transformation connected to the Data Flow Source.
(Between your dataflow source and data flow...
December 6, 2012 at 8:39 am
Emailto just needs to be a ;Semicolon separated list of emails.
December 6, 2012 at 8:29 am
I'm a little confused by what your trying to explain but thats cuz I have ADD or something.
The SSRS charts work very much the same as excel pie charts, one...
December 5, 2012 at 9:41 am
The only thing I think you can do is compare the number of selected items to the total number of items.
iif(Parameters!pStateCounty.Count = Count(Fields!StateCounty.Value, "MyStateCountyDataSetName"),"All", Join(Parameters!pStateCounty.Label, ",")
Edit Spelling:cool:
December 5, 2012 at 9:29 am
Ok, so create the variable.
Then Configure your ftp task to get the name of the file from the variable.
Create a script task that goes out to the drive and looks...
December 4, 2012 at 9:18 am
Ya, this is a fairly common issue.
FTP Task only knows how to process 1 file, and 1 file only the *_Filename.xls your trying won't work.
You need to create a variable...
December 3, 2012 at 3:12 pm
Create a variable and set the variable to evalueate as expression = True.
Create an expression that creates the file name as you require.
In the file transfer section of your ftp...
December 3, 2012 at 11:36 am
SELECT CAST(0 AS DATETIME)
Resolves to
1900-01-01 00:00:00.000
(DT_DBDATE)0
Resolves to
1899-12-30
There's your two days difference
December 3, 2012 at 8:55 am
You will be using an Expressin in SSIS which is similar to c#
however the If is implied which is confusing
Quick Link
Your expression will look something like
ISNULL( UnitCost ) || UnitCost...
November 30, 2012 at 11:26 am
SSRS only lets you create 1 PDF Per Report Execution.
So if your report returns 40,000 Pages, It will still only export 1 PDF File.
You can create a report that takes...
November 26, 2012 at 3:01 pm
Can you explain what you mean by toggle item?
Background color can be set conditionally using an expression in the backgroundcolor property
Quick Vid
http://www.dailymotion.com/video/xsxp8j_reporting-services-conditional-formatting-in-tables_tech
November 26, 2012 at 2:53 pm
No, I do not believe you can restrict the a Datetime parameter to a specific date range.
You can create a query, or a list in the Available values section of...
November 26, 2012 at 10:58 am
Execute sql tasks do not allow you to export data to a file.
As stated your running multiple queries in your execute sql task.
You can select your results and store them...
November 26, 2012 at 10:50 am
The sequence container provides a logical grouping.
If I collapse a sequence container all containers within are collapsed and I do not see any arrows.
I see arrows To other containers outside...
November 20, 2012 at 2:26 pm
Viewing 15 posts - 76 through 90 (of 1,345 total)