Hi There

In others words, when field1 >=300 returns a result of over 300, the field box should flag red,

when (tableA field2 <> tableB Field2) is met, the field box...

If I was creating the report I would do exactly what you are doing, I would create separate datasets for each distinct query. As you say, if you try...

I think your question is a little too general, creating a dashboard report depends on the content of the report.

What do you want to show on the report?

How many...

I've never found a way to do this, when I've need this feature I have always created two parameters, one for the drop down and one for the input value...

Probably what you are getting is different groups for the same day simply because transactions are occuring at different times during that day.

I assume you have a group expression based...

I'm using SQL2005 with Excel 2007 and the standard export feature to Excel works perfectly, can't imagine SQL2008 would have any problem there. What problems do you have?

OK, so I suspect that it is the expression, in particular the part that reads "CancelledBy" which identifies the scope of the function. This should represent the group name...

Hi B-Boy

Jack is correct, he has given you the correct expression to use and I suspect with his experience that he has given you a fully working report based on...

Two ways to do it.

1. If you're table in the report has no grouping and no sorting:

Place an ORDER BY clause on your SQL Statement that returns data in...

I need to filter table based on the clicked value in matrix. i.e user should click KOB type in matrix and Table will be visible with only matching KOB type...

Hi

The way I overcome this problem is to put a default value of % in each of the optional parameters and to train the end users that this value is...

Sorry, struggling now, will have a think about it and maybe put an example together to see if I can reproduce it.

OK, so now I think I am clear on what you are trying to do, and I assume that the supplier drop down parameter is used in your final dataset...

Hi Friends, I am facing the problem in setting the parameter. I have one parameter name INSerPackopt here i am passing the comparing operator(=,null,like). I have one more parameter...

Can you tell me if this is a standard SSRS Parameter, it appears when you use the word TextBox that you have somehow created an input box on the report...