w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Showing rtf data in SQL SERVER Reporting Services (SSRS)
That function looks like it should convert rtf to plain text fine. It's not possible your input data was accidentally "double converted" to rtf, i.e. the input to your function was { tf1ansiansicpg1252uc1 {\rtf1\ansi\ansicpg1252\uc1 aaa}} is it? If not please provide the input to the function for comparison.

Categories : C#

How to dynamically specify database credentials with Azure Reporting Services (SSRS)
You can use this solution if you are able to create a general purpose "ReportUser" windows account on your server and give this account viewer access to your reports. You can get around this by adding two parameters to your report. 1. @DatabaseServerName 2. @DatabaseName Then in your report data source set the connection expression to: ="Data Source="+Parameters!DatabaseServerName.Value+";Initial Catalog="&Parameters!DatabaseName.Value When developing the reports you should add a TEST data source to the report that points to a valid development endpoint then prior to deployment to your production server set all the datasets to point back to the data source using the expression above. In order for this to work you will need to create a "ReportUser" account on your production ser

Categories : Azure

How to resolve Microsoft Reporting Services error: rsCredentialsNotSpecified
Open Reporting Services Configuration Manager click Report Manager URL tab, browse to the URL specified open the applications data manager section specify credentials for the report server to use

Categories : Sql Server

Improving Column Grouping Speed in Microsoft Reporting Services
Check to make sure you are sorting on the report side as opposed to the query side. This can speed things up. Sorting groups or sorting by aggregate values is much simpler in the report than in the query and is frequently more efficient also. Take a look at these tips for speeding up performance. Troubleshooting Reports: Report Performance

Categories : Reporting Services

Using SSRS reporting services how to programmatically read subscription last run time and next send time
I can tell you how to find last run time, but not next run time: One way you can do this is to utilize a SQL query against the Report Server database. In the Report Server, you can query the "Subscriptions" table. There is a column in there for "Last Run Time." Run the query below against the SQL Report Server database to see what I am talking about. You can utilize the value in the "Last Run Time" column. /****** Script for SelectTopNRows command from SSMS ******/ SELECT [SubscriptionID] ,[OwnerID] ,[Report_OID] ,[Locale] ,[InactiveFlags] ,[ExtensionSettings] ,[ModifiedByID] ,[ModifiedDate] ,[Description] ,[LastStatus] ,[EventType] ,[MatchData] ,[LastRunTime] ,[Parameters] ,[DataSettings]

Categories : Reporting Services

