Can you be a little more clear on what you want to do? Do you have a list of fields on your ASPX page that you want to show up in your report, or do you just want the checkbox value to appear on the report?
To be clear, I have to give the user the option for them to choose the report fields they would like to see in the report. By the way I am using CR.Net. For example In the .aspx file(web form) I will display all the employee details such as eno, ename, salary,
Postion, DA, HRA, Deptname , DeptManager etc as a checkbox. So the user who wish to see the report can select the fields they wish to see in the report for eg eno, ename, salary or eno, ename, hr, da, deptname or an option to see all the fields. Could you
please tell me how i have to do this. It's really very urgent. I don't have time to search. Please help me
The ability to choose fields and have only the chosen fields display on a report is not supported in CR .NET. You need CR 10. Having said that, you can sort of work around this limitation, but it takes a little effort. You can design a report based on a generic
schema, and have the columns named "column1", "column2", etc. Make every data type a string in the schema. People can choose up to a certain number of columns, but not more. Then, you can use an ADO.NET dataset, with a single table that has columns named "column1",
"column2", etc. To get the column names to display on the report properly, you can pass the selected field values as parameters, and display the parameter fields at the top of the columns. A forum is not the right place to outline the entire process, but here's
an overview of the workflow you'll use. Use the VS .NET help files where you need to: 1) Design XSD document. Give each column a generic name, and make each a string. 2) Design your report using the XSD as the report design source. 3) Design your input page,
where users can choose the columns. 4) Design your database query. Either use dynamic SQL in your code-behind, or use a stored procedure. 5) Use this reference for help in creating an ADO.NET dataset and using it as report source: http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf
renita
Member
100 Points
20 Posts
Passing the selected check box values as a parameter to report
Oct 06, 2004 03:09 PM|LINK
RyanSmith
Participant
1944 Points
374 Posts
Re: Passing the selected check box values as a parameter to report
Oct 06, 2004 11:28 PM|LINK
rjdudley
Star
10145 Points
1976 Posts
ASPInsiders
Re: Passing the selected check box values as a parameter to report
Oct 07, 2004 01:01 PM|LINK
renita
Member
100 Points
20 Posts
Re: Passing the selected check box values as a parameter to report
Oct 07, 2004 01:22 PM|LINK
rjdudley
Star
10145 Points
1976 Posts
ASPInsiders
Re: Passing the selected check box values as a parameter to report
Oct 07, 2004 05:19 PM|LINK
renita
Member
100 Points
20 Posts
Re: Passing the selected check box values as a parameter to report
Oct 07, 2004 06:41 PM|LINK