I\'m building a report of case results with a parent-child grouping on the row group and single column grouping:
I have a table with the following columns and data Category Item Price Tax A I1 1.00 .01 A I2 2.22 .02 B I3 3.33 0.3
How to create a sql query to return the number of occurrences of sick days. Where one occurrence is defined as consecutive days out sick. It would also be considered one occurrence if the a weekend f
I\'m trying to generate a report directly from the code (to send it by mail after). I make this in a windows service.
Right now I have an application which uses Reporting Services to render reports. This is working nicely, I call each report with a given value (e.g. a ClientId), and the report gets rendered correctly
We store all our dates SQL Server 2008 database in UT开发者_如何学PythonC time inDateTime columns.
SSRS 2008.Working with 3d Area Chart. In Excel you can label the X, Y, and the Z Axes, but in SSRS I开发者_运维技巧 seem to only be able to label the x and y axes and the Z axis labels seem to be onl
Greetings! I am using SSRS w开发者_运维百科ith MS SQL Server 2008 R2, which has the new feature of supporting shared datasets.
Is it possible to change order of records/groups in a result-set from a query using GROUP BY? I have this query:
I have a (parent) report that has a list. The details group of this list contains one sub-report. So basically if the list has 10 records (rows) the sub-report is executed 10 times.