DotNetShoutout

SSRS

7
Shouts

Shout it

Extracting Images from SSRS reports

published 847 days, 15 hours, 45 minutes ago posted by

dhara 848 days, 3 hours, 44 minutes ago

What do you do when you want to re-use an image in one of those old forgotten reports that was developed by that weird guy who left your company an year ago? No matter how much you hate or abuse that guy now, it is not going to do you any good as he didn’t save those images in a source or version control... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, MSBI, TSQL, BI, SSRS

5
Shouts

Shout it

Create clock in SSRS using Gauge and AutoRefresh Property

posted by

dhara 854 days, 21 hours, 19 minutes ago

In SSRS, there is a report level property AutoRefresh. If we set this value, report will automatically refreshed after specified number of seconds in HTML rendering. The value for the AutoRefresh element must be between 0 and 2147483647. When I was writing... (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, TSQL, SSRS

5
Shouts

Shout it

String Concatenation/Aggregation in SSRS column or row group

published 855 days, 14 hours, 50 minutes ago posted by

dhara 856 days, 3 hours, 13 minutes ago

Sometimes, we need aggregate strings only in SSRS designer. In situations, when we are using Report Model as data source this is very much needed. There are many Aggregation functions available in SSRS, but to implement string concatenation/aggregation... (more)

category: Data | clicked: 5 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, SSRS

6
Shouts

Shout it

Conditional Navigation in SSRS

published 877 days, 6 hours, 13 minutes ago posted by

dhara 878 days, 1 hour, 24 minutes ago

Why do people write blogs or help other people in the technical forums? This was a frequent question that I used to ask to people around me. For some reason or the other, I couldn't fathom why people would want to spend their personal times on such... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, MSBI, TSQL, SSRS

6
Shouts

Shout it

KeepTogether Tablix Property - Chintak's Blog

published 882 days, 11 hours, 39 minutes ago posted by

dhara 883 days, 3 hours, 19 minutes ago

KeepTogether Tablix Property Setting should be used with care. This can cause whole report to load in single page and your report builder or web application (Reportviewer Control) can become very very slow in rendering. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, SSRS

5
Shouts

Shout it

Welcome to IT Funda Corporation: Webcast on SSIS, SSAS and SSRS (Hands on)

published 903 days, 20 hours, 2 minutes ago posted by

dotnetfunda 904 days, 5 hours, 17 minutes ago

We are happy to organize our another free webcast for our Corporate customers on "SSIS, SSAS and SSRS (Hands on)" where our expert would describe about SSIS, SSAS, SSRS and will show a complicated demo of SSIS. The agenda of the webcast is What is SSIS , SSAS and SSRS ? How does ETL fit in to SSIS ? Same demo of SSIS. Complicated demo of SSIS. Feel free to send this request to your developer friends so that community can be benefited. (more)

category: Podcast | clicked: 3 | comment | | source: www.itfundacorporation.com

tags: SSRS

9
Shouts

Shout it

Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

published 985 days, 16 hours, 14 minutes ago posted by

dhara 987 days, 4 hours, 16 minutes ago

Around 6 months ago, I was desperately looking for some online resources to help me implement some map reports. The shapefile I was dealing with was at a very granular level (which means that it had a lot of data, 2.5 MB in size), and we needed to do some custom aggregations on the spatial data. As the custom aggregations were done at report run time, it turned out to be a major performance bottleneck. (more)

category: Data | clicked: 1 | 3 comments | | source: beyondrelational.com

tags: SQL Server, MSBI, BI, SSRS

4
Shouts

Shout it

Generating and exporting SSRS reports programatically using Report Viewer Control

published 1042 days, 21 hours, 9 minutes ago posted by

jacobsebastian 1044 days, 2 hours, 9 minutes ago

This post demonstrates how to generate SSRS reports programatically from an ASP.NET web page using Report Viewer control. (more)

category: Web Dev | clicked: 5 | comment | | source: beyondrelational.com

tags: SQL Server, Reporting, SSRS

4
Shouts

Shout it

Aggregate of an aggregate function in SSRS - Some Random Thoughts

published 1049 days, 20 hours ago posted by

jacobsebastian 1050 days, 6 hours, 39 minutes ago

I am worse than a child when it comes to colours and no wonder, spend a lot of time on the aesthetics whenever I am preparing an Excel sheet or a PowerPoint presentation. For me, this is rather a way to indulge the child within me than to make it more presentable to the audience. The joy that you get when you arrive on that perfect colour for your headers or that perfect font to suit the mood or that perfect design template for your slides is something that can’t be expressed. Recently, I was preparing t... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: Reporting, Tips and Tricks, SQLServer, SSRS

5
Shouts

Shout it

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

published 1077 days, 23 hours, 26 minutes ago posted by

jacobsebastian 1078 days, 23 hours, 13 minutes ago

beyondrelational.comSign in | Join | Help HomeBlogsForumsBIXMLTCSQL Tools Visit the new SQL Server Tools and Utilities section and see the products that can make your database administration and development lives easier! First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. Some Random ThoughtsHomeContactRSS for PostsRecent Blog PostsCalculat... (more)

category: Data | clicked: 0 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Reporting Services, SSRS, Custom Functions

6
Shouts

Shout it

Display Total on top of Stacked Chart - Some Random Thoughts

published 1084 days, 19 hours, 29 minutes ago posted by

jacobsebastian 1085 days, 3 hours, 20 minutes ago

It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog readers sent me a mail asking how to display the total on top of a stacked chart in SSRS. The first time I read it, I was almost going to blurt - just enable some property to display subtotals. But the more I thought about it, the more elusive the property became and that is when I realized there is no such property. So for the benefit of all, I thought about posting the workaround that ... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

4
Shouts

Shout it

Visual Studio 2010 Report Designer doesn’t support SSRS 2005 format « Ahmed Elbaz's Blog

posted by

AhmedElbaz 1133 days, 11 hours, 41 minutes ago

Visual Studio 2010 Report Designer doesn’t support RDLC reports which are created in SQL Server Reporting Service 2005 format (more)

category: Web Dev | clicked: 2 | comment | | source: ahmedelbaz.com

| flag as spam

tags: Visual Studio 2010, RDLC, SSRS, Report Designer

4
Shouts

Shout it

SSRS Weekday EMail Subcription

published 1132 days, 19 hours, 34 minutes ago posted by

MarlonRibunal 1133 days, 17 hours, 18 minutes ago

SSRS Weekday EMail SubcriptionApril 16, 2010tags: email subscription, Reporting Services, SSRS, weekday intervalby MarlonRibunal One of the most useful features of SQL Server Reporting Services is EMail Subscription. Managers want their critical reports delivered to them via email for one reason: convenience. They want daily reports delivered to them first thing in the morning. Some want the daily frequency for some other reasons. What is common among these guys is that they don’t want to receive these ... (more)

category: Data | clicked: 1 | comment | | source: dbalink.wordpress.com

tags: Reporting Services, schedule report, email subscription, SSRS

3
Shouts

Shout it

Fix to Report viewer problems in IIS 7 or later

posted by

Praveen 1166 days, 51 minutes ago

When we migrate web applications from IIS 6 to IIS 7 or IIS 7.5, we will face some problems in http handlers, mappings etc. I faced some problems with reportviewer control. So, below are all problems I have faced and solutions to them. And one more thing is, the server to which we migrated the application may or may not have all the report viewer dlls available in the system. If they didn't install then we need to install them. Otherwise you will get compilation error as we are using that in our applicat... (more)

category: Web Dev | clicked: 2 | comment | | source: praveenbattula.blogspot.com

| flag as spam

tags: IIS7, ReportViewer, SSRS

3
Shouts

Shout it

Sql Server Reporting services 2008 Tablix control

published 1174 days, 17 hours, 40 minutes ago posted by

Praveen 1175 days, 15 hours, 42 minutes ago

When working with Sql server 2008 reporting services I found a new control named Tablix. [Of course there are plenty of new features] This is a mix of both Table and a Matrix. The main and great advantage of it is when we drag a table or matrix to the report body you can't find table or matrix any more. The report control automatically convert it to Tablix. Now, it's very easy to show the complex and grouping of data with this control. The interest thing in 2008 reporting services is, When I open report... (more)

category: Data | clicked: 1 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server 2008, Tablix, SSRS

4
Shouts

Shout it

How to give anonymous access to the reports.

published 1204 days, 22 hours, 23 minutes ago posted by

Praveen 1206 days, 22 hours, 37 minutes ago

Give anonymous access to the Application. Go to IIS. Select reports application –> properties –> Directory Security –> Authentication and Access control –> Edit –> Enable Anonymous access Give anonymous access to a report. Open the reports on the report server located at http://servername/reports Browse to the report that needs to be accessed anonymously. Select properties tab for the report. Select security from the left navigation. Select New Role Assignment from this... (more)

category: Data | clicked: 1 | comment | | source: praveenbattula.blogspot.com

tags: Anonymous access, IIS, SSRS, SQL Server Reporting Services

3
Shouts

Shout it

SSRS Reports get Month name from Month Index or from date

posted by

Praveen 1207 days, 11 hours, 20 minutes ago

This is one of the small tips which I want to tell my readers. When you work with SSRS reports, you may come across with the requirement like, you know the index of the month, but you want to print month name from it. So, if that is the situation for you, this is the right post for you. :) MonthName(monthindex) You may get it from t-SQL as I mentioned in my previous post here. But in SSRS reports the way you need to approach is like this. Take a textbox to report body.Write the below syntax into it ... (more)

