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 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
I am working with some existing reports and need to modify certain fields.  The Company ID needs to be truncated after the first occurrence of a "-" (dash) and then return everything to the left of the "-"

I have tried the following but it does not truncate the field as expected.

=IIf(InStrRev(Left(Fields!customeridname.value, 25) > 0
        And InStrRev(Left(Fields!customeridname.value, 25), "-") <= 25
    , Left(Fields!customeridname.value, InStrRev(Left(Fields!customeridname.value, 25), "-"))
    , Left(Fields!customeridname.value, 25))

Open in new window


Thanks
0
Hi guys,

As per the title, how could I generate a table of contents, i.e

1) Introduction.......... Page 1
2) Overview.................Page 2
3) Safety Plan..............Page 3
    3.1) Lifecycle...........Page 4
    3.2) Verification......Page 7
    3.3) Issues...............Page 12
4) Conclusion..............Page 17

Obviously each time the report is run the page numbers will alter depending on data size. Is it possible to have the table of contents auto generated to pick up the page number for the start of each section?

Many Thanks.
0
We have a subreport which has many columns corresponding to product sizes as shown below:

subreport
Only the sizes relevant to the products being shown are displayed, all other columns are hidden.  These results in he report looking like this:

report
We would like to extend the blue header row background across the page so the table looks better.  We've tried adding a blue rectangle section behind that header row but of course SSRS just pushes it down the report.  Is there a way to achieve what we want?
0
Hi, I have created a SQL job and I need a method of triggering it.

The data (in this case a CSV file) is being generated by Business Objects (SAP BO formerly Crystal).

It would be great if there is a tidy method that would be able to trigger my SQL job as soon as the CSV file is generated.

Thanks

Stuart
0
I am at Beginners level, so please excuse the trivial question ...

I use Crystal Reports 2011 with an Access Database connected by ODBC.
We have one table that contains information that I need to display in a report, and use some of the displayed results to calculate values.
The Table consists of one Date Field and nine Number Fields.
One Number Field "Status" contains a value between 0 and 5, these numbers correlate to different statuses.
I can easily display these statuses in the Details section, and wrote a Formula to display a string matching the Status, in the form of:
IF {table.status} = 0 THEN 'STATUS_0' ELSE
IF {table.status} = 1 THEN 'STATUS_1' ELSE ... and so on.

My problem is now: I need to show the number of occurrences for each of these statuses in the Report Footer.
This should look like:
Period: 2016/4/01 - 2016/04/10
Status_0:  3
Status_1:  1
Status_2:  0
Status_3:  1
Status_4:  5

These counts I will then need to use in a formula to determine a result, like:
(COUNT (Status_1)*1000)+(COUNT (Status_2)*-2000+ ...

How to proceed here?
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
>