DB Reporting Tools
Articles & Videos
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.
Any advice or tool suggestion is helpful and will get points!
I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. …
I have a report.
I noticed when I open a report.rdl file in VS2013 I see the main part of the report. When I do a deploy of that .rdl file and copy the link into a browser a Selecti…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you should read this article.
How to increase the row limit in Jasper Server.
I'm trying to build a program to sort out a stream of statements into relevant and non-relevant statements with regards to a particular domain name. What algorithms and frameworks would be helpful?
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
I've created a backup report job on a weekly basis. Every Friday it emails a report of all the jobs that failed/completed during the last 7 days. I have one backup job that failed yesterday(says can…
I've spent a lot of time trying to get fixed headers working in my web application without success. I'm using Visual Studio 2015 and the header works fine in preview mode. It also works when viewing…
After a new T1 line was implemented a user could no longer print a report in a system linked to crystal reports. Everyone else still can. The program is called Yardi Voyager. Here is the error message…
Hi DB2 gurus,
I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some a…
Hello Experts Exchange
Does anyone know where I can get a UK map with all the postcodes in it so I can use in a SQL Server Reporting Services report.
If you could provide where I can download it t…
Using Microsoft Visual Studio 2008
Is it possible to create a blank BlankReport.rldc with Header information and create the Table columns and Textboxes on the fly in the
I have a table with field names "0616" "0716" "0816" etc for 24 months. These fields contain numbers.
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a C…
I am trying to a) create a time with millisecond accuracy and b) display that in Excel.
What I have found using the below code is that Excel will show the correct milliseconds in the worksheet usin…
I have data like
I want to sum in group as (5/10)+(10/20)+(20/30).
when I am summing it give as 5+10+20/10+20+30 .
I am creating a billing statement from a SQL DB using Crystal Reports, and need to come up with a way to handle multiple payments for one invoice. The attached statement demonstrates my problem. I'm a…
I've been on the periphery of dimensional data modeling for a while, while knee deep for years in traditional ERP relational models and a de-normalized data warehouse, and lots of SQL data analysis. I…
I am trying to build a report in Crystal that uses a subreport. How do I place the subreport such that it doesn't repeat in the main report? If I place the sub report in the footer of the main report …
i am very confused in this if you can help me
to evaluate the performance of an information retrieval system we use a collection of 15 documents and a request Q.
It is known that…
I need help with sth.
I have a across tab report with a distinct count a field1
This is rare:
I'm using distinct count a field1 for total too, and total is wron…
I found this awesome interactive sales data pie chart:
We use a software for health care data. It's very limited in reporting. I'd like to somehow create my own reports, it runs on SQL 2008. Any tools out there that may be easy to start with? …
I am new to the SSRS reporting building. Can you please suggest/correct my expressions for the report calculated field?
I have to create an expression to return the User, their email and phone number. It is below:
What is the field for non-custom user?
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe fo…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource (usually a database connection). Here's their website with further information about Jaspersoft Studio:…
Stratford, CT, United States
1,800 points this week
Moscow, Russian Federation
1,800 points this week
1,000 points this week
Gandhi Nagar H O, Gujarat, India
1,000 points this week
715 points this week