SQL Reporting :: Multiple SSRS Servers Share One DB?

Mar 17, 2010

Can multiple SSRS share the same DB? We're getting into an SSRS customization scenario, which may adversely affect our existing SSRS features, and I wanted to see if it was possible.

View 1 Replies


Similar Messages:

C# - Is Possible To Share HttpRuntime.Cache Between Multiple Web Servers

Nov 10, 2010

We have a web application that is storiing all site data in HttpRuntime.Cache. We now need to deploy the application across 2 load balanced web servers. This being the case, each web server will have its own cache, which is not ideal because if a user requests data from webserver1 it will be cached, but there next request might go to webserver2, and the data that their previous request cached won't be available. Is it possible to use a shared-cache provider to share the HttpRuntime.Cache between the two web servers or to replecate the cache between them, so that the same cache will be available on both web servers?

View 4 Replies

C# - Amazon EC2 Multiple Servers Share Session State

Mar 12, 2010

I have a bunch of EC2 servers that are load balanced. Some of the servers are not sharing session, and users keep getting logged in and out. How can I make all the server share the one session, possibly even using a partitionresolver solution

public class PartitionResolver : System.Web.IPartitionResolver
{
private String[] partitions;
public void Initialize()
{
// create the partition connection string table
// web1, web2
partitions = new String[] { "192.168.1.1" };
}

public String ResolvePartition(Object key)
{
String oHost = System.Web.HttpContext.Current.Request.Url.Host.ToLower().Trim();
if (oHost.StartsWith("10.0.0") || oHost.Equals("localhost"))
return "tcpip=127.0.0.1:42424";
String sid = (String)key;
// hash the incoming session ID into
// one of the available partitions
Int32 partitionID = Math.Abs(sid.GetHashCode()) % partitions.Length;
return ("tcpip=" + partitions[partitionID] + ":42424");
}
}

View 1 Replies

SQL Reporting :: Generate Multiple Pdf Files In Ssrs?

Jun 28, 2010

i need to generate multiple pdf files based on input parameters using ssrs. Suppose there are 1000 branches then it should generate 1000 pdf files one for each branch data. how can i achieve this using Sql Server 2005 and .net framework 1.1 or 3.5.

View 4 Replies

SQL Reporting :: Can't SSRS 2008 Handle Stored Procedures Which Return Multiple Tables

Oct 13, 2010

I tried it and it only returns the first table.

View 2 Replies

SQL Reporting :: Convert .rdl Files From Ssrs 2000 To Ssrs 2005?

Nov 10, 2010

I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.

I have installed BIDS 2005 and have opened the project in BIDS 2005.

When i open any file individually I get about 200 error messages.

Does anyone know what I need to do to convert the .rdl files to SSRS 2005?

View 2 Replies

C# - Share A Hash Key Between Servers For Web.config?

Feb 2, 2010

Is there a way of creating a hash key that can be used by our different servers for decrypting connection strings in web.config, and how would I do that?

View 1 Replies

SQL Reporting :: SSRS Reporting Services When Expanding A Drill Down Row - It Becomes Very Long

Aug 9, 2010

I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.

View 2 Replies

SQL Reporting :: How To Have Different Footer In SSRS

May 18, 2010

I am doing a SSRS report to generate some kind of print outs.

I need to have different footers inside the whole print out.

e.g. After first several pages I need to use page number as page footer( this can be easily done). but after that i need have footers as Annex A -1, Annex A-2, or Annex B -1 , Annex C - 1, when the page is Annex A, Annex B...etc.

View 8 Replies

SQL Reporting :: Multi Language In SSRS?

Apr 10, 2010

I'm a software manager that want to select a Reporting engine and develop international application , i want to know Dose SSRS support multi-languages environments(Special in Report Builder for end users) or not ?

View 1 Replies

SQL Reporting :: SSRS XML Export - How To Remove The BOM

Jul 21, 2010

I use SSRS to generate an XML file using XSLT. All is fine, except that the XML file starts with the letters 'EF BB BF' which I need to get rid of. How do I generate an XML file without it?

View 3 Replies

SQL Reporting :: Restrict Access To SSRS?

Mar 29, 2011

I need a reliable method to switch off users' access to SSRS dynamically. If you care about the reason, users are not allowed to access SSRS from home, but they are allowed access from within the factory walls.

I can generate a token or event when they arrive at work or leave, no problem, such is the sophistication of our security system.

So I can create a little .net app that pokes SSRS in some way and tells SSRS to allow that username to access reports. When the users leaves the premises, the .net app will prod SSRS to deny that username access.

I considered dynamically adding and removing usernames from the authentication section of web.config in the SSRS root dir, as in <deny=usernamelist />. But given the frequency of changes (dozens per hour at peak times), that seems too intrusive, as it probably causes the restart of the app.

