Report Building help please...
-
A little background. I have created a stored procedure in sql server. That will generate a ##temp table, then when the stored procedure is complete with generating the table and filling the table with the data for the report, it will drop the ##temp table. I want to generate a Crystal Report and or Microsoft Reporting Services Report. The report will need to be generate from scratch in code. Which comes to the part I need help with. The table will be a minimum of 2 columns to the maximum amount of columns sql server tables will allow. The First 2 Columns are Hard Coded as: JobNumber int, [Job Name] [nvarchar](100) All the other fields are INT. Because the number columns in the report are not static number of columns. I do not know how to generate the report in code. In the past I would create a xsd and fill the xsd and pre-design the report before with the fields in the xsd. Please I know this is a lot to ask but can someone please give me relevant resources (Websites, Samples, Detailed, Explanation) to research to learn how to accommodate this scenario. I need to know how to create this report, and In the report I need the column names as well (The column names I think I can handle). I can populate a data grid on the form but I am not sure that that is the right way to do this.