ShowhideToggle For Render Method ? - Ssrs 2000

Apr 26, 2007

Hi there.



I had been looking around for some info about this.

So far I understand that the showhidetoggle parameter determines which drilldowns are visible or hidden.



I am trying to use the render method, and try to show the drilldowns on my html page.



First question:

How does the showhidetoggle work in the URL or even show an example of how the drilldowns work through showhidetoggle ? In other words, how does the showhidetoggle knows which one to display if I have only one string value ? Maybe there is another way to do this or another way to define this syntax ?



Second question:

How do i determine the number or the string parameter without having to look through html ? is there a way to do this so that I can pass this string to the parameter in the ASMX ?



Thanks for reading this post !

View 1 Replies


ADVERTISEMENT

SSRS Web Service Render Method Documentation?

Dec 28, 2007

Hi all does anyone know where I can find more information on the Render method of the Reporting Services WS?
Specifically there is a DeviceInfo parameter that you need to pass in and it is a string that is in an XML format but I cannot seem to find any documentation on the specifics of it. I have seen a few examples but no specifics.

Any help with this is greatly appreciated?

Thank you,
John



View 3 Replies View Related

Bug - SSRS WS Render Method Not Working As Documented?

Dec 31, 2007



Hello all, according to the documentation for the DeviceInfo parameter of the ReportingService.Render method the Xml string fragment of PageHeight and PageWidth for the Image Device Information Settings should and I quote.


The page height, in inches, to set for the report. You must include an integer or decimal value followed by "in" (for example, 11in). This value overrides the report's original settings.


Emphasis mine. Page width is similar. However when I change that value to what is desired for the IMAGE format it has no effect whatsoever no matter what value I place in there.

Indeed the size that is rendered is more related to the current display resolution setting rather than the PageHeight/PageWidth values passed in. In otherwords if my laptop has a higher resolution of 1920x1200 and the server that I deploy this WS to has a lower resolution of 1280x1024, the image rendered on the higher resolution display fits on to an 8.5x11.0 in page with room to spare but on the lower resolution display it is clipped because it does not fit the page.

Is there something that I am doing wrong or is this indeed a bug?

Thank you,
John

View 4 Replies View Related

Problem With ReportExecutionService.Render Method

Jun 24, 2008

hi
I am using SSRS for Reports. Every thing working fine, but i have one problem when my rport get the 2000 record (each record showing on single page in my senario) then ReportExecutionService.Render method did not return array of byte[].
Can u help me as soon as possible.

thanks in advance
arvind

View 2 Replies View Related

Specifying Language For ReportingService Render Method

Oct 3, 2007

I have a report that I'm hosting on SSRS. I have it setup for localization so if someone hits the report directly and their default language setting in their browser is ja-JP the report will display in Japanese. I am using the User!Language variable for this.

I am primarily displaying this report through an ASP.NET app however and am calling the Render method on the ReportingService service, then displaying the returned HTML in a literal control. This works great except, obviously, with this proxy type of set up the user's browser settings get lost in the shuffle. I can retrieve the browser settings easily enough in my ASP.NET application but how do I pass those settings along to SSRS? I have tried setting the CurrentCulture and CurrentUICulture on the thread executing the request but it still comes back in English. I have also tried setting the Language property (as shown below) but it seems as though that would change the Language on the report for everyone, not just my session.


Property[] props = new Property[1];


props[0] = new Property();

props[0].Name = "Language";

props[0].Value = "ja-JP";

report.SetProperties(reportPath, props);

Can someone help?

Thanks

View 1 Replies View Related

Page Number In ReportExecution2005 - Render Method

Mar 10, 2008

Hello,

I am trying to render a Report in HTML4.0 format using ReportExecution2005 web service's Render method. When I use this, I am getting all the results in a single page. I want to display the results page by page as ReportViewer control does. Is there any way to get the total number of pages of the Result using Render() web method?

I tried using the following deviceinfo:

"<DeviceInfo><StreamRoot></StreamRoot><Toolbar>True</Toolbar><Parameters>True</Parameters><Section>0</Section><HTMLFragment>false
</HTMLFragment></DeviceInfo>";

