SSRS Data Driven Subscription - No Email When No Data in Report

SSRS Data Driven Subscription - No Email When No Data in Report

This Video is tell how we can restrict to send the Email subscription when there is no data in the Report

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI ToolsVisit us:-  YouTube Channel

SSRS Two Tablix Page Break with Same number of Rows and show in one page

SSRS Two Tablix Page Break with Same number of Rows and show in one page

Issue raised in MSDN Forum:- I have 2 tablix in a report. Both the table has 30 records each in it. I want to show both the tablix reports one after another in the front page. Initially the report should display 10 records from the first table and 10 records from the second table in the first page. Then in the second page, next set of 10 records from the 1st & 2nd tables and third page should display last 10 records from the 1st & 2nd tables.

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI ToolsVisit us:-  YouTube Channel

SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube

SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube

Workaround:- SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

 

SSRS Dataset Execution Flow Parallel or Single Transaction

SSRS Dataset Execution Flow Parallel or Single Transaction

What is the significance of Use Single transaction when processing the queries checkbox property in SSRS data source property.

This Video is to showcase Data Set Execution mode, with creating temporary table in one dataset and use in another dataset.

So if data set execute in parallel mode than it will failed for above case, and if it executes in the single mode than it will success of the temporary table creation happen in first top dataset.

For more details watch below video:-

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

 

QlikView Layouts Modification

QlikView Layouts Modification 

This Video is to showcase below things

• Changing the default object layout options
• Changing the default selection color scheme
• Modifying the green, white, and gray selection color schemes
• Using containers as an alternative to multi-boxes
• Using the design menus to custom format a cell

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

QlikView Charts Part 4- Pie Chart , Line Chart and Bar Chart

QlikView Charts Part 4- Pie Chart , Line Chart and Bar Chart 

Topics shown in below video are:-

• Staggering labels in a pie chart 

• Creating a secondary dimension in a bar chart 

• Replacing the legend in a line chart with labels on each line.

Watch video for more detail.

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

QlikView Charts Part 3 Redmond Aged Debt Profile and Waterfall Chart

QlikView Charts Part 3 Redmond Aged Debt Profile and Waterfall Chart

How to create Redmond Aged Debt Profile chart and Waterfall Chart in QlikView

Redmond Aged Debt Profile chart

The first column is a bar chart representing the vertical distribution of the total debt for each country. In the three following period columns, we divide each period value by the total debt for that country to get the ratio—the horizontal distribution of that country's debt across the periods. This allows the user to quickly scan down the chart and see which countries have  the highest percentage debt in each period.

Waterfall Chart:-

A waterfall chart is a type of bar chart used to show a whole value and the breakdown of that value into other subvalues, all in one chart. We can implement it in QlikView using the Bar Offset option.

In this example, we are going to demonstrate the chart showing a profit and loss breakdown.

Above Charts creations are covered in below video.

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

QlikView Charts- Part 2 Modified Bullet Chart/Bar Chart in a Straight table

QlikView Charts- Part 2 Modified Bullet Chart/Bar Chart in a Straight table

Modified Bullet Chart in a Straight table and Bar Chart in a Straight table

The "traditional" approach is to have bar representing the feature measure and a line representing the comparative measure. However, as long as we have two separate representations, the bar is not absolutely necessary.

In this video we will present a modified bullet chart using an inline linear gauge in a  straight table. This allows users to view the results across all the values in a dimension.

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

QlikView Charts Part-1 - Box Plot Chart

QlikView Charts Part-1 - Box Plot Chart

Box plot charts, or box and whisker charts, are often used for displaying statistical mean and quartile information. This can be useful for seeing how a value ranges across categories by visualizing the median, the twenty-fifth and seventy-fifth percentile, and the outlying values. With a simple data set, it is easier to create the chart manually than using the wizard that QlikView provides—although there is a slightly strange sequence of actions to go through  a "funny"—that you need to know about.

Box Plot Chart can be created two ways, by Wizard or by Normal combo chart, To know more watch this video

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

JasperSoft Variables Properties and Usage

JasperSoft Variables Properties and Usage

This Video is to showcase Jaspersoft Variables and usage.
In this video below things are shown in detail:-

• In-Built Variables
• User created Variables
• Variable pane
• Variable Properties
• Variable Usage

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

JasperSoft Parameters Properties and Usage

JasperSoft Parameters Properties and Usage

This video is focused on JasperReport Parameters and it covers below sections:-

• Parameters Pane
• Basic Properties
• Built-In Parameters
• Properties
• Where and how we can use the Built-in Parameters
• User Defined Parameters
• Properties
• How to identify built-in parameters and user defined parameters
• Parameter Usage in the Report

Thank you for watching this Video.
Any comments or suggestion's ,please provide.

Thanks

Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel