Reporting Services Report / Chart / Dynamically Hide-Unhide DataFields in a chart

Hello All,

I have a reporting services report in the form of a chart. I have two datafields on the chart.

I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.

How do I do this ?

Any help would be appreciated..

Thanks!

Take a look at the Visibility property. You can use it to hide or show items. The ToggleItem allows you to tie the visibility to another item.|||

Hello,

Thanks for your response. Can you explain to me how to use the visibility property on the DataFields (or) any links that would explain this would be helpful.

Thanks!

|||I'm sorry, I misread your original question. You can't hide a data field directly, but you can set the value for it to an empty string, which causes it not to show up in the chart. However, this won't remove the series label.|||

Hi,

if you don't need to see both fields at the same time you could do the following:

Just put one field into your chart. Rightclick the DataField in your chart and choose properties. Now you see the "Edit Chart Value" window. There you have "Series label:" and "Value:".

For the label use something like

=IIF(Parameters!ReportYear.Value = 2003, "Name of Field 1", "Name of Field 2")

For the value use

IIF(Parameters!ReportYear.Value = 2003, Sum(Fields!NameOfField1.Value), Sum(Fields!NameOfField2.Value))

Now you can start your report and only if you choose 2003 as year, you'll see the values of the first field.

Reporting Services Report / Chart / Dynamically Hide-Unhide DataFields in a chart

Hello All,

I have a reporting services report in the form of a chart. I have two datafields on the chart.

I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.

How do I do this ?

Any help would be appreciated..

Thanks!

Take a look at the Visibility property. You can use it to hide or show items. The ToggleItem allows you to tie the visibility to another item.|||

Hello,

Thanks for your response. Can you explain to me how to use the visibility property on the DataFields (or) any links that would explain this would be helpful.

Thanks!

|||I'm sorry, I misread your original question. You can't hide a data field directly, but you can set the value for it to an empty string, which causes it not to show up in the chart. However, this won't remove the series label.|||

Hi,

if you don't need to see both fields at the same time you could do the following:

Just put one field into your chart. Rightclick the DataField in your chart and choose properties. Now you see the "Edit Chart Value" window. There you have "Series label:" and "Value:".

For the label use something like

=IIF(Parameters!ReportYear.Value = 2003, "Name of Field 1", "Name of Field 2")

For the value use

IIF(Parameters!ReportYear.Value = 2003, Sum(Fields!NameOfField1.Value), Sum(Fields!NameOfField2.Value))

Now you can start your report and only if you choose 2003 as year, you'll see the values of the first field.

sql

Reporting Services Form Authentication - w3wp.exe kernell32.dll Er