Any help or suggestions would be appreciated.

View 7 Replies View Related

ReportExecutionService Render Method - Setting The Data - XML

Feb 2, 2007

Hello all,

I'm at a bit of a loss as it seems what I want to do should be obvious but I can't seem to locate whether it is possible. Essentially I would like to render a report using the api/C# and I would like to set the actual data the report renders via an XML string that I construct however I like within my code. Is this not possible? I hope I'm overlooking the obvious here.

Thanks in advance for your feedback.

View 4 Replies View Related

How To Use The Render Method To Save A Report Directly To Disk ?

May 2, 2007

Hi there,



Is there a way to programmatically save a RS results into Excel format using the render method ?

I had read about that capability but I can't seem to find any sample code on how to do it. Is this a parameter that you have to set in the render method ?

Any suggestion or tips are much appreciated !

Thanks !

View 5 Replies View Related

How To Render One Page At A Time Using SSRS Webservices

Apr 10, 2008

I developed a java proxy application for SSRS(Sql Server Reporting services) and able to render the reports by making webservice calls to SSRS webservices. But I am getting the data for the complete report. How can I get only a partial report( like page by page as we get in the Report Manager)? Which parameters should I pass.
As some of the reports are too big, the java application is getting memory issues and I want to limi the data that I get from SSRS.

Appreciate your suggestions.


View 6 Replies View Related

SSRS - Invalid Attempt To MetaData When Reader Is Closed On Render When Calling A Report From Asp.net

Sep 25, 2006

I get the following error when generating a report. I use the "render" method in an asp.net page. I have also seen Timeout errors, which is the second error listed below.

Configuration
db-SQL Server 2000 on clustered windows 2003 server SP1, 5.5 GB RAM
SSRS 2005 and IIS 6.0 on 2nd windows 2003 server SP1, 3.75 GB RAM
generating SSRS Report using asp.net
Error is on large amounts of data, main source table has 11.2 Million records. The stored procedure returns
507,387 rows in approx. 25 minutes.
No problem with smaller amounts of data using the same source of 11.2 million records, but returning
much less.

Error 1: (from try/catch on render method)
System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> An error has occurred during report processing. ---> An error has occurred during report processing. ---> The Group expression used in grouping €˜territory€™ references a data set field which contains an error: System.InvalidOperationException: Invalid attempt to MetaData when reader is closed. at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.GetValue(Int32 fieldIndex) at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetFieldValue(Int32 aliasIndex) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at rptsvc.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesswisherreports842e8e9d5ff5a831App_WebReferences.no0lpcgz.0.cs:line 1706 at ar_sum_aging.btnGenRpt_Click(Object sender, EventArgs e) in U:Visual Studio 2005ProjectsSwisherReportsar_sum_aging.aspx.vb:line 32

Error 2: (from ReportServer error log)
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: An exception has occurred in data source 'ar_sp'. Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!9/25/2006-18:32:53:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!9/25/2006-18:32:53:: w WARN: Data source 'AR': Report processing has been aborted.
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Found System.OutOfMemoryException exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Terminating worker process

View 1 Replies View Related

Bug In SSRS SetItemDataSources Web Service Method

Dec 19, 2007

Bug:

An existing SSRS 2005 data source at the root directory cannot be used by the SSRS SetItemDataSource web method.

