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

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 that would be great, if I need to purchase please provide URL.

Regards

SQLSearcher
0
Hi Experts

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
BlankReportDefinition.vb

If so how, where to look and an example would be great

Thanks
0
Hello Experts
I'm looking more of an advice than an answer here.
We are looking to purchase a tool that can help with code migration - this can be DB procedure/ package/ views, DML, DDL statements and also take backups of all information before they are modified.
this can be one or combination of the above mentioned and can have a specific order of execution.
This tool should also maintain code and deploy into dev/test  and prod as needed.
Do you know if there is any such tool in the market?
This is to be run against 11g and 12C Oracle databases.
Thanks in Advance
1
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 assuming I need to create a view in the SQL DB, but need help. Here is my thought process:
1. Apply the parameter to select the correct job number from [jobs.job_no] (this is working fine in my Crystal select with a parameter)
2. Get the full invoice amount from [ar_invoice.invoice_amount]
3. Check [ar_cash_receipts.cash_receipt] to see if there is a payment
4. If there is a payment in full, then apply the payment value and the resulting balance due is 0
5. If there is a balance due after a partial payment is applied, then create a result with the value of the remaining balance due.
6. Now the invoice_amount should become the remaining balance from the result above, and any future payments would continue to be subtracted until the final balance = 0

Currently the report I've created does not know that a partial payment has been applied, and if a partial payment is made, the invoice repeats at it's full amount when another payment is received.

If there is a better way to do this please advise as well.  Thanks for your help!
0
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 assistance from the experts in this group. my question is this:

Given the following critical events in a DB2 database environment, which of the following tools that follows can be used to investigate each event?

What I am looking for is this: I am looking to match a specific type of DB2 system event like I listed in this post and the best tool that can do the best job in monitoring for that event. The more event type a tool can monitor, it rates high or higher depending on how many event that it tool totals.  Can anyone contribute in this regard?

Critical Events---
Server failure
Database crash
Log space ,temp space, database data ,database log ,home file system utilization exceeds threshold.
Pre-defined Key words appear in the system (db2diag.log) files denoting a critical event occurring.
Time to get a lock exceeds a threshold.
Connection can not be made to the database.
Percentage of applications waiting for the Locks.
Memory Usage exceeds threshold.
Scheduled benchmarks queries exceeds threshold.
Required process not executing.
Swap space exceeds a threshold.

Monitoring Tools:---


Alarm Point
BMC Patrol
DB2 Governor
OPM
WLM
TIVOLI
Ganglia
IP Monitor
NAGIOS

Any and all your considered experience and comment will be highly appreciated.

0
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 it doesn't repeat, but I need to insert yet another subreport, is there a way I can place them so they don't repeat?
0
I'm not looking for a specific code solution but maybe an article or example, to create a report that allows the user which fields they want displayed on a report. I know in business objects this is possible.
0
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:

objCrystal600822323 error '800a004b'
Path/File access error
/65303forestcity/system/Crystal.vbs, line 217

Everything else is working fine. We tried restarting the PC and clear browsing history. I might try doing a Windows System Restore Point but I don't what kind of repercussions that will give me or if that will even work at all. Any ideas?
07-28-2016b.png
0
I have data like

target   Achieve
10            5
20            10
30            20

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 .
Please provide me solution.
0
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 using the NumberFormat  "DD/MM/YYYY HH:MM:SS.000" but it will not show milliseconds in the debug window using the 'Format' command and instead rounds it up to the nearest second.

Can anyone else confirm this to be a known issue or have they got experience of this ?

Sub testMilliseconds()

    Dim dblMillisecond As Double
    Dim dblResult As Double
    
    dblMillisecond = 1.15740740740741E-08
    
    dblResult = dblMillisecond * 1750
    
    Debug.Print Format(dblResult, "DD/MM/YYYY HH:MM:SS.000")
    
    With Range("A1")
        .Value = dblResult
        .NumberFormat = "DD/MM/YYYY HH:MM:SS.000"
    End With

End Sub

Open in new window

0
Hi guys,
I need help with sth.
I have a across tab report with a distinct count a field1
This is rare:
Field1
1
2
3
Total 5
I'm using  distinct count a field1 for total too, and total is wrong.
Any ideas?
thanks
JS
0
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'm in a non big data environment.

I've never understood the purpose of (nor the mechanics) dimensional data models. Now that I read a few blogs, I can better ask my questions. Here's a good article and some pic's that helps clarify my perspective on the structure of a dimensional data model.

dimensional data modelDimensional data
So,
- Am I correct that this data modeling technique is ultimately done for performance purposes ?

- So isn't this accurate: to get to the dimensional data model, the OLTP data is broken up, then ETL'd to the dimensional model, then to write reports, well, you bring it back together again ? As an outsider to dimensional data modeling, I've always said to myself, "why not just write the query against the OLTP ?" Because when I look at the dimensional data model I can't see how it's much different than a relational model. Using the example above, the fact table would be a relational table by simply storing the date of the transaction as opposed to a "date FK". Using this example, I just don't get it.

- Isn't this dimensional data model like fully normalized ? So to present this to the users, you have to write a traditional query ?
0
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 it in IE on the /reports SSRS web interface.  However it does not work in the very same IE browser via the Report Viewer control (version 12).

Below lists the relevant properties, the views as described above and the code related to the report viewer control.  Discouragingly, the SSRS forum has come back acknowledging this is a known issue.  I find it difficult to believe that such a fundamental feature is not working. I'm happy to use another version of Visual Studio, .Net or the control itself to get this working!

Tablix properties
Row Properties
Code
Preview in Visual Studio
SSRS Web Interface
Report View Control
0
Hello Experts,

I have an issue in Crystal Report 2008, where I cannot show the data in multiple columns on detail section. For e.g. in the detail section I need the data like this format:

1     4
2     5
3     6

But I get the data in one single column instead of multiple columns. I tried all what explain in below link, still no able to get the format needed.
http://www.bofocus.com/formatting-the-detail-section-to-display-multiple-columns/

Thanks,
ASPDEV
0
tabletable
hi evryone,
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 the documents D1 to D5 are pertinens (P) for request Q and others non pertinens (NP)
The system retrieval information calculate  a score for each document.
I have some questions if yo ucan help ME

So i need to calculate the precision, recall, the measure F1 and jacquard index for top 5 résultat in this table
why not use the error rate ?
Calculate accuracy for recall 0.8 ?
Calculate and dessin the precision-recall curve ?
0
Hi evryone i need you help
how to perform queries "wild-card" type: cho*at
0
I have a basic knowledge of Dimensionall Modelling and ETL. I need a little bit more knowledge and experience in those 2 subjects so that I can get a job in this field. Does any one know of a good course I can join?
0
I found this awesome interactive sales data pie chart:

https://live.zoomdata.com/zoomdata/visualization?__target=embedded&key=52265abb6abdbcaa8c217789#51db7ad4e4b04caf9ab346db-51db7ad4e4b04caf9ab346d5

Does anyone know how this is done or what tool/software is used?  

Thanks,

lgduong
0
Hi

Just wondering what's available as in a third party tool to present queries from a SQL table in presentable format

I used crystal reports some years ago, just wondering whats new out there at the moment

Thanks in advance
0
Hi

I have to create an expression to return the User, their email and phone number.  It is below:

=Fields!csc_cobhamquotecontactname.Value & vbcrlf & Fields!internalemailaddress.Value & vbcrlf & Fields!address1_telephone1.Value

Open in new window


What is the field for non-custom user?

Thanks
0
Super easy low tech question...
In Oracle SQL designer.  File > Open
In the dialog box that opens there are 'Favorite' folders down the left side.  Some time ago, I added a couple personal folders.
For the life of me, I cannot recall how I added/removed folders from here.
Any idea ?? Trying to re-organize things a bit.
0
Our network admin is trying to create a .bat file to sync a ftp site.  The file runs but then cannot find the directory.  I have attached screen shots of the bat file while running.  The bat file uses

This the batch file.......without the real ftp of course...

# option batch abort
# option confirm off
open ftp://certs@Helloworld-inc.com:password@Helloworld-inc.com -passive=off
synchronize remote d:\share\certs\new /
close

It connects to the ftp and then gets to comparing, loses connection and then  disconnected  from server.
So this is what we see.

comparing...
Local 'dD\shar\cers\new => Remote '/'
Lost connection
Disconnected from server
Could not retrieve directory listing
TYPE is now ASCII
Error listing directory '/'.
Session closed.


Any help would be much appreciated.  He has search on the web for over a week and still cannot get this to run.

Thank you.
0
Hi

I am modifying some old SSRS reports and I am having a problem connecting to datasource (named CRM).  When I run Test Connection, I receive the attached error message.

I need to eliminate this error to make progress on updating the reports.

Thanks
test_connection.png
0
Hi Guys,

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 not a DBA by any means..
0
Hi

I am working on rdl-based report in a Visual Studio solution.  It works fine when I modify the existing report, build/save and upload into CRM using Reports/Edit and get the new rdl.

The issue I have now is that the reports have a datasource called CRM which queries the Quote Filteredview and returns a number of fields accessible through four datasets.  Unfortunately, when I try to add new fields to the report,, I cannot query the Filteredview to access data fields.

I have tried adding to an existing dataset, adding a new dataset and datasource.  Whatever I try ends up with a error either in the Query Designer or when I upload the revised report to CRM.
ssrs_datasets.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
>