Case Function on a Cell

Hi all,
have a Matrix-based report that tracks project's %complete by period id for a
particular year, as follows:
- 2005
---
01 02 03 04 05 06 07 08 09 10 11 12
project1 10% 12% 18% 25% 38% 52%
project2 13% 29% 68% 89% 100%
project3 25% 68% 100%
:
:
:
I need to know how to change the header grop of Period_id "J F M A M J J A S
O N D" instead of "01 02 03 04 05 06 07 08 09 10 11 12" inside a statement
in the report, since i can not control the sql statement that feeds the
report.
Thank you in advance
Tony
--
Message posted via http://www.sqlmonster.comHave a look at my reply for "Proper syntax of CASE()" etc - in other words
write a little VB .net function in the Report's code box, then call the
funtion to return a string value
"Antony Altobelli via SQLMonster.com" wrote:
> Hi all,
> have a Matrix-based report that tracks project's %complete by period id for a
> particular year, as follows:
> - 2005
> ---
> 01 02 03 04 05 06 07 08 09 10 11 12
> project1 10% 12% 18% 25% 38% 52%
> project2 13% 29% 68% 89% 100%
> project3 25% 68% 100%
> :
> :
> :
> I need to know how to change the header grop of Period_id "J F M A M J J A S
> O N D" instead of "01 02 03 04 05 06 07 08 09 10 11 12" inside a statement
> in the report, since i can not control the sql statement that feeds the
> report.
> Thank you in advance
> Tony
> --
> Message posted via http://www.sqlmonster.com
>

capturing cell click event

hi

is there a way i can capture cell click event like may be in report referenced assemblies etc.. so that i can read the cell text in order to open some external applications/windows forms from that..any idea?

regards
farazi'v got an idea to host custom control in the report and then capture the custom control mouse clicnk event.. i'll explore it as well.. but still if someone can give some clue on the original post..|||

If you this will only when the report is exported to HTML and assuming that you use the Report Viewer ASP.NET control, try hooking mouse onclick event in the page body of the hosting page. You should be able to capture the sender using some java script.

The only RS supported feature that you can use to simulate this requirement is assigning a hyperlink to a field using the Navigation tab.

|||hmm.. it seems that we cant do any client side interaction from reports like calling code from client assemblies(from GAC) etc..as its html rendering .. and yeah the only thing left is builtin navigation and i dont think that i can do much from it..actually in simple ways i wanted to show some window from client side assembley on click of specific cells on reports..and i dont see some straight of doing this..

regards
faraz|||

Please consider the option of visualize the reports by means of web service. Once you obtain the report stream in html format (using the render method) you can parse it to attach javascript events you need.

Regards

Maciej Kiewra