Steps to reproduce:
1. On the machine running SSRS 2005, create a folder named Reports and upload an RDL file named "Existing.rdl" into that directory. For clarity the SSRS path to this report is /Reports
2. Set up a valid data source at the root directory (For illustrative purposes we'll name it DS).
3. Set up a web reference to a SQL Server Reporting Web Services 2005. e.g. http://localhost/reportserver/reportservice2005.asmx

3. Try to set the DS data source to the "Existing" report by calling the SetItemDataSource web method.

C# Code Excerpt:
...
try{

ReportingService2005 reprtSrvc = new ReportingService2005();

DataSource[] dsarray;
string reportName = "Existing"
string _selectedFolder = "/Reports/"
DataSourceReference reference = new DataSourceReference();
DataSource ds = new DataSource();
dsarray = new DataSource[1];
reference.Reference = "/";
ds.Item = reference;
ds.Name = "DS";
dsarray[0] = ds;
//Exception thown ...
_reprtSrvc.SetItemDataSources("/" + _selectedFolder + reportName , dsarray);
}
catch (SoapException ex)
{
//Exception
Message.displayMessage(ex.Detail["Message"].InnerXml, MessageType.Error);

}
...

Exception details...

ex {"System.Web.Services.Protocols.SoapException: The operation you are attempting on item "" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "" is not allowed for this item type. at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.ResolveNewDataSources(DataSourceInfoCollection newDataSources, Boolean forModel) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.SetReportDataSources(CatalogItem item, DataSource[] dataSources) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) at Microsoft.ReportingServices.WebServer.ReportingService2005.SetItemDataSources(String Item, DataSource[] DataSources)"} System.Web.Services.Protocols.SoapException

View 4 Replies View Related

Sql 2000 Reporting Services - Reports Will Not Render Online

Jul 5, 2007

Hi all,

i got through the installation of the Sql Server 2000 Reporting services evaluation and managed to deploy a couple reports and a shared data source to my reporting server on my DEV box.



Now im trying to view the reports i made online and they never render, all i get is the animated gif that always says "Report is being generated". This goes on and on with apparently no end in sight.



I CAN preview the reports in VS 2003 and they render almost instantly. there are no differences that may affect the connection to the database between my development computer (with VS 2003) and the server that the reporting server is on.



Anyone have any ideas as to why this may be happening ?

thanks,

mcm

View 2 Replies View Related

SQL 2012 :: SSRS Virtual Directory - HTTP GET Method Appending Default Path

Sep 27, 2015

There was a 2008 SSRS service running on server "abc".

I have a .Net UI that uses the wsdl at [URL] ....

They deployed SSRS 2012 service on a new server "xyz".

DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.

when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.

I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?

View 0 Replies View Related

List Of Parameters Used Together With Rs: Parameter In SSRS 2000 And SSRS 2005

Apr 24, 2007

Hi,

Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?

Thanks,

View 1 Replies View Related

I Need To Restore A SQL 2005 DB To SQL 2000. What Is The Best Method To Do This?

Nov 1, 2007



Hi

I need to restore a SQL 2005 DB to SQL 2000.
What is the best method to do this?

Thanks in advance.

View 6 Replies View Related

Send Request To Stored Procedure From A Method And Receive The Resposne Back To The Method

May 10, 2007

Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString)    {      //call stored procedure  } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.  

View 3 Replies View Related

Update Method Is Not Finding A Nongeneric Method!!! Please Help

Jan 29, 2008

Hi,
 I just have a Dataset with my tables and thats it
 I have a grid view with several datas on it
no problem to get the data or insert but as soon as I try to delete or update some records the local machine through the same error
Unable to find nongeneric method...
I've try to create an Update query into my table adapters but still not working with this one
Also, try to remove the original_{0} and got the same error...
 Please help if anyone has a solution
 
Thanks

View 7 Replies View Related

SQL Server 2000 Migration To SQL Server 2005 Collation Change - Method?

Jan 24, 2008

Scenario
Recently moved a SQL2000 database to SQL2005.
Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS
Colaltion on SQL 2005 database server is Latin1_General_CI_AS

After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation.

What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' -
1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability>
on each varchar/char column

or

2) For each table
BCP out data
DROP TABLE
RECREATE TABLE (taking the new collation Latin1_General_CI_AS)
BCP in data

3) Other methods?

Thanks in advance
David.

View 4 Replies View Related

Best Method To Upgrade From SQL Server 2000 To SQL Server 2005

Nov 29, 2007

Hi.

We are going to upgrade one of our SQL Server 2000/Win200 instance to SQL Server 2005/Win2003. Currently, the SQL Server 2000 which contains about 30 database. This is my plan:


