Assigning values based on InitialToggleState of a control in SSRS

Hi,

I need to assign the value for a field in a report based on Expand/Collapse state of another field.

Eg. If Collapsed, the value should be "AA" else if Expanded "BB".

Is there any way to get the value of InitialToggleState for any field in SSRS.

Thanks in advance.

Sathya

Use True for Collapsed and False for Expanded.

As explained at the following link

http://www.manning-sandbox.com/thread.jspa?threadID=14881&tstart=60

Assigning values based on InitialToggleState of a control in SSRS

Hi,

I need to assign the value for a field in a report based on Expand/Collapse state of another field.

Eg. If Collapsed, the value should be "AA" else if Expanded "BB".

Is there any way to get the value of InitialToggleState for any field in SSRS.

Thanks in advance.

Sathya

Use True for Collapsed and False for Expanded.

As explained at the following link

http://www.manning-sandbox.com/thread.jspa?threadID=14881&tstart=60

ASP.net version

I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
and now I am unable to access the report server. I noticed that I now have
asp.net version 2 instead of version 1. I think this may be the problem.
In VS 2005 I do not use the web part of the program at all so I think I may
be able to delete version 2 from IIS and install version 1 again and that
this may solve my problem. But before I do I just thought I should ask here
if someone else sees a problem. I guess the worst that could happen is that
it would continue not to work.
Anyone?Both the ReportServer and Reports virtuals roots need to be mapped to
ASP.Net 1.1.4322. You can verify this in the properties for each virtual
root on the ASP.Net tab.
What error message do you get when you access report server? Installing a
new version of the framework will reset the password on the ASPNet account,
removing all encryption keys from the account. You may simply need to run
rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
> and now I am unable to access the report server. I noticed that I now
have
> asp.net version 2 instead of version 1. I think this may be the problem.
> In VS 2005 I do not use the web part of the program at all so I think I
may
> be able to delete version 2 from IIS and install version 1 again and that
> this may solve my problem. But before I do I just thought I should ask
here
> if someone else sees a problem. I guess the worst that could happen is
that
> it would continue not to work.
> Anyone?
>|||To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility found
in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||Using the aspnet_regiis utility will definitely cause you to lose the
encryption keys because it resets the ASPNet account password. You are
better off using the IIS virtual root properties page.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:utbIkAXgEHA.2544@.TK2MSFTNGP10.phx.gbl...
> To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility
found
> in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> > Both the ReportServer and Reports virtuals roots need to be mapped to
> > ASP.Net 1.1.4322. You can verify this in the properties for each
virtual
> > root on the ASP.Net tab.
> >
> >
> > What error message do you get when you access report server? Installing
a
> > new version of the framework will reset the password on the ASPNet
> account,
> > removing all encryption keys from the account. You may simply need to
run
> > rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Woody Splawn" <nospam@.splawns.com> wrote in message
> > news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have been running SSRS in VB 2003 but recently I installed VS 2005
> beta1
> > > and now I am unable to access the report server. I noticed that I now
> > have
> > > asp.net version 2 instead of version 1. I think this may be the
> problem.
> > >
> > > In VS 2005 I do not use the web part of the program at all so I think
I
> > may
> > > be able to delete version 2 from IIS and install version 1 again and
> that
> > > this may solve my problem. But before I do I just thought I should
ask
> > here
> > > if someone else sees a problem. I guess the worst that could happen
is
> > that
> > > it would continue not to work.
> > >
> > > Anyone?
> > >
> > >
> >
> >
>|||> What error message do you get when you access report server?
I am getting the following message:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled)
>You may simply need to run rsactivate -r -c <config file>
If I do, what is the exact syntax?
If I understand correctly I move to my MS SQL Server\80\tools\binn directory
to run rsactivate. What is the name of the config file? I have a file
called cnfgsvr.ini, if that helps. What exactly do I do?
In the help on line I got the following:
"A system administrator on the computer running the Report server service
can use a backup copy of the public key to get the report server running
again. Use the rskeymgmt utility to apply the backup key set. If you do not
have backup of the key, you must run rskeymgmt utility to delete all of the
encrypted content, run rsconfig utility to respecify the encrypted
connection values used to connect to the report server database, restart the
service, and retype stored credentials for all reports that use stored
credentials. For more information this utility, search Books Online."
However, I do not understand exactly what they're saying.
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||P.S.
I do keep a backup of my entire system. I'm sure I have a backup that
preceeds the install of VS 2005 beta1. If it is just a matter of copying a
certain file back into a certain directory I can easily do that, but what
file and what directory?|||Woody,
Check this thread and see if it will help.
http://tinyurl.com/6fyb7
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>|||Your ASPNet account password was reset. The database is intact, and that
backup won't help you. As a side note, you may want to check out the topics
relating to backing up your report server in books online. You certainly
want to back up the encryption key.
The data that is missing was in the ASPNet user profile. Running
"rsactivate -r -c <config file>" will fix the problem. The config file you
are looking for is called rsreportserver.config. You should specify the
full path to the file.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>

ASP.Net DS ->SSRS Report? ...or do I?