category: Data | clicked: 2 | comment | | source: praveenbattula.blogspot.com

| flag as spam

tags: SQL Reporting Services, Month, SSRS

3
Shouts

Shout it

Sql Server reporting services and forms authentication - Part1

posted by

Praveen 1221 days, 4 hours, 19 minutes ago

Till now, I know Sql Server reporting services supports only Windows authentication. And of course till now What I did for all clients is the same. The roles or access everything will define using the default report manager site and deploy that on the client environment. But, the current project I am working on is completely different and the main requirement is enabling forms authentication in the sql server reporting services. The story behind is, the client is running different applications based on t... (more)

category: Data | clicked: 2 | 1 comment | | source: praveenbattula.blogspot.com

| flag as spam

tags: Forms Authentication, SSRS, SQL Server Reporting Services

3
Shouts

Shout it

Sql Server Reporting services and forms authentication – Part2 - How to implement?

posted by

Praveen 1221 days, 17 hours, 16 minutes ago

Before continue this post, please read the post understanding the concept forms authentication in sql reports – Part1. The implementation of the process is so simple.Microsoft team already given a sample application which has the forms authentication enabled. They have written some code which has a security extension with login pages. To understand it well or to implement just do this. Go here and download the sql server samples from Codeplex. http://www.codeplex.com/SqlServerSamples/Release/ProjectRelea... (more)

