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

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====

How do I get the 2 code calculations to produce a grand total correctly without having to scroll through each page?
0
[Webinar] Kill tickets & tabs using PowerShell
LVL 12
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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.

Thanks,
0
Hi Experts

I need a sample pilot project with code of the Implementation of  NLP(Natural Language Processing) feature  in Power BI  .

For example : If I have to get the top 5 sales by region , by typing plain english , it should generate the report in what ever the format I want .  Can you provide me a sample project with links of the implementaion (including code).

Thanks,
Srk.
0
Today I have a application that was made using webforms and I need to migrate to ASP.NET CORE.

This application uses Crystal Reports to generate many reports in PDF format.

I need a solution to migrate this reports, I intent to migrate this solution to a Linux server, then if I can migrate this reports to a solution that run in linux is better.

I've tried iTextsharp, but this don't work in ASP.NET CORE with Linux.
0
I recently downloaded the new version of jaspersoft studio (6.5.0) for eclipse.  I used to be able to choose specific dates for a parameter when previewing a report, now if I pick a specific date it treats it as null.  The only values I can get to evaluate to non-null are the relative dates like "DAY" or "MONTH".

Switching to an older compatibility mode doesn't seem to work either.

DATERANGE("2017-12-22") evaluates to null when I preview.
DATERANGE("DAY") evaluates to the correct Date, 2017-12-22.

Anyone have any thoughts?

Edit: Here's the documentations on Jasper's Date Range object: http://jasperreports.sourceforge.net/sample.reference/daterange/index.html
0
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.

ds.PNG
0

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
<
Monthly
>