Viewing 15 posts - 46 through 60 (of 1,345 total)
In the Derived column transformation you add 3 rows.
and the expression for DRU would be a very simple one.
Cost == "DRU" ? Values : NULL(DT_I4)
Of course repeat the process for...
April 3, 2013 at 3:07 pm
You need to place a derived column transformation between your source and your Destination Containers.
Here is a tutorial on how to use the derived column transformation
April 3, 2013 at 1:42 pm
Yes, but how you get that info depends.
When creating your data sources in these reports did you use Embedded SQL? or Stored Procedures.
If you used only stored procedures simply query...
April 3, 2013 at 10:05 am
One thing off the top of my head. The Join function will create a string of selected values.
Put this in each sub report definition.
=iif(Join(Parameters!ReportParameter1.Label,",").Contains("Occupancy"),False,True)
One thing to note.
All Sub reports will...
March 31, 2013 at 10:26 am
What do you mean perform queries?
What are you trying to do?
You can Load the data into a Table in the database, make changes query, etc.
Then you can copy the data...
March 30, 2013 at 12:54 pm
Sounds like you need a history table.
Check this out
http://database-programmer.blogspot.com/2008/07/history-tables.html
March 30, 2013 at 12:47 pm
RDL's are just xml files.
For example this will get you the data sets information used in your report. You can use this to insert into a table, or copy paste...
March 27, 2013 at 11:32 am
Place a rectangle at the bottom of your report template.
on the rectangle properties dialog Select the "Add Page Break Before" checkbox. (Or set the PageBreak Breaklocation Property to Start).
Place textboxes...
March 27, 2013 at 11:00 am
Pretty sure you cannot do this using XML Auto.
Try Using XML Path
Here's an example using Path from AdventureWorks
SELECT
h.SalesOrderID,
h.OrderDate,
...
March 27, 2013 at 10:21 am
This may help you.
http://www.sqlis.com/sqlis/post/Logical-OR-in-Control-Flow-to-Skip-Task.aspx
There are several other articles that can help you there.
February 15, 2013 at 1:42 pm
Using the Rank function would be very helpfull for this., possibly a cte.
;WITH Salaries AS (SELECT
EmpID,
EmpLastName,
EmpFirstName,
Salary
RANK() OVER (PARTITION BY EmpID, ORDER BY Salary))
FROM dbo.Employee)AS SalaryRank
SELECT *
FROM Salaries
WHERE (SalaryRank...
January 28, 2013 at 1:37 pm
Change the UseValueAsLabel to false.
Here's an example of an expression I just wrote to test this out.
If Revenue for Department / TotalRevenue > .1, then show Department revenue, else ""...
December 20, 2012 at 3:19 pm
I still don't understand your question.
The date in the database is a Decimal, and stores dates in YYYYMMDD format?
and you want to create a parameter TO and Parameter FROM that...
December 20, 2012 at 9:41 am
The answer is almost always "Depends"
Here's a good read.
http://www.sqlskills.com/blogs/kimberly/post/the-clustered-index-debate-continues.aspx
December 20, 2012 at 9:38 am
Viewing 15 posts - 46 through 60 (of 1,345 total)