How can I get report columns from code behind?

vatsal24 · Post by **vatsal24** » Thu Jun 28, 2012 7:01 am

Hi,

I am working on one project where I am creating one wizard to configure report filters, orderby and groupby columns from web UI. I already have created some base reports (.mrt) which contains 10 to 12 columns in each. I want user can select orderby and group by columns from these 10 / 12 columns and also set filters through wizard.

My question is, I want to list all columns from selected report in one list box so user can select one or more columns for groupby/order by.

Can anyone please help me in this?

Thanks

Post by **HighAley** » Fri Jun 29, 2012 3:15 am

Hello.

vatsal24 wrote:I am working on one project where I am creating one wizard to configure report filters, orderby and groupby columns from web UI. I already have created some base reports (.mrt) which contains 10 to 12 columns in each. I want user can select orderby and group by columns from these 10 / 12 columns and also set filters through wizard.

My question is, I want to list all columns from selected report in one list box so user can select one or more columns for groupby/order by.

Can anyone please help me in this?

You could get all components of report in your code. Select from them headers and list them.
For more detailed answer we need to see your report template.

Thank you.

vatsal24 · Post by **vatsal24** » Fri Jun 29, 2012 5:29 am

Hi I have attached one template with my first post. Please let me know if you want any other detail from my side.

Thanks.

Post by **HighAley** » Fri Jun 29, 2012 8:28 am

Hello.

vatsal24 wrote:Hi I have attached one template with my first post. Please let me know if you want any other detail from my side.

In your case it will be more easier to create report by code.

Please, look at the attached sample project.

Thank you.

vatsal24 · Post by **vatsal24** » Fri Jun 29, 2012 10:52 am

Thanks for your quick reply

I will see attached project and let you know if I have any issue.

Thanks

vatsal24 · Post by **vatsal24** » Fri Jun 29, 2012 11:04 am

Hi,

I saw project sent by you but I want exact reverse functionality. i.e. I want to fetch columns names, group by column names, sorting column names and filters from this report I have given. Because the report I gave you is a base report which is already created. On first step User will select one existing report (like I sent you), on second step I want to show user the list of columns from base report, name of columns which are already grouped by and user can select or remove any group by column if he/she wants and same things for order by columns and filters.

Can you help me in this direction? I can provide you more information if you want...

Once again Thanks for all your support...

Post by **Alex K.** » Wed Jul 04, 2012 1:44 pm

Hello,

Please see the sample report in attachment.

Thank you.