Recommended SQL profile for MySQL
We are searching for an SQL profiler for MySQL equivalent to Microsoft SQL Profiler…
![DB Reporting Tools]()
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 applica...
Read more- 8.1K Content
- 2.4K Contributors
Leading Experts In
Troubleshooting Solution
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
Hi,
I need help modifying the code below to take the amounts from where you see -- TW PU PD and …
I need help modifying the code below to take the amounts from where you see -- TW PU PD and …
Advice Solution
Ideas on User Data Input Methods?
My boss has asked me to create a "system" or form for various data owners to use to input requested
…
Troubleshooting Solution
How can I fix Failed to retrieve data from database [Database Vendor Code: 446] Crystal Repors 11
We are running Crystal Reports 11.
There is a specific report when ran in the server (server …
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 …
In an SAP BI BO Integration project when a BO universe is built on a …
Troubleshooting Solution
Sql sintax - finding the TOTAL of a sum
Hi guys, trying to get Grand total for the sum of GROSS
error at line …
error at line …
Troubleshooting Solution
Query execution failed for data set - error with mulitvalued parameters
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
Hi,
We are using Cognos Powerplay version 6.61 along with Cognos Powerplay transformer to build …
We are using Cognos Powerplay version 6.61 along with Cognos Powerplay transformer to build …
Troubleshooting Solution
Display Format
Have a crystal report showing the data as below:
Account# Line Result
12345 1…
Account# Line Result
12345 1…
Troubleshooting Solution
How to sum in an inner join
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
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
Hello,
I am using Crystal Reports 2008 developer edition. The store I am working with has a door…
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?
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:
Here is the statement:
SELECT Orders.OrderID, Orders.BatchNumber, …
SELECT Orders.OrderID, Orders.BatchNumber, …
Troubleshooting Solution
Problems with SQL Server 2005 Reporting Services Report Manager and Report Server web sites
Hi Experts,
I hope someone can help me. I have been fighting this issue for *days* and the …
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
I have a table called APPLICATION_AUDIT in which there is a column name …
Troubleshooting Solution
SELECT statement
I am trying to get this select statement modified from an Access SQL view to work. I'm working in …
Troubleshooting Solution
How to pass parameter in vb6.0 for crystal report 11
Hi
i want to pass parameter for crystal report 11 in vb6.0
I can view report by using following…
i want to pass parameter for crystal report 11 in vb6.0
I can view report by using following…
Explore solutions and more
![DB Reporting Tools]()
DB Reporting ToolsBack to the top
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.