Is there a "native" way to pass a sorted table or dataset to a SSRS?
Or, is there another way to do the following...
I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
params.
These will use a sProc that executes some dynamic SQL to accomodate the
variations in params passed.
This is all good and working as a prototype in .Net.
However, most of the results sent to the browser also need to be sorted and then
hard copy printed, so...
Option One; Have the ASP.Net app do all .Net datalists and the like presenting
all the data as needed. Then when a user wishes to print that data they click
the printable version link, which would pass the current dataset as sorted to
SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
alone.)
Option Two; Write my sorted data to a dynamic (rather than temp table) and then
call SSRS with params to get all the data as is from the dynamic table.
Option Three; give up, go home, take a nap, be a quiter, start crying like a
little boy, melt into a puddle of goo.
TIA
JeffP....I suggest rethinking a little how you do this. RS has a couple of ways to
integrate with your ASP. It has very good support for stored procedures. So
you can already use your stored procedure. You can integrate either by URL
or by web services. URL integration is the easiest way to go. Try just
creating a report with RS using the stored procedure and the parameters.
Once you have a report working then try out URL integration.
Passing a dataset is the hardest way to go to solve this. People have done
this but it requires a lot of jumping through hoops.
Bruce L-C
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> Is there a "native" way to pass a sorted table or dataset to a SSRS?
> Or, is there another way to do the following...
> I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> params.
> These will use a sProc that executes some dynamic SQL to accomodate the
> variations in params passed.
> This is all good and working as a prototype in .Net.
> However, most of the results sent to the browser also need to be sorted
and then
> hard copy printed, so...
> Option One; Have the ASP.Net app do all .Net datalists and the like
presenting
> all the data as needed. Then when a user wishes to print that data they
click
> the printable version link, which would pass the current dataset as sorted
to
> SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> alone.)
> Option Two; Write my sorted data to a dynamic (rather than temp table) and
then
> call SSRS with params to get all the data as is from the dynamic table.
> Option Three; give up, go home, take a nap, be a quiter, start crying like
a
> little boy, melt into a puddle of goo.
> TIA
> JeffP....
>|||Bruce,
I had a friend who is a much better programmer come over and we did a simple
sProc and created a SSRS Report.
We then ran the report as a SSRS report and then via URL; our biggest pain was
overcomming the "...you do not have permission to view this page..." or similar.
We added a default credential process if one was not present as well as a
user/pass textboxes w/cmd button to go to the report as a proof of concept that
we can accept win/auth, (won't be happening in any environment we have before
us) or default creds.
Anyway, back to my pain of displaying a report that was derived from the current
datalist control filtered and sorted as such.
I may try my dyna-temp table method. I think that there is a rumor indicating
that SSRS 05 will enable a method to call a SSRS report and pass it a .Net
DS/table.
I'd have thought that this would have been a first ed. feature(?)
TIA
JeffP...
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ONp0KaPbEHA.3664@.TK2MSFTNGP12.phx.gbl...
> I suggest rethinking a little how you do this. RS has a couple of ways to
> integrate with your ASP. It has very good support for stored procedures. So
> you can already use your stored procedure. You can integrate either by URL
> or by web services. URL integration is the easiest way to go. Try just
> creating a report with RS using the stored procedure and the parameters.
> Once you have a report working then try out URL integration.
> Passing a dataset is the hardest way to go to solve this. People have done
> this but it requires a lot of jumping through hoops.
> Bruce L-C
> "JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
> news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> > Is there a "native" way to pass a sorted table or dataset to a SSRS?
> >
> > Or, is there another way to do the following...
> >
> > I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> > params.
> >
> > These will use a sProc that executes some dynamic SQL to accomodate the
> > variations in params passed.
> >
> > This is all good and working as a prototype in .Net.
> >
> > However, most of the results sent to the browser also need to be sorted
> and then
> > hard copy printed, so...
> >
> > Option One; Have the ASP.Net app do all .Net datalists and the like
> presenting
> > all the data as needed. Then when a user wishes to print that data they
> click
> > the printable version link, which would pass the current dataset as sorted
> to
> > SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> > alone.)
> >
> > Option Two; Write my sorted data to a dynamic (rather than temp table) and
> then
> > call SSRS with params to get all the data as is from the dynamic table.
> >
> > Option Three; give up, go home, take a nap, be a quiter, start crying like
> a
> > little boy, melt into a puddle of goo.
> >
> > TIA
> >
> > JeffP....
> >
> >
>

ASP.NET & anti-virus & SSRS 2005

Below, I have pasted a portion of an MS MSDN article dealing with a specific issue we are having with Report Server performance. The URL (http://support.microsoft.com/kb/821438/en-us) is the MS KB article on the described fix. The fix mentioned is for "ASP.NET 1.1" but our BP Report Server is using "ASP.NET 2.0".

Has anyone encountered and resolved and how?

Running on box:
ASP.NET 2.0.50727;
SSRS 2005 Sp1 + Hotfix#2175;
Win Server 2003, R2, x64, SP1
Trend Micro OfficeScan Cleint for Win 2003/xp v7.3
IIS Version (I cannot find this #) - ? IE 6.0

===========================
Report Manager or the report server runs very slowly

In some circumstances, ASP.NET applications run very slowly on computers that are running anti-virus software. If the Report Server Web service is restarting frequently, and you are running anti-virus software, you can obtain an ASP.NET fix from Microsoft Customer Support Services.

Symptoms include Web applications or Application Domains restarting for no apparent reason, slow performance, session restarts, and more. For more information about the symptoms, cause, and resolution, see Microsoft Knowledge Base article 821438.

You can find out whether there are excessive server restarts by viewing the number of reportserver_<timestamp>.log files. A new log is created each time the server starts. A large collection of logs created at very short intervals is an indication that the conditions described in article 821438 exist on your server
===========================

It appears the issue goes away with SQL2K5 SP-2 load. Thanks to whoever.....