Skip to Content
Former Member
Mar 04, 2013 at 05:21 PM

Click to set formula value which sorts report



I'm new to the forums and also fairly new to Visual Studio. I've been working with CR for the past 4 years and during that time we have used Datalink Viewer for our employees to view reports. Our company keeps growing and it is becoming a bit difficult to keep up with maintaining reports as the CR and DL softwares are changing and improving. So I've been doing some research and have come across the idea of a web portal for our reports which will enable our employees to view the reports in a web browser.

So far things are going well and most of our simple reports are displaying and working fine. But we have some reports that use a specific functionality of DL which is the click to sort functionality. Basically, one creates a set of formulas in the report header which contain a value. When the user clicks on one of the formulas, the value is passed to a different formula, which in turn dictates how the report is sorted. When changing the sort criteria, the report does not need to run again, it merely goes through the cursor and resorts accordingly. The issue is, that the CR Report Viewer plugin in VS 2010 doesn't allow for a formula field in the header to be clicked. When I try to click on the formula field, it just highlights the field but nothing happens.

Is there any way to make what I have described possible with CR and VS2010? I know this is a long post and if you need any more information, please feel free to ask. Any and all help would be greatly appreciated! I have posted this in some VS forums before, but my posts simply got removed since they were not posted in the right forum, according to the moderators.

Thank you very much in advance for your help,