Improve company productivity with a Business Account.Sign Up

x

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 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
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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?
0
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,
I want to create reports. My project currently has some templates and a user can initiate any of the templates...
There are templates like ReimbursementTemplates, NewHireTemplate...
So for each template based on its particular detail i need to build a report and mail it.

Currently i want to do it for only one template. So i thought of designing it like the following --- its just a pseudocode. Need expert comment on it... For better design and inputs..

@Service
ReimbursementReport {
      int templateId = 1;
      @propertyFile(reimbursement)
      @CronExpression cronexpression;
      @propertyFile(fieldType)
      FileType fileType;
      
     @cronexpression
      void build() {
          Info = fetchAllInforFromDB(templateId);
          File file = convertToFormat(Info, @file);
          send(file);
      }

      void send(file) {
       switch(service) {
       service instance of Email :
          emailService(file, @rem.repo.email);
       }
      }
}

reimbursement.report.cron=
reimbursement.report.file=
rem.repo.email=

The above i will put in properties file so it can be changed without compiling the project..
I just came up with this design which obviously is not complete. Each report can have its own cron job whether it needs a pdf or some other format...
Also what are the other ways in which one can send reports apart from emails..
Need expert help to complete and augment it.
And if anyone has used anything like that please share the details...
Thanks
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
>