category: Data | clicked: 2 | comment | | source: praveenbattula.blogspot.com

| flag as spam

tags: Forms Authentication, SSRS, SQL Server Reporting Services

5
Shouts

Shout it

Sql Server reporting services and Forms authentication – Part 3 – Linking aspnetdb to report server

published 1221 days, 23 hours, 3 minutes ago posted by

Praveen 1222 days, 3 hours, 59 minutes ago

I think, you have read my previous two posts related to implementing forms authentication in report server. Sql server reporting server and forms authentication – Part 1 – Understanding the concept. Sql Server reporting server an forms authentication – Part 2 – How to implement. I just followed Russell’s article to link sql server report server to aspnetdb. So, I prefer to redirect my users to the same post. I don't want to repeat the whole story here again. So, please go here and continue your readin... (more)

category: Data | clicked: 3 | comment | | source: praveenbattula.blogspot.com

tags: Authentication, SSRS, SQL Server Reporting Services

Welcome!

SSRS

Extracting Images from SSRS reports

Create clock in SSRS using Gauge and AutoRefresh Property

String Concatenation/Aggregation in SSRS column or row group

Conditional Navigation in SSRS

KeepTogether Tablix Property - Chintak's Blog

Welcome to IT Funda Corporation: Webcast on SSIS, SSAS and SSRS (Hands on)

Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

Generating and exporting SSRS reports programatically using Report Viewer Control

Aggregate of an aggregate function in SSRS - Some Random Thoughts

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

Display Total on top of Stacked Chart - Some Random Thoughts

Visual Studio 2010 Report Designer doesn’t support SSRS 2005 format « Ahmed Elbaz's Blog

SSRS Weekday EMail Subcription

Fix to Report viewer problems in IIS 7 or later

Sql Server Reporting services 2008 Tablix control

How to give anonymous access to the reports.

SSRS Reports get Month name from Month Index or from date

Sql Server reporting services and forms authentication - Part1

Sql Server Reporting services and forms authentication – Part2 - How to implement?

Sql Server reporting services and Forms authentication – Part 3 – Linking aspnetdb to report server

Open ID Login

Standard Login

Forgot Password?

Sign up