I tried adding usernames to the ACL on the SSRS physical directory (Microsoft SQL ServerMSSQL.2Reporting ServicesReportServer) as deny reader, and for a few brief minutes I thought I had arrived at a solution, but for some reason SSRS decided to serve pages to denied users seemingly at random. Must be cached somewhere, although I can't for the life of me figure out why that would be happening seemingly at random.

I rather like the ACL idea from the perspective of ease of control, and if there's a simple thing i have overlooked in the way SSRS interacts with IIS and NTFS permissions, I hope someone can point it out so I can understand why the ACL seems to be mostly ignored.

View 1 Replies

SQL Reporting :: Textbox_textchanged Event In SSRS?

Jan 25, 2010

I have SSRS report and have customized the toolbar with textbox. User can enter the report page number and can press enter so that report will generate with report number. I have made autopostback=true to the textbox and below is my code in textbox_textchanged event

[Code]....

Suppose if I enter 2 in textbox and then press enter,it is not firing and if i press enter second time it is working. From page 2 if i enter 1 in textbox and press enter also it is not working.

View 3 Replies

SQL Reporting :: Installing SSRS On Windows7?

Jul 1, 2010

I am using windows7 OS.How to install sql server reporting services.

First of all is it supported on windows 7

View 2 Replies

C# - Multiple Asp Requests From Multiple Clients Share Information?

Dec 9, 2010

Imagine a website where individual clients can see each-other's presence - like a social network or a chatroom.

For example:

Client1 connects to my website.The back-end C# code updates a static field to indicate Client1's presence.
Client2 connects to my website.Will the back-end C# code for the second request see the information stored in the static field from the first request? Is there anything I need to do to guarantee that these seperate instances of my ASP application are sharing static data?

View 4 Replies

SQL Reporting :: Calling Ssrs Report From Application?

Apr 26, 2010

I am new to SSRS report. I designed the report in BIDS and deployed it on the server. Now I have to use that report in my web application.

how do I do that using VB.NET.

The report path looks like this,

[URL]

View 5 Replies

SQL Reporting :: Make SSRS Reports Available Through ReportViewer

Dec 29, 2010

I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.

1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?

View 2 Replies

SQL Reporting :: SSRS Date Format In Parameters?

Oct 27, 2010

Can we change the date format in the default parameters pane.(For eg : When we create a new parameter and select datatype as date time in report parameters.)

Default settings for this date picker control is mm/dd/yyyy.

I need to change the date to dd/mm/yyyy.

Is it possible to the change this date format to dd/mm/yyyy or any other custom format?

View 2 Replies

SQL Reporting :: How To Convert An Old Html Report To SSRS

Dec 17, 2010

I need to convert an old html report to SSRS . The current report uses two datasets- one is a parent table that is iterated through to pull a data key; the report then pulls an array based upon the key and displays the associated records. Is there any simple way to do this in SSRS?

View 1 Replies

SQL Reporting :: Forms Authentication With SSRS 2005 / IIS 6?

Jun 21, 2010

Has anyone successfully implemented forms authentication with SSRS? It seems like a lot of the documentation out there is just wrong or doesn't indicate which version of IIS / SSRS is being used.

View 1 Replies

SQL Reporting :: Multivalue Parameter In SSRS 2005

Jan 19, 2011

my qyery is Select * from UserTable .

i set my parameter as @UserId,checked multivalue check box.

in Available values-from query-i set my value and label field.

default value is null.

when i click the preview tab,multiple UserId with check box appear in drop down list...

when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...

View 3 Replies

SQL Reporting :: How To Schedule SSRS Report From SharePoint

Sep 4, 2010

I don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty.

Technology

- SQL Server 2008 R2
- SharePoint 2010

View 2 Replies

SQL Reporting :: Public Access To SSRS Reports?

Sep 21, 2010

I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.

View 3 Replies

SQL Reporting :: Way To Filter On Group In Ssrs 2005

Dec 22, 2010

I am desinging the report in ssrs 2005.I used table control to display data.I have three columns col1,col2 and col3.Col2 and col3 are grouped on Col1 where as Col1 is monthend_dateMy result should be like this

View 1 Replies

SQL Reporting :: SSRS Print On Client Machines?

Oct 15, 2010

Initially after deploying SSRS 2005 report on server, the client machine could not avail print functionality because of the error "Unable to load client print control". Inspite of allowing ActiveX installation, the print functionality was not working. Googling on this issue I found that rsclientprint.dll needs to be registered in C:Windowssystem32.successfully registering this dll, print functionality started working on some machines. However on some machines it started giving the error 'Error loading resource library.(0x8007007E)'.

View 1 Replies







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