Click to set formula value which sorts report

[Former Member]

Greetings,

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,

Chris

[former_member183750 · Accepted solution]

Hello Chris

I suppose there are two ways of approaching the issue. As far as I am concerned, the 1st one I'll touch on requirinres substantial code (more that what you'd think this would need anyhow).

1) CRVS2010 SP3 and later has a double click event that can be trapped via the InProc RAS SDK. Details on how to do this are documented in this KBA:

1704452 - Enhancement: DoubleClick event on Report Object does not return any values

Direct link: http://search.sap.com/notes?id=0001704452&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

(Hyperlinks are on the fritz today)

Now, the issue with the above is that you are going to get all of the content on the line you fired the event on. So, then you'll have to parse that out for the formula(s), determine which one applies and then sort based on that.

or:

2) See if the following feature demo will be acceptable:

http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/504d77eb-892a-2d10-c0b9-c9b6da1e1ffa

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Ludek,

thank you so much for your response! I read through the articles you suggested and it turns out that I was able to make it work with suggestion #2. I think ultimately I will be able to move away from the somewhat involved report structure that is needed for Datalink Viewer to the much simpler way of "Saved Data".

Thanks again and I'm sure I'll be asking for help again soon!

Chris

[former_member183750 · Accepted solution]

Hello Chris

Excellent news. Option #2 is a new feature in CRVS, so I was a bit hesitant, both from CR perspective and from usefulness to you perspective. But as long as it serves...

Happy coding,

- Ludek