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'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.
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

I had this question after viewing Ms Access Crosstab Report with variable number of columns.

Dear Experts,
I am facing a similar situation but the problem is instead of numeric columns, i have Text Fields as columns. Any addition of column (Storage_Port) does not reflect in report. However, any change in Product / Qty gets updated.

Would be obliged if i can get help.
Db is attached herewith for reference purpose.
0
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.

Thanks
Capture.JPG
0
Hi I have report in 11g I what the data to display in excell format with heading I did use delimateddata it's showing data in html
0
User come up to me this morning and told me that he can access http://server/ReportManager. When you got the webpage, you get the following error
The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version

I logged into the server and tried to access the reporting services from SSRS and get the error below:
Unable to connect to the server at Server. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)


I tried the following to fix:
1)      Reboot – didn’t do anything
2)      Restart services – did nothing
3)      Log files showed an error: library!DefaultDomain!5ac!05/04/2018-08:43:12:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "Report_Server" …
0
I am researching the best Reporting Programs out there to fit our needs.  I've used both Crystal Reports and Cognos - years ago (I know they've changed).
I need to be able to connect to our database and allow users to create their own reports.  Of course I would want to create some and publish those to our website.

Any recommendations on the best programs out there (that don't cost a fortune) to configure and get something out there for our users?  I don't need something that is going to take
me months to get reports available.
0
I need to reset a value at the change of a GH1 in Crystal Reports , but I cant seem to get the formulas correct
CrystalQuestion.docx
0
Windows 2012, SQL 2012, Dynamics 365

The ReportServer and ReportServerTemp databases, from our CRM 2011 SQL server, were restored to our Dynamics 365 SQL Server.  This did not work and made all reports in Dynamics 365 non-functional.

I have tried creating a new ReportServer database using the SQL Reporting Configuration Tool however this does not make the existing reports functional.

What is the solution to get back to where were before the  ReportServer and ReportServerTemp databases were restored from our CRM 2011 SQL server?

Is there a method to map the existing reports to the new ReportServer datasource I created?

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

https://www.esayworkmobile.co.uk/wmbapi3/workmobileintegration.asmx

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

https://training.reliaslearning.com/webservices/elapi.asmx/ExportEnrollments?authorizationID=USERNAME&passcode=PASSWORD&OrganizationID=ORGID&DateRangeType=3&startDate=01/01/2018&endDate=04/03/2028

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.


MAC
0
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
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

The rectangle is too complex to export data to word using ssrs report
0
I have an issue with a calculation in SSRS 2016. My tablix reports on orders and has 3 row groups. From outside to inside that is:
- Whether the order was closed or missed (boolean)
- Market segment
- Market subsegment
I also have a column groups for month and year-to-date.
My problem is that I want to perform a calculation for the ytd column group that involve results from both the "closed" and "missed" results in the row groups, for the market group and subgroup records. I've tried to illustrate it in attached example.
Anyone have any idea what expression i can use to achieve this? Not sure if it matters, but the datasource is an SSAS MDX cube.
Thanks.
0
I have a question about crystal reports.

I have a Running Total Formula that I need to do the following below but it is not working. Basically I am trying to sum all the Kansas products that are in category 41,42,43.  If no products are found in the those category display inventory products as 0.  My report shows results as blank

if ToNumber({KansasInventory.cat})>40 and  ToNumber({KansasInventory.cat})<44
then
TonUMBER({@DisplayKKansasInventroyProductsy})
else
ToNumber({@DisplayKansasInventroyProducts}) = 0
0
Print button and date picker  of SSRS Report viewer of asp.net,  are not visible in non-IE browsers (google chrome)
0
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
Need to know if its possible in SAP Plant Maintenance to do a manual call on just ONE maintenance item # on a multi-item maintenance plan. For example, I have a maintenance plan # 1001 that has 99 task list items on it, varying in intervals from daily to annually, and one of those task lists maint items is # 567, I want to manually call just that 567 item to generate a work order tomorrow. I know if I were to create a maintenance plan for every task list, this would not be a problem, but my maintenance plans have many task lists on them and I cannot figure out how to manually call just ONE of them and not any others on that maintenance plan.
thx experts
BobR
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
I have a client that needs to delete two transaction expenses from a program called Cuncur. His employer does not give delete rights. Is there a way that this can be done?
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
Cloud Class® Course: CompTIA Healthcare IT Tech
LVL 12
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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 have 3 servers for this scenario. webserver1, newwebserver, sqlserver.
webserver1 uses SQLserver 2008 R2 for SQL Reporting Services
newwebserver uses SQLserver 2012 R2 for SQL Reporting Services
sqlserver uses SQLserver 2008R2.
webserver1 have been connected for SQL Reporting services to sqlserver.
Today, we tried to add newwebserver for SQL Reporting service to sqlserver, and for some reason it screw our current webserver1 SQL REporting services.
I need to be able to reconnect my webserver1 via SQL reporting services with my sqlserver. I have the "SWL REport key.snk" and password that was originale used to create this service. i have been trying to restore and error below.
encryption keyserrori need to be able to reconnect back. I already disconnect newwebserver, but i believe it is still connected for some reason. what i can do to reconnect back to ReportServer database.
0
Has anyone seen an article on a comparison of features between Tableau, qlikview or any of the other data analysis tools that are current "hot"?
0
I'm trying to create a report in Cognos with the following format:

Output
My current output is a crosstab query below:

Crosstab Output
Actual CT query
0
I'm trying to create a report in Cognos 11 with the following format:
Desired Output
I have a crosstab query in the format below which I would like to convert to the format above or create a new report:
Crosstab
Query
Thanks
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
>