SQL Server Compact Edition and reporting. Is SSRS an option?
You can use the standalone Reporting Services ReportViewer control with a DataSet from a SQL Server Compact database file, that runs completely locally and does not require any SQL Server installtion. I do that in my SQL Server Compact Toolbox, with code similar to this (full source available at http://sqlcetoolbox.codeplex.com ) : public partial class ReportGrid : UserControl { public ReportGrid() { InitializeComponent(); } public DataSet DataSet { get; set; } public string TableName { get; set; } private void ReportGrid_Load(object sender, EventArgs e) { if (DataSet != null) { DataSet.DataSetName = TableName; Stream rdlc = RdlcHelper.BuildRDLCStream( DataSet, TableName); reportV

Categories : Reporting Services

SQL Server Reporting Services Authentication
Few things: Check to see that Report Server config file has RSWindowsNegotiate in authentication before NTLM setting. Enable identity impersonation. Set server principal names and kerberos authentication if both the servers are not able to communicate

Categories : Dotnet

Layout design in SQL Server Reporting Services
Place the tables in Rectangle objects, then set the visibility for the Rectangles, not the tables themselves. If the Rectangle is slightly longer than the tables, and all the Rectangles are immediately adjacent, there will be whitespace in the Rectangles which will disappear when the Rectangles are hidden. This way you will have the same behaviour but better control of the gaps that were created when you just hide individual items.

Categories : Visual Studio 2012

SQL Server Reporting Services Calendar-like Report
I worked out another solution that satisfied the requirements laid out by my superiors. The short of it: I created a simple HTML calendar populated with the events. I then render the page as an image (like a screenshot) and use the Image Control in SSRS to load it. The SSRS report passes its parameters to the webpage as a query string. For the curious who find this question through web searches, here's the method I use to create the bitmap: private Bitmap CreateScreenshot(string url, int width, int height) { Bitmap screenshot = null; var thread = new Thread(() => { using (var browser = new WebBrowser()) { browser.ScrollBarsEnabled = false; browser.ScriptErrorsSuppressed = true;

Categories : Reporting Services

How to prevent proxy timeouts with SQL Server Reporting Services
A few things: A. For SSRS overall on it's service: I personally use a keep alive service as I believe the default recycle is 12 hours for SSRS server. I use a tool someone turned me onto called 'VisualCron' that can do many task processes automatically. You can also just make a call in a WCF service or similar to. Basically I know the first report from a user for the day is generally slow. Usually you need to hit http:// (servername)/ReportServer to keep it alive. B. For cachine report level items: If this does not help I would suggest possibly caching DataSets when possible. Some people have data that is up to the moment but for a lot of people that is not the case. You may create a shared dataset in SSRS and then cache that on a schedule. So if you have domain like tables that

Categories : Asp Net

SQL Server Reporting Services 3.0 - default sort by count
What you need to do is define the scope of your aggregate. The format will look like this: =SUM(Fields!AD_CN.Value, "YourGroupName") Make sure you use the name of the group that you want the counts to be sorted by. You can see the groups at the bottom section of the window. It is helpful to rename them so that they are easy to identify. It's also best to name them before you write the expression, because the expressions don't update if you rename them later on.

Categories : Reporting Services

Formatting a parameter within an expression in SQL Server Reporting Services
Have you tried configuring to use another style sheet as in the following tutorial? http://www.wiseowl.co.uk/blog/s296/css-parameters.htm Then style .TotalPatientCntInPractice.Label from there... Hope it helps...

Categories : Reporting Services

SQL Server Reporting Services 2008 R2 - Folder and Report Security
You can query the ReportServer database for this information, e.g. SELECT CASE [Catalog].[Type] WHEN 1 THEN 'Folder' WHEN 2 THEN 'Report' WHEN 3 THEN 'Resource' WHEN 4 THEN 'Linked Report' WHEN 5 THEN 'Data Source' WHEN 6 THEN 'Report Model' WHEN 8 THEN 'Shared Dataset' WHEN 9 THEN 'Report Part' END AS CatalogType, [Catalog].[Type] --, [Catalog].ItemID ,[Catalog].Name , Roles.RoleName , Users.UserName FROM PolicyUserRole INNER JOIN Roles ON PolicyUserRole.RoleID = Roles.RoleID INNER JOIN Policies ON PolicyUserRole.PolicyID = Policies.PolicyID INNER JOIN Users ON PolicyUserRole.UserID = Users.UserID INNER JOIN [Catalog] ON PolicyUserRole.PolicyID = [Catalog].PolicyID ORDER BY 1 ,

Categories : SQL

SQL Server Reporting Services: Cell Value Not Repeating when using table/matrix wizard
As you've seen, SSRS treats row header cells differently, i.e. stretching them over any child groups. Your report probably looks a bit like this: I've highlighted the dotted lines that separate the report areas. This example report has the same issue as your example: To get around this, the various row group values need to be moved from the row header area to the main report area. First, delete the left four rows - when prompted choose Delete columns only. You should only have the Skill column remaining. Right click and Insert Column -> Outside Group - Left. Keep adding columns using Insert Column - Left. Once you have enough new columns, add the various grouping values. The report should look something like this: Note that there are now no dotted lines between the Ski

Categories : Reporting Services

Connecting Postgres ODBC to SQL Server Reporting Services/Data Tools/Report Builder
It is a bit ago that I worked with SSRS. But if I remember correctly you just have to add a connection as described in Step 7. You do not need a linked Server to query data from an other sources. Do you get the same error while creating a new data source in SSRS?

Categories : Sql Server

Exposing Sql Server Reporting Services 2008 R2 over Extranet while integrating with Java web application with LDAP authentication
Option 1 Call Reporting Services (RS) Web service from your Java App. Your app could be on LDAP Auth but your RS instance could continue to be on Windows Auth, You need to generate Windows Auth using Java App while calling RS web service. You can generate disconnected report in HTML and show it to end users. In this case, Your RS would never be exposed to end users and communication between users and Reports would happen via your app. You would loose some additional features of RS like on demand rendering etc. Option 2 Have your Reporting Services(RS) setup on Custom Authentication using your own authentication extension. Your java app would authenticate the user using LDAP Auth and pass the authentication cookie/token to Reporting Services using URL access or SOAP APIs. This is for

Categories : Java

SSRS must Excel be installed on Reporting server to use Excel as a Data SOURCE?
No, you don't have to install Excel. The MS Business Intelligence Development Studio (ie. Visual Studio) is 32-bit and you need 32-bit ODBC drivers for report development. I'll assume your Report Server is 64-bit, so you'll need 64-bit drivers for that. You can download both of the drivers here: Microsoft Access Database Engine 2010 Redistributable Took me a long time to figure out how to cope with 32-bit editor and 64-bit server, but here's the deal: Install the 64-bit drivers first Go to Administrative Tools -> Data Sources (ODBC) Add a new data source (you can mention in the description that this is the 64-bit data source) Install the 32-bit drivers second Run C:WindowsSysWoW64Odbcad32.exe as administrator Add a new data source (you can mention in the description that this is the 32

Categories : Excel

wso2 data services server - cluster node and domain
Your assumption is correct. The WSO2 Elastic Load Balancer wiki has a lot more information on clustering. See here for more information.

Categories : Misc

How to add an administrator user of sql server analysis services 2008 R2 after the install?
You need to connect to the analysis services instance using SQL server management studio (make sure you use the analysis services option on the connection dialog) as a user that already has administrative permissions on the SSAS instance (it should have asked for a user/group when you installed SSAS) Then once you are connected, right click on the server, select properties, then security. You can then add more users or groups to the server administrator role from here.

Categories : Sql Server

WebDAV Server Error 401.2, connection issue with Windows Authentication after pausing virtual server/domain controller
We figured out what was causing our issue although I may not be able to explain entirely why it mattered. In IIS there is a setting in the "HTTP Response Headers" under "Set Common Headers" called "Enable HTTP keep-alive". We check marked this option as true and our Windows Authentication started working again. It seemed to have something to do with the connection not staying open between requests and the application or IIS not realizing the connection was restarted during the SYNC operation.

Categories : Iis

Using MS SSRS for enterprise reporting
There is a HTML-based website that comes with SSRS that allows you to select reports at http://ServerName/Reports. It will allow you to select a report, enter the parameters then run the reports and then select output options - print, Excel, PDF, etc. There is also the Report Viewer control for WinForms.

Categories : Reporting Services

SSRS Reporting multi value parameters
Assuming your parameter name is MyParameter, in report designer (BIDS) just drop a textbox onto report below the data (e.g. Table) and put following expression into its value's formula: =Parameters!MyParameter.Value.Split(",")(Parameters!MyParameter.Value.Split(",").Length - 1) it will split the parameter list and grab the last value Update: here is the screenshot with steps: And here is the runtime result

Categories : Reporting Services

SSRS vs Azure SQL Reporting - Cost and Implementation
EDIT 2015-07-21: Windows Azure SQL Reporting was discontinued by Microsoft on October 31, 2014 - the original answer contained links to Azure SQL Reporting documentation that no longer works and have been removed Subscriptions and scheduling are not supported by Azure SQL Reporting, so you would have to set up SSRS somewhere. On-premise or Azure-hosted VM depends on a lot of factors such as your budget, on-premise infrastucture capacity, overall cloud strategy of your organisation. You need to be more specific - the cost of licensing what? Azure SQL Reporting? Virtual Machines? SQL Server licensing? This article should get you started with app integration for SSRS: Integrating Reporting Services into Applications

Categories : Azure

SSRS Reporting with Date ranges are optional
You can check the date parameters for NULL and use them if only both of them are valid: AND (@DateFrom IS NULL OR @DateTo IS NULL OR W.CommunicationStartDate BETWEEN @DateFrom AND @DateTo)

Categories : SQL

Microsoft.Reporting does not exists in namespace
You need to install Microsoft Report Viewer to have its assemblies available in Visual Studio. You can bring it from: http://www.microsoft.com/en-us/download/details.aspx?id=6442

Categories : C#

Cannot access the the SSRS report through Reporting Action in the SSAS cube
It looks like you are running in SharePoint integrated mode. Your configuration should look something like this: Server name: devport.com Report path: /_vti_bin/reportserver?http://devport1.com/reportlibrary/sales/report.rdl There is a good article on msdn about URL Access for SSRS in both standalone mode and in SharePoint integrated mode.

Categories : Excel

Problems with Reporting Services
This looks like permission or UAC error to me. By default, BUILTINAdministrators or the local admin group on computer would have content manager role on RS. If you are already part of this group and you still see the error, You need to right click on your IE's icon and "Run as Administrator" before you try to browse the Report Server URL which throws the error. For Report Manager URL, if its greyed out, URL reservation for Report Manager is not done. See if Apply button is enabled, If it is, Clicking on the Apply button under Report Manager tab should take care of it.

Categories : Reporting Services

LocalReports in C# causing Microsoft.Reporting.WinForms.LocalProcessingException
Create a custom class to bind your data to. public class MyReportClass { public int ID {get;set;} public string Name {get;set;} } Then populate the class using a DataReader //snippet MySqlDataReader reader = cmd.ExecuteReader(); // add to collection List<MyReportClass> myReportClassCollection = new List<MyReportClass.(); while (reader.Read()) { // populate entity var myReportClass = new MyReportClass(); // set properties, skipping DBNull checking for quickness myReportClass.ID = (int)reader["ID"]; myReportClass.Name = (string) reader["Name"]; myReportClassCollection.Add(myReportClass); } ReportViewer viewer = new ReportViewer(); viewer.ProcessingMode = ProcessingMode.Local; viewer.LocalReport.ReportPath = "C:\VS\TestReports\TestReports\Report1.rdlc"; v

Categories : C#

Reporting Services using Entity Framework
public void getMyReportData() { using (myEntityDataModel v = new myEntityDataModel()) { var reportQuery = (from r in v.myTable select new { l.ID, l.LeaveApplicationDate, l.EmployeeNumber, l.EmployeeName, l.StartDate, l.Col1, l.Col2, ......., ......., l.Address }).ToList(); reportViewer1.LocalReport.DataSources.Clear();

Categories : Entity Framework

Reporting services expression for default value
I'm pretty sure you can just rewrite the above as: =IIf(Month(Today) > 3, Year(Today), Year(DateAdd(DateInterval.Year, -1, Today))) i.e. If Today is in April to December, use the current year, else use the previous year.

Categories : Reporting Services

Is there any rest api for sql reporting services in azure?
I would recommend you to examine an example Windows Azure SQL Reporting ReportViewer-SOAP API usage sample http://code.msdn.microsoft.com/windowsazure/Windows-Azure-SQL-1cfc2d7e

Categories : Azure

Date format on reporting services
There are a few things you can do: You can try changing the Language on your report files (Properties - Location - Language) to match the same language on the database. When you pass a parameter to a query, instead of using the parameter value, pass it as an expression like this: =Format(Parameters!Date.Value,"yyyyMMdd") which will convert it to a date format which will be accepted by any language setting on the database.

Categories : Sql Server

Reporting Services (.RDLC) Two Datasets
To update datasets in a report definition 1.Open the client report definition (.rdlc) file in Visual Studio Report Designer. 2.From the View menu, select Report Data. The Report Data window appears. Then To add a new dataset to the report definition, in the Report Data window's toolbar, select New, and then select Dataset. 3. Click Refresh to update the report definition file with your changes.

Categories : C#

Reporting Services - concatenate string and parameter
If the parameter is passed as a year string: and o2.period_end_date < date (? || '-01-01')) If it is a date: and o2.period_end_date < date_trunc('year', ?) If it is a year number: and o2.period_end_date < date (?::text || '-01-01'))

Categories : Postgresql

How to implement user impersonation in reporting services?
I never worked with services you have mentioned but I hope, following stuff will help you in some way. I used kernal32.dll and advapi32.dll to impersonate user as under: Imports System.Security.Principal Imports System.Runtime.InteropServices Public Class UserImpersonation <DllImport("advapi32.dll")> _ Public Shared Function LogonUserA(ByVal lpszUserName As [String], ByVal lpszDomain As [String], ByVal lpszPassword As [String], ByVal dwLogonType As Integer, ByVal dwLogonProvider As Integer, ByRef phToken As IntPtr) As Integer End Function <DllImport("advapi32.dll", CharSet:=CharSet.Auto, SetLastError:=True)> _ Public Shared Function DuplicateToken(ByVal hToken As IntPtr, ByVal impersonationLevel As Integer, ByRef hNewToken As IntPtr) As Integer End Function <DllImport("

Categories : C#

Multiple X-Axis for Chart In Reporting Services
Assuming you have two series in your Chart for the bar and line values you're displaying: You need to set the Value axis for each of these Series: If you set one Series to a Primary Value axis and the other to a Secondary Value axis you will get a left and right axis as above and hopefully each Series will have one axis correctly set. Based on your description you should set up one Category group as appropriate and make sure both Series have the same Category axis value set.

Categories : Sql Server

Reporting errors from the application services layer
I think these are business constraint brokens that cannot be recovered. My current solution is Exception hierachy. public abstract class UncheckedApplicationException extends RuntimeException { //omitted factory methods and constructors public abstract String getStatusCode(); public abstract String getI18nCode();//ignore this if you don't need i18n public abstract String[] getI18nArgs();//ignore this if you don't need i18n } Any custom exception extends this one. I think this could avoid code like this: try { //invoke your application service } catch (InsufficientInventoryException e) { statusCode = INSUFFICIENT_INVENTORY; } catch (ExpriedPriceException e) { statusCode = EXPIRED_PRICE; } catch (NoSuchProductException e) { statusCo

Categories : Spring

Reporting services 2008 textbox labels
I don't think you can change this - it's by design in SSRS 2008. I would say the reasoning behind it is that you can now have multiple placeholders in one Textbox and it's easier to represent with multiple <<Expr>> values: For text and basic field values, these will not have <<Expr>> displayed. If you change basic text from ="Hello" to just Hello that's what will be displayed in the designer: And an expression like =Fields!val1.Value will be displayed like this in the designer: It's jarring at first but you get used to it.

Categories : Reporting Services

Reporting services instance properties disabled
I would check that the user running SSMS above has the report server System Administrator role. Check this in Report Manager under Site Settings -> Security. The other thing to note is that by default only the BUILTINAdministrators group has this role. If you have UAC enabled this can cause issues; if you think you are already in this group you have to make sure you're loading SSMS with Run as Administrator to prevent any UAC restrictions.

Categories : Reporting Services

SS Reporting Services Quarterly Schedule instead running Monthly
I think the problem (and solution) is the same as described here http://blogs.technet.com/b/dpm/archive/2012/09/24/support-tip-scheduled-backup-to-tape-runs-on-a-wrong-date-on-dpm-2007-2010-and-2012.aspx

Categories : Reporting Services



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.