Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
umar
Starting Member
6 Posts |
 Posted - 2009-01-22 : 06:11:45
|
| any method is available to create dynamic columns in reports(.rdl page). iam getting columns by using dataset, while assigning to table,it may produce different column count based on query. so plz help me to create..................i heared matrix is use for that..if possible plz guide me friends |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-22 : 12:39:41
|
| yup. you can use matrix to create dynamic columns. just group on column whose values you want to come as columns in report and add it in column group tab of matrix. then you can use aggregate functions like sum(),avg() etc over your data fields to get data for columns. if you can provide sample data and output you want out of it, i will be able to help you more |
 |
|
|
umar
Starting Member
6 Posts |
Posted - 2009-01-23 : 00:24:33
|
| thanks friendactually i can add columns from dataset. but my Query Will Produce extra columns with already added columns. how can i add that dynamic columns into my matrix |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-23 : 01:09:22
|
| you mean calaculated columns dynamically? didnt understand the purpose behind that? can you illustrate it with some sample data? |
|
|
|
umar
Starting Member
6 Posts |
Posted - 2009-01-23 : 01:33:49
|
| k...i want to fetch employee details with Loan Details....my query will fetch employee id,Loan 1,Loan 2 ........Loan(n) as columns. Loan details were depends on Employee id. suppose Emp_Id=1 have taken 2 loans than, i vill get Emp_Id,Loan1,Loan2so my column depends on dynamic |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-23 : 12:59:37
|
| Ok. then while retrieving data bring a field containing unique id for each loan of employee. then use it as column group. |
|
|
|
|
|
|
want to create dynamic columns in reports(.rdl)