SSRS 2008 R2: How to design students result spreadsheet using crystal report -

SSRS 2008 R2: How to design students result spreadsheet using crystal report -

i have dataset varying number of fields. first 5 fields static, while rest alter both in name , total number. how handle adding these unknown fields table? thought of writing code loops through fields , inserts column tablix 6th field last, don't know how go - wonder if that's possible or if it's best way solve problem. i'm new ssrs , have written no codes yet. ideas highly appreciated.

thanks in advance.

i lost hair trying solve this. may encounter such problem, although believe there better, less stressful way, here worked me. before that, allow me seek explain problem: wanted create study has both static , dynamic columns (e.g students grade spreadsheet, courses vary faculty, session , semester) using dynamic pivot queries. major issue how dynamic results database pre-designed crystal report. so, here's did:

add empty dataset app. add 2 datatables dataset: empty datatable1 , strongly-typed datatable2 number of expected columns in study - i.e if study requires 10 fields, datatable2 should have 10 columns. also, column names should uniform easy coding (e.g datacolumn1, datacolumn2, ...). add study command app (in case, used crystal report). design study using columns in datatable2. write code gets dynamic columns (in case, course of study codes) database , fill in datatable1. write code gets grades of students per course of study code gotten step5 above. rename text property of dynamic text objects in study name of dynamic columns populated in datatable1. done using nested for...next loop. necessary; otherwise, study not recognize info passed , display blank sheet. display report.

if encounters difficulties in implementing above, or requires modification on this, i'm @ disposal.

regards.

ssrs-2008-r2 crystal-reports-xi