Hello,
I would like to allow the user to dynamic choose which field to group-by in a report. In the Windows form they choose a field by name from a combobox, then I pass that to the report as a parameter. How do I then use that in the report in the group-by dialog I've tried to construct the "Fields" expression using the parameter but I'm missing something. The following does not work.
= "Fields!" & Parameter.Mine.Value & ".Value"
Thanks
User dynamically chooses group-by field
vitalidov
Thanks Robert! Can you recommend a few good books that treat topics like this
Bkss
I'm not aware of a book that covers the VS 2005 ReportViewer controls specifically.
However, there are several good Reporting Services 2000 and Reporting Services 2005 books available which cover RDL expressions and programmability in depth. Most of that information also applies to RDLC files in ReportViewer controls.
Here are a few examples of books that present information at a good technical level:
* "Hitchhiker's Guide to SQL Server 2000 Reporting Services", by Peter Blackburn and William Vaughn
* "Reporting Services in Action", by Teo Lachev
* "Microsoft SQL Server 2005 Reporting Services", by Brian Larson
-- Robert
IG.
Use the following syntax:
=Fields(Parameters!Mine.Value).Value
-- Robert