Install SQL Server 2005/Win2003 on a new instance
Backup SQL Server 2000 database instance (how do I back all 30 database at the same time?)

Then do a Restore from the SQL Server 2005 instanceIs this a good method or using the "Copy Database Wizard" is better method?

I'm new to this so please advice? Thanks!

View 14 Replies View Related

Any Certification In Ssrs 2000

Jul 2, 2007

Hi all,
Is it any Microsoft certification is there for Sql Reporting service ,If is there means please send me the related link to me!!!
Regards,
P.Veera Vinod.

View 2 Replies View Related

Valdations In SSRS 2000

Mar 29, 2007

Hi ,



Can we provide validations to prameter values? Like if Input parameter to Report is Date. So how do I validate the Date parameter. Is there any way -



Thank you,



Regards,

Palak Shah

View 6 Replies View Related

SSRS 2000 Migration

Apr 3, 2007

Hello,

We currently have a web server running SSRS 2000 and are looking to migrate this to a newer server using the same version of SSRS. My question is, how I would go about migrating the reports, subscriptions, etc. Our database is on another server for both ReportServer and ReportManager. I would like to be able to simply attach the new instance to the existing database and have everything work exactly the same. I know we have exported a key from our server. I don't know if this is something that would be needed or not.

Any help that can be provided is greatly appreciated. I'm sure this is all covered in some mountain of documentation somewhere, but I'm hoping someone will be kind enough to provide the quick answer. If not, I will head toward our documentation.

Thanks in advance.

View 2 Replies View Related

Drill Down Report For SSRS 2000

Feb 26, 2008

Does anyone have a link to a good tutorial on how to create a drill down report in SSRS 2000. I found one for SSRS 2005
http://www.c-sharpcorner.com/UploadFile/MohanKumar.R/DrillDownReport02212008083910AM/DrillDownReport.aspx
If I had the AdventureWorks Db I may be able to figure it out.

I know how to create a hyperlink but I need the toggle (+/-) for my latest endeavor.

My book "Hitchhikers Guide..." didn't help me out.

Thanks.

View 3 Replies View Related

SSRS 2000 Installation Problem. Help Pls!

Jan 25, 2007

Hi all,

I'm trying to install Reporting Services 2000 on Small Business Server 2003(which includes windows server 2000 sp3). I got the error message after setting the virtual directory folder:

"WizardFirst

Error Code: 1603"


Could anyone tell me the reason?

Thx in advance.

View 4 Replies View Related

Report In SSRS Using Cube In SQL 2000

Jan 25, 2006

I want to create reports in SSRS that use cube in SQL 2000, I don't know which type of connection that i have to use,

I tested it with Microsoft SQL Analysis Services, means I connect to my cube with this type , everything is ok in developpement (create MDX query , make reports...), but in production It gives me this error message (cannot connect to the datasource),

so I don't know how to solve this problem,

Thanks in advance for your help...,

Regards

View 1 Replies View Related

SSRS 2000 Deploying Report

Mar 16, 2007

windows 2003 SP2 with AD, IIS with SSL, SQL 2000 SP4, RS SP2.

I am trying to deploy a report from visual studio .net 2003. Error message: not able to connect to https://servername/reportserver
I can access the reporting website on IE https://webserver/reportserver, and I can up load reports with site interface, but can't use designer 2003 to deploy.

any suggestions?

Thanks,

Jaime B.

View 1 Replies View Related

SSRS 2000 Data Not Refreshing In Report

May 7, 2007

Good day,

I have a SSRS 2000 report that when I view the report data does not refresh until I press the refresh data button in the report. Clearly this can't be right and to expect users to press the refresh button every single time is also rediculous.

HAs anyone had this problem before and know what to do.

Please help.

Thanks

View 3 Replies View Related

SSRS 2000 Not Displaying Latest Data

Mar 19, 2008

Good day,

My report links to a SQL server and is not showing the latest information. If I open it now and look at the report, close it and open it again ina few hours it will show the same report as I looked at originally. When I push the reports refresh button then the data refreshes and shows all the information.

