DB Reporting Tools

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

Share tech news, updates, or what's on your mind.

Sign up to Post

I would like to know how to manage patch management (eg. a group of servers with different flavours of operating system).
Also how to re-check updates after the first patch of updates have been installed.
Also how to force check back to reporting services to gain accurate result if they are compliant or not.
Angular Fundamentals
LVL 13
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

I want sum of Count column, can you please share expression for this or how to do this? the number of rows of date and count column is not fixed, it will vary every day.Untitled.png
I have a system in elasticsearch collecting performance metrics from my network. The space occupied is a lot, and I need to know how to optimize disk space. I have the idea that the project consists of having detailed samples of the last time (for example, one or two weeks). Beyond that time you can have historical samples, but with less detail.
I need to start organizing how to carry this forward.
I am trying to  run Tableau 1.5. I get the error api-ms-win-crt-runtime-|1-1-0.dll is missing. I have tried a number of fixes and nothing has worked.
The solution John gave worked on one computer, but not the other.

Sorry to post this twice.
I have just started to deploy and learn Microsoft Power Bi. I installed the BI gateway and able to get it connected in the portal.  My question is, how to i make a BI workspace that calls to that data?  DO i need the BI desktop app or can i not create that from the portal?
I'm upgrading from an older (5.1) version of Jasper Reports in my java project.  I've re-compiled a report in the new Tibco Reports Designer.  When I try to run it, or any other report, I get no output.  I downloaded and compiled the jasperreports 6.0.2 source and am using it for debugging the problem. screen shot of last executed statement  I've included a screen shot of the last statement that tries to execute.  It's line 823 in JasperCompileManager in function getCompiler.

This is a working app and I believe I've updated all the required libraries.

I don't catch any exceptions (at least not any I'm expecting) and the program returns to my finally statement after trying to run the jasper report.  The only other thing I can add is that if I hover over the JRCompiler  item in the previous sentence it says, JRCompiler is not a known variable in the current context.  Not sure if that helps.  It also doesn't hit the catch (Exception e) statement it just fails.  Not sure how to progress from here.
Cognos 10, Oracle database. Situation is that a list inside a table is repeating itself and I'm looking for a way to not have it repeated. Is there an option in the properties page that might need enable or disable to resolve this issue. Please see attached image.

Need help creating an API call in Power BI to retrieve data from a specific vendor.
They provided the following link:


I previously was able to create a working API call using Power BI to a different vendor.
As follows:


Note: Username, Password and OrgID were substituted out in the above example.

While there are several way to retrieve this data, we want a consistent method.  We would like to use an API similar to the above to retrieve any data table into Power BI.

I am working on  a VBA app and need to setup a reporting system to query my db and return some result based on user's preference. However, I want my end users to be able to export this report to excel or even send to their email.
I will appreciate if you have experience with this procedure with VBA.
I use MS Access db
Thank you
HI there, I am using SSRS and have a problem where my grand total on the last page of the report will only calculate the the times of the pages that have been shown. In other words, if its a 3 page report and I run it and view the first page then skip to the last it will calculate the first and the last missing out page 2. If however, I run the report and go through each page using the next button it then calculates the total correctly.

My total is a SUM of a previous total and both are code elements within the report, after doing a bit of research I found out that this is why, the code elements only fire on the page that is in view.

My 2 code elements are:

Public shared dim totalJobTypeRateTotal as Decimal 

Function AddTotal(ByRef JobTypeRateTotal AS Decimal) AS Decimal 
                totalJobTypeRateTotal = totalJobTypeRateTotal + JobTypeRateTotal
                return JobTypeRateTotal

End Function

====This function calculates row items based on a lookup that finds the specific rate for each job type=====

 Public Function GetTotal()
                return totalJobTypeRateTotal
End Function

====This is the grand total at the end of the report group that will only calculate the total of the AddTotal function expression on pages that have been viewed====

Open in new window

How do I get the 2 code calculations to produce a grand total correctly without having to scroll through each page?
Microsoft Azure 2017
LVL 13
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Hi All,
 I am using Graphana on Elasticsearch to show % pass/fail in weekly reports, I can get Pass/Fail  from the Pie chart but not in Stacked bar graph ..
Is there any plugin which i can use to get the pass fail percentage in Bar Graph.

I am trying to display a report, I have a stored procedure that requires 3 parameters.  I am also using EF6 to push and pull data but I don't seem to be getting any data back to my report data source.  In my edmx file I see the SP in the functions folder and can pull scheme info.

In the code behind I try this
    ReportDataSource rds = new ReportDataSource("dsBOL.PrintBOLDataTable", dt);
but nothing.

Here is a shot of the report data source.


DB Reporting Tools

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

Top Experts In
DB Reporting Tools