Hi,
I have developped a Form Authentication extension for Reporting Services
which used to work just fine on a certain server. Suddenly, for "no apparent
reason" (I had not personnaly changed the configuration of anything on the
server), Report Manager stopped working (but the Report Server still is
working).
I don't see anything wrong (i.e. no ERRORS) in the Reporting Services
LogFiles but in the Windows Event Log I see the following error:
"
Faulting application w3wp.exe, version 6.0.3790.1830, stamp 42435be1,
faulting module kernel32.dll, version 5.2.3790.1830, stamp 424377d2, debug?
0, fault address 0x00015dea.
"
I do get my form for authentication but once authenticated, I never reach
the Folder.aspx page of report manager, instead, I get a "The page cannot be
displayed" ("Cannot find server or DNS Error").
I've tried using Debug Diag on w3wp.exe and here is what I get on the crash
dump report:
"
Thread 15 - System ID 15724
Entry point mscorwks!ThreadpoolMgr::intermediateThreadProc
Create time 14/02/2008 2:50:04 PM
Time spent in user mode 0 Days 0:0:0.171
Time spent in kernel mode 0 Days 0:0:0.125
Function Arg 1 Arg 2 Arg 3 Source
kernel32!RaiseException+53 e06d7363 00000001 00000003
msvcr80!_CxxThrowException+46 019cb508 7a34f188 f64db34c
mscorwks!EEFileLoadException::Throw+119 019cbbe8 0011f338
80070002
mscorwks!AssemblySpec::FindAssemblyFile+307 000fb620 00000001
019cbb10
mscorwks!AppDomain::BindAssemblySpec+19d 019cbbe8 00000001
00000001
mscorwks!AssemblySpec::LoadDomainAssembly+114 0000000b 00000000
00000000
mscorwks!LoadDomainAssembly+144 019ccd20 000f10a8 00000000
mscorwks!TypeName::GetTypeWorker+5fe 019cc6dc 00000000 00000000
mscorwks!TypeName::GetTypeManaged+1ad 019cd82c 7a7223a4 00000000
mscorwks!RuntimeTypeHandle::GetTypeByName+de 00000000 019cd8b4
00000000
mscorlib_ni+2bee29 0230fa60 0230fa60 019cd9a0
System_Web_ni+8fa39 0a2d5614 0a2d5614 02327394
System_Web_ni+94296 00000001 0232824c 01ee2da8
System_Web_ni+9391b 01ee2da8 0231860c 01ee2da8
System_Web_ni+93747 0a2d5614 022d7cec 00000003
System_Web_ni+932fc 023272b4 00000000 02327318
System_Web_ni+931b2 00000000 00000000 022d7ad4
System_Web_ni+930f4 062d2350 022f06d8 022d8f50
System_Web_ni+857e7 00000000 79f481be 00000000
System_Web_ni+83248 00000000 022d7ac8 022d7aac
mscorwks!CallDescrWorker+33 019cdf0c 00000003 019cdff4
mscorwks!CallDescrWorkerWithHandler+a3 019cdf0c 00000003
019cdff4
mscorwks!DispatchCallBody+1e 019cdf00 00000003 019cdff4
mscorwks!DispatchCallDebuggerWrapper+3d 019cdf00 00000003
019cdff4
mscorwks!DispatchCall+b3 019cdf00 00000003 019cdff4
mscorwks!CrossDomainChannel::MarshalAndCall_Wrapper+3f4 019ce040
79f453b8 019ce040
mscorwks!MarshalAndCall_Wrapper2+d 019ce040 019cdee0 79f93fe6
mscorwks!MakeCallWithAppDomainTransition+bc 00000002 79f453e5
019ce040
mscorwks!CrossDomainChannel::MarshalAndCall+64e 019cf524 f64df75c
019cf3bc
mscorwks!CrossDomainChannel::ExecuteCrossDomainCall+7d 019cf524
f64df7e4 019cf54c
mscorwks!CrossDomainChannel::CheckCrossDomainCall+dd 019cf54c
019cf524 f64df038
mscorwks!CTPMethodTable::OnCall+af 019cf54c 000df820 019cf524
0x018c23a5 019cf5b4 022d6554 022e98cc
System_Web_ni+82018 00000000 062d1b48 00000003
System_Web_ni+81c47 00000000 062d1b48 062d18bc
System_Web_ni+81bcd 00000000 062d1b48 062d2188
System_Web_ni+81a76 062d2350 062d22f0 062d0adc
mscorwks!COMToCLRWorkerBody+208 000df820 019cf9cc 019cfa34
mscorwks!COMToCLRWorkerDebuggerWrapper+37 000df820 019cf9cc
019cfa34
mscorwks!COMToCLRWorker+164 000df820 019cfa34 9b96c9d6
0x01a3a295 0000fde9 00000000 019cfce8
webengine!GetAppDomain+154 46c00d97 019cfbe4 019cfae4
webengine!HttpCompletion::ProcessRequestInManagedCode+158 000c1930
00040000 6a2d91a5
webengine!HttpCompletion::ProcessCompletion+3e 01854008 00000000
00000000
webengine!CorThreadPoolWorkitemCallback+18 01854008 77e6bb6d
7a38e228
mscorwks!ThreadpoolMgr::ExecuteWorkRequest+40 000c1930 f64dfaf0
00000000
mscorwks!ThreadpoolMgr::WorkerThreadStart+1f2 00000000 00000000
00000000
mscorwks!ThreadpoolMgr::intermediateThreadProc+49 000c37c0 00000000
00000000
kernel32!BaseThreadStart+34 79f710dd 000c37c0 00000000
In w3wp__PID__11948__Date__02_14_2008__Time_02_50_06PM__702__First chance
exception 0XE06D7363.dmp the assembly instruction at
kernel32!RaiseException+53 in C:\WINDOWS\system32\kernel32.dll from Microsoft
Corporation has caused an unknown exception (0xe06d7363) on thread 15
This exception originated from msvcr80!_CxxThrowException+46.
"
It doesn't feel like the code in my extension is the problem given that it
used to work and I haven't changed anything. Also, it doesn't seem like my
extension is throwing the exception, so it feels more like a configuration
problem somewhere.
Note that if I revert back to the original configuration (without my form
authentication extension), everything goes back to normal, so it really feels
like the problem is in the configuration of the ReportServer/ReportManager
folders.
The server has Windows Server 2003 Service Pack 1, IIS 5.1 and the extension
is coded with .NET 2.0. As specified earlier, I don't think that this
configuration has changed recently. I could show what I changed in the
Reporting Services .config files but first, I want to see if the dump gives
any clue (given that these .config files were working not so long ago).
Any clues or suggestions that I could try?
ThanksHi,
I'm still hoping for an answer. Is this the right place to post an issue
like this?