The execution for the report is already set to: Do not cache temporary copies of this report

Why does this happen? I have about 40 reports that work perfectly but this one is giving me problems, any one got any ideas for me? Please help.

Thanks

View 2 Replies View Related

Reference A Textbox In A Report SSRS 2000

Jun 26, 2007

I am working in SSRS 2000, and I have a report using a table. In the footer of the table I want to do a calcuation. I have a textbox in the table called "SumAmtCurrent", which is a sum value for a field in my dataset. I have another field in my dataset, "TotalRevCurrent", and I would like to take this second field, subtract the value in the textbox "SumAmtCurrent", and have the result in the footer of the table. I tried to reference the textbox using ReportItems!SumAmtCurrent.Value - but that gives me the following error

"...The value expression for the textbox €˜textbox7€™ refers to the report item €˜SumAmtCurrent€™. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope..."



Is there a way I can get this total into my report?

Thanks in advance!

View 1 Replies View Related

SSRS 2000 Not Displaying Latest Data

Mar 18, 2008



Good day,

My report links to a SQL server and is not showing the latest information. If I open it now and look at the report, close it and open it again ina few hours it will show the same report as I looked at originally. When I push the reports refresh button then the data refreshes and shows all the information.

Why does this happen? I have about 40 reports that work perfectly but this one is giving me problems, any one got any ideas for me? Please help.

View 4 Replies View Related

Converting Reports FROM SQL RS 2000 TO SSRS 2005

Apr 23, 2007

I have abt 30 reports currrently in SQL 2000. My data still resides in SQL SERVER 2000. However, I need to convert these reports to SSRS 2005.

I want to use the cool features like sorting, multi-value parameters from the RS 2005.

Can you pl advise how I shud go abt converting these reports from RS 2000 TO RS2005 .

Thanks.

View 5 Replies View Related

How To Use The Sum To Add Specific Data From The Table In Ssrs 2000?

Mar 7, 2007

Hi All,

I am new to this forum and had checked this forum for this problem that I am having. Although there were a lot of informative articles that I found useful, I still couldn't resolve this problem.

I am having a little trouble trying to use the Sum function to get the totals that I need for a project that I am trying to accomplish. The scenario is below:-

This is the report image that I want to produce.

Region1 policy1 policy2
AgentType1 Total Total
Agenttype2 Total Total
AgentType3 Total Total
Region1's policy1 Total Region1 Policy2 Total


Region2 policy1 policy2
AgentType1 Total Total
Agenttype2 Total Total
AgentType3 Total Total
Region2's policy1 Total Region2 Policy2 Total

(this is where i am having the problem)
AgentTotals
AllAgentType1Totals Policy1Totals Policy2Totals
AllAgentType2Totals Policy1Totals Policy2Totals

TotalforallRegions RegionsTotals

I managed to get all the information I needed in the
Report except for Agent Totals. I am having a little
bit of a logic problem on how to get the totals for a
particular agent type with each policy.

Right now my layout only has ONE grouping which holds
the region types. my dataset basically is how the
report is going to look like without the totals.

Is there an expression I can use that would identify
what type of agent that is and then add the total ?

kinda like the following:-

=IIF(agenttype = "AgentType1", Sum(all agent totals
for policy 1), "")

Am I heading in the right direction ?

Any tips or hints would be greatly appreciated.

Sincerely,
Bernard Ong

View 1 Replies View Related

SSRS 2000 SP2 Failure Sending Email

Sep 29, 2006

I am getting this error when sending an excel file via email.

Failure sending mail: The Report Server has encountered a configuration error; more details in the log files

The scheduled job which emails an excel spreadsheet has been working and now it doesn't. I've done some research and this KB article is close to the error that I'm seeing however the win 32 error 87 is different. http://support.microsoft.com/?kbid=842423

Has anyone any idea's? I have not applied the hotfix for SSRS 2000 sp2.

Log file has this.

ReportingServicesService!library!7b4!09/28/2006-15:00:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!7b4!09/28/2006-15:00:08:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!7b4!09/28/2006-15:00:08:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved