I have a report that shows financial data by year along with a few other bits of static data: every time I try to put in a Column group, it does either above or below the static data: FiscalYear StaticData1 | StaticData2 | StaticData3 | StaticData4 Or: StaticData1 | StaticData2 | StaticData3 | StaticData4 FiscalYear What I want is tha...
I have two tables named IN_Heads, Emp. IN_Heads has one column named Head_Desc with following values Head_Desc .................. Basic DA HRA Emp table has following structure: Emp_No :: BASIC :: DA :: HRA :: LTA :: Canteen 20 :: 4330 :: 340 :: 2763 :: 300 :: 0 21 :: 4000 :: 600 :: 2133 :: 500 :: 30 27 :: 7320 :: 1...
I have two tables A and B, with dynamic columns where I have no idea what columns are key inside them, except from another table called C. The C table specifies which column/s is a key column in tables A and B. There can be 1 or more key columns. My question is, how would I generate such a query where I select all rows from A where the...
I have a data query that returns data in the following format: Name Period Value ----------------------------- Bob Jan 123 Bob Feb 456 Bob Mar 789 Tom Jan 321 Tom Feb 654 Tom Mar 987 Joe Jan 147 Joe Feb 258 Joe Mar 369 The different p...
Hey, I basically need to load table headers from one dataset and table data from another. Is it possible to do with MS Reporting services? As I can see table is associated with the data by DataSetName property and it can be only one dataset. ...