Menu
I understand Crystal Reports has fallen out of favor with some in the development community and perhaps rightly so: I haven't used it in about 15 years. But when I did, I could make it sing.
Perhaps that is why I find SSRS so disappointing. The software is clumsy, non-intuitive and one-dimensional. I have been fighting it for the last week and I am posting here as a last resort.
I have been forced to create my report entirely in a SQL Server table and I shouldn't have to do that.
For example: why can't I use the expression in a textbox;
Fields!Foo1.Value/Fields.Foo2.Value
where Foo1 is in Dataset1 and Foo2 is in Dataset2.
If this is beyond the capability of the software, that's OK. I beginning to think it is.
So maybe someone can answer this question: Does anyone know of any other reporting software besides Crystal Reports and Reporting Services that is more versatile?
618
You can't use a single SSRS result set to call a proc that returns multiple result sets and access it as a collection of result sets the way you can in . net. Once you have your multiple result sets created, you can create multiple tablix on your report, and designate in each one which result set it uses for its data.
Row groups and column groups You can organize data into groups by rows or columns. Row groups expand vertically on a page. Column groups expand horizontally on a page. Groups can be nested, for example, group first by [Year], then by [Quarter], then by [Month].
I think your would have been resolved by now, however if u r facing same issue then you can use lookup in expression.
It enable you to browse through values of other dataset while there is a common field in both the datasets
=Lookup(value in dataset1,value in dataset2, common field in both datasets, dataset name from which we need to get data)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
