Explore DB Reporting Tools on Experts Exchange

Expert Solutions for Your Tech Problems

DB Reporting ToolsDB Reporting Tools

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applica...

Read more
  • 8.1K Content
  • 2.4K Contributors

Troubleshooting Solution

Recommended SQL profile for MySQL

byjana
67
We are searching for an SQL profiler for MySQL equivalent to Microsoft SQL Profiler
Article

Getting Started with Jaspersoft Studio: Creating a report from a template, and Creating a datasource

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Troubleshooting Solution

Help in averaging dynamic loop query

67
Hi,

I need help modifying the code below to take the amounts from where you see -- TW PU PD and …
Troubleshooting Solution

How can I fix Failed to retrieve data from database [Database Vendor Code: 446] Crystal Repors 11

byjana
57
We are running Crystal Reports 11.  

There is a specific report when ran in the server (server …
Article

SAP BI BO Unit or Currency Logic for unknown units

Problem Statement
In an SAP BI BO Integration project when a BO universe is built on a …
Advice Solution

Recommendation for managing reports in Angular/Java application

byZolf
12

Hi there,


I have implemented an Angular/Java application with MySQL database and it is working as

Troubleshooting Solution

Sql sintax - finding the TOTAL of a sum

47
Hi guys, trying to get Grand total for the sum of GROSS

error at line  …
Troubleshooting Solution

Query execution failed for data set - error with mulitvalued parameters

byTinaSC
49
I have a report in SQL RS 2005 where a user can select and FundNumber and date range.  This works …
Troubleshooting Solution

Cognos Powerplay - 2009 date issue

48
Hi,
We are using Cognos Powerplay version 6.61 along with Cognos Powerplay transformer to build …
Troubleshooting Solution

Display Format

byrowfei
47
Have a crystal report showing the data as below:

Account#     Line    Result
12345             1…
Troubleshooting Solution

How to sum in an inner join

41
I asked this before, but I want to add another sum without grouping this field. I would like to add …
Troubleshooting Solution

Crystal Reports (8.5) complex difference between two dates

41
I have a Crystal report which works out the productivity of employees by referring to a barode log …
Article

Administering Jasper Reports Server

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Troubleshooting Solution

Walkthrough of creating a report with Crystal Reports 2008

43
Hello,

I am using Crystal Reports 2008 developer edition.  The store I am working with has a door…
Troubleshooting Solution

Oracle - how do I pass in a param for an IN statement to proc?

35
I have a proc and I need to pass in a IN statement for a parameter such as 'C15' will come in or …
Troubleshooting Solution

Help with a MySQL statement:

34
Here is the statement:

SELECT Orders.OrderID, Orders.BatchNumber, …
Troubleshooting Solution

Problems with SQL Server 2005 Reporting Services Report Manager and Report Server web sites

byCMI_IT
35
Hi Experts,

I hope someone can help me.  I have been fighting this issue for *days* and the …
Troubleshooting Solution

issues capturing and counting values from a table

byKerau
38
I have a table called APPLICATION_AUDIT in which there is a column name …
Troubleshooting Solution

SELECT statement

byHoyt81
30
I am trying to get this select statement modified from an Access SQL view to work. I'm working in …
Advice Solution

Looking for suggestions for a SQL Query tool to use with MS SQL Server?

byarmgon
9

Looking for options as to a stand-alone SQL Query Builder type application?


Any suggestions on such a

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more