Viewing 15 posts - 61 through 75 (of 1,345 total)
You can use the matrix, but you need to have the dataset modified.
Add a depenantNum colum and using the rank, or rownumber function number the dependants from 1 to n
and...
December 19, 2012 at 6:32 am
Sri8143 (12/16/2012)
I have region when i drill down i should get state...
December 17, 2012 at 9:00 am
karna5999 (12/17/2012)
SSIS TASK Help:
Good day. I am new to SQL. I have a task to do. Hope you can help me on this. I need to retrieve the data...
December 17, 2012 at 8:51 am
I think you need to figure out a way to create a row Group as a child to employee name of the MddD field.
December 14, 2012 at 1:22 pm
Do you mean you need to figure out the percentages?
%Fail
SUM(iif(Fields!Test.value="Fail", 1, 0)) / Count(Fields!Test.value)
%Pass
SUM(iif(Fields!Test.value="Pass", 1, 0)) / Count(Fields!Test.value)
Fail/Pass
iif(SUM(iif(Fields!Test.value="Pass", 1, 0)) <> 0, SUM(iif(Fields!Test.value="Fail", 1, 0)) / SUM(iif(Fields!Test.value="Pass", 1, 0)), 0)
December 14, 2012 at 1:17 pm
I think its cuz your missing days, Notice, no 7/4
December 14, 2012 at 8:46 am
The Report viewer has a search function built in. In the bar with the export icon and such there's a search textbox and link that works for this.
Happy to help
December 13, 2012 at 1:57 pm
Either use code, or somehow combine your 2 data sets, or create a 3rd
December 12, 2012 at 2:05 pm
The things your 2 matrices have in common would be the date right?
and you just want to aggregate the totals together?
Give this a try, its basically the only way that...
December 12, 2012 at 11:42 am
None of this is possible out of the box SSRS.
If you want available dates you can use a query and populate the parameter, however it changes the control to a...
December 12, 2012 at 11:01 am
You should be able to get it out using xml data type methods.
December 11, 2012 at 8:54 am
I think all you need to do is add a space between your date and time.
(DT_DBTIMESTAMP)(SUBSTRING(EVENT_D,7,4) + "-" + SUBSTRING(EVENT_D,4,2) + "-" + SUBSTRING(EVENT_D,1,2) + " " + EVENT_T)
December 10, 2012 at 8:23 am
How is the data source configured to connect to the data source?
If Windows Integrated security, and the DB Server is on a different machine, You may be getting the Double...
December 7, 2012 at 11:00 am
My First question would be what have you tried, and where are you getting stuck.
I gave you your first Clue.
I suspect your next issue will be that since its DD/MM/YYYY...
December 7, 2012 at 10:45 am
Please read this.
http://qa.sqlservercentral.com/articles/Best+Practices/61537/[/url]
Here is a query that will make THIS specific example work.
It rely's on your Key column to be ordered correctly.
If the order of your keys is guaranteed...
December 6, 2012 at 9:06 am
Viewing 15 posts - 61 through 75 (of 1,345 total)