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
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
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
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
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.
Creation SQL Server Data Source Connection on Jasper Server Using JDBC
Jasper report using SQL server datasource.
We need to JDBC driver to connect SQL server. By default on local machine don't have JDBC driver.
Download JDBC driver and set the class path variable in environment variables point to JDBC driver.
In below video I have shown below things to setup SQL server data source to use in creating jasper report.
JDBC download website
JDBC-2 drivers based on 32 bit or 64 bit.
How to set CLASSPATH
How to create JDBC connection.
Testing
Thank you for watching this Video.
Any comments or suggestion's ,please provide.
Jaspersoft Repository explorer to Connect JasperServer in iReport designer
Jasper Server repository can be seen in I-Report Designer or Jasper soft studio.
It is useful to deploy the different components on Jasper server , Or directly we can modify the reports or connection strings on the jasper server from the Designer.
In this Video , I am explaining how to connect the Jasperserver Repository and how to deploy the report on jasperserver using report Designer.
In this blog video we mainly focused on JasperReports Server CP 6.2.0 Installation.
What is JasperReports? JasperReports Server is a reporting server to host reports created in I-Report designer or in Jaspersoft® Studio. JasperReports Server is optimized to share, secure, and centrally manage your Jaspersoft reports and analytic views
Detail level steps of installation are given in the below video:-
Thanks KBT Team Learn Different BI Tools Visit us:- YouTube Channel