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

when ssrs works with 2 diff databases, there is a situation where ssrs can only benefit querying from one system.. is this less efficient or make less use of ssrs's powerful features?
0
I have specifications for a report that pulls data for two specified date ranges.  The report has to work if one or both date ranges are specified and it has to work if neither date range is specified.  My problem is I have to specify which date range(s) are being used in the heading so a user can refer to the heading after running the report and see the date range(s) specified to pull the data.

Here is the expression I am using to build the heading in question:

IIf(IsDate(First(Fields!startdate.Value, "DataSet1")) and IsDate(First(Fields!enddate.Value, "DataSet1")),
    IIf(IsDate(First(Fields!startdate2.Value, "DataSet1")) and IsDate(First(Fields!enddate2.Value, "DataSet1")),
        & VbCrLf & "Title Order " & FormatDateTime(First(Fields!startdate2.Value, "DataSet1") DateFormat.ShortDate) & " to " &
        FormatDateTime(First(Fields!enddate2.Value, "DataSet1"), DateFormat.ShortDate),
        ""
       ),
    IIf(IsDate(First(Fields!startdate2.Value, "DataSet1")) and IsDate(First(Fields!enddate2.Value, "DataSet1")),
        "for Title Order " & FormatDateTime(First(Fields!startdate2.Value, "DataSet1") & DateFormat.ShortDate) & 
        " to " & FormatDateTime(First(Fields!enddate2.Value, "DataSet1"), DateFormat.ShortDate),
        ""
       )
    )

When I try to preview the report I get the following message:

An error occurred during local report processing.
The definition of the report 'report name' is invalid
The value expression for the …
0
We have Sharepoint with SSRS 2005.  Our previous developer created some reports (.RDL) and published them in Sharepoint.
I need to make some edits to these reports (adding a column).
How can I do this?

I know these RDL reports are not actual files (that I can browse to via Windows Explorer) but are saved in the SQL database somewhere.
I'm going to http://localhost and log in to Sharepoint as an admin.  

When I click on a report in the browser, each report has an "actions" menu in the upper left corner.  
The options in this actions - menu are: "open with report builder" (which doesn't work since SSRS is running within sharepoint), "subscribe" and "export" (which exports the report data, not the rdl).

How can I edit the rdl report?

0
Please excuse me, I just have too much on my mind for this (probably) simple issue

For all intents and purposes I have the following 2 tables:
Table1:
ID               BigInt Not Null (Identity)
parentID     BigInt Not Null
catName     VarChar(Max)

Table2:
ID               BigInt Not Null (Identity)
CatID          BigInt Not Null
ItemName   VarChar(Max)

That contain the following data:
Table1:
1     0     Cat1
2     0     Cat2
3     0     Cat3
4     1     SubCat1-1
5     1     SubCat1-2
6     4     SubSubCat1-1
7     4     SubSubCat1-2
8     6     SubSubSubCat1-1
9     6     SubSubSubCat1-2

Table2:
1     8     Item1
2     8     Item2
3     1     Item3
4     4     Item4
5     2     Item5

How can I return Item1 & Item2 records if I search for the term 'SubCat1-1' or 'Cat1'?
0
We have an initiative to develop a web based reporting system to accompany our MS Sharepoint installation.  This reporting system will provide static reports to the end users and attach to both Oracle and MSSql databases.  We have explored MS SSRS but with Oracle at least, the end user would be forced to submit an Oracle signon for every report that is run (we use native Oracle security).  We need a solution that would allow us to cache the signon credentials once (session variables) and pass them to the reporting system to eliminate this issue.  If anyone knows of a way to "send" MS-SSRS logon credentials for a connection string, that would be preferred.  Otherwise, does anyone have suggestions on Web Reporting with Oracle and MSSql while being front-ended in MS-Sharepoint?

Thanks,
0
I am trying to load many Crystal Reports to a Business Ojects XI server.   All of these reports are based on the same SQL database.   When I load in some of them , and then look at Database Confiiguration sometimes the User Name is there and I just have to add in the password.   These reports run fine.   It seems for the ones I load where I have to add in both an id and password, when I run it I get an error message that says: Error in File ~tmp177c6db6bb83e00.rpt: Unable to connect: incorrect log on parameters.
What I don't understand is the reports that fail with the error message are based on the same database and are setup with the same login id and password as the ones that work.   How do I get them ALL to work?
0
I have just got a job for business analysis (specificaly for customer segmentation) I wondering which good books to buy and read
a
0
I need to know how many plans can i create by application in Oracle Hyperion Planing and where i can find this answer (reference)
0
Hi,

I am trying to get an estimate of the costs involved in outsourcing a BI system. I have the BI development skills but I need to outsource DBA and Network/Security Management skills as well as server maintenance. How much would it cost me to pay for those skills and concentrate on the BI development skills?

I know this is a very open question, so it is ok to give open answers. I post it with the intention of generating a discussion that can bring up valid issues that can help me focus and find starting points.

Thanks in advance and regards.
0
Cannot print from report viewer rendered in IE browser.

Browser prompts:IE browser blocked an ActiveX control, so this page might not display correctly.
This is IE version 9.0.3

How to fix it?

In general, is there a better way to print MS rdlc report, if not from Client side?
Any GUI to preview the print outcome?

 Report Print ActiveX
0
I need to ba able to have a user select a language at runtime and then have Crystal Reports 2008 reports use this culture. This works fine in .Net however with Crystal Reports 2008 the culture will be whatever the system default is for all rendered reports. Is this possible?
0
Hi,

I am working on a project in which I need to modify some Crystal Reports which resiide wiithin a .NET web application. I do not have access to the web application code, but I have access to the Crystal Reports fles (.rpt). I am attempting to modify the Crystal Reports files in Crystal 11 on my local PC. Since the Crystal Reports were developed with an Oracle database, I first installed the Oracle Client on the PC (Crystal Reports 11 was previously installed), then I copied the TNS names file to my PC. After this, I copied the Crystal Report to my PC, then I opened the report. When I exectuted the "Print Preview" function, the report was generated, but did not pull any data from the database (i.e. all database formula fields that were supposed to be pulled from the database did not show any data, but text fields and formula fields which did not reference the database were showing on the report). Also, when running this report, I was getting the error that the "database file had changed. Proceeding to fix up the report." When I ran the report from within the .NET application, the report generated properly without any problems.

I wanted to check first to see if there was a problem with retrieving data from the database, so I created a new blank report, connected to the Oracle database, and added a couple of database fields to the report. When I previewed the report, the data was successfully pulled data from the database. I also tried executing the "Verify Database" …
0
Could some one help me with this error ?
We have 2 PCs, both WinXP with latest updates, one has Progress OpenEdge 10.1A (SP2) installed, running our POS database, the other PC we use it to run our Excel reports.

After installing the OpenEdge driver we created a ODBC connection to the database, everything went ok for a few days but now the connection just gives an error:
[DataDirect][ODBC Progress OpenEdge WireProtocol][OPENEDGE] Server rejects connection on attach.

I cannot login to the DB anymore not even on the server where the OpenEdge DB is located. All ODBC connection fail with the same error.

When I created my new user I used "sysprogress" username and password, now that one doesn't work either. Already tried to reinstall the drivers, already tried dbtool but no change.

Any ideas how to fix this ?
0
I was given a database with 100s of tables with no data schema and description.
I am trying to find out the lookup values for some of the field.

For example, I have a consumer table with a field called  'Title',  it has value of an int.   There should be a corresponding table that will give me the textual value of the title.   Is there any good tool that can help me to find out such lookup table.  

0
I have Visual Studio 2008 installed on my work computer. I was just given a Crystal Reports rpt file. Is there a way for me to open the file in VS2008? Do I need an add-on or something?
0
I have a report that is sent out as a pdf by email every night.
It contains a list of records with errors and goes to every department in the company, with the records grouped by department.
The report is quite large, and the company is expanding, so the report will soon become a pain for the managers, who will have to scroll through pages and pages of irrelevtant data to find their department's section.
I would like to have a separate report go out to a separate email address for each department, however I don't want to have to create a separate report and subscription for every department manually, nor do I want to have to keep this system manually updated in the future as the business changes.
I have a table in the database with department email addresses which can be added to the report data as a field or accessed separately. Is there any way to have the report run in such a way that instead of grouping by department it creates separate reports by department, and then emails them to the department email addresses?
Thanks
0
Hi,
I am using the CR Server 2008 report bursting method. I have it (nearly) working using the dynamic recipient list. I use a source report and I combine it with a 2nd report to create the recipient list.

When i execute the publication, a report is created per recipient.

Q. How do I distribute each report to users in Crystal Report Server. The users are actually listed in the 2nd report and will be created in CR Server.

TIA
0
Basically I have a field that has multiple lines on it.

PartDescrip

Sandpaper
ASTM-D-9849
Purchase from MSC Supply

I want to make it so that sandpaper will display as one item and that ASTM-D-9849 will display as another. I can get the first line to display by itself by simply preventing the field from growing, but I don't know how to display just that second line.

Thanks in advance for the help!

0
I've just inherited a new project - and it's a MOTHER FREAKING MESS!

ASP.NET website (Visual Studio 2008)
    253 ASPX pages

SQL Server (2005)
    210 Tables
    924 Stored Procs
    323 Scalar-Valued functions

Site's been in continuous development for 4 years - written by 16 different people (NONE of which are here anymore!)

Quick scan says about 15% of EVERYTHING is FREAKING OBSOLETE and not being used any more!

Please - Someone tell me there are tools available to ... at least ... find-out WHAT IS OBSOLETE and what's still in use?


0
Hi
If a report has more than 65,536 rows, can I set up an email subscription on it and the data to be extracted as csv.

Thank you
0
Hello experts,

I am in need of an assistance with a code in VB.Net.  I am trying to search all databases for similar item number and a field that the user select to show them what's available at each database.  So I create a loop to go through each database.  Issue is I need to append the result from each database and display it in a datagrid view.  See my code.

How could I append either the data to my dataset and have it show up in the datagrid view or append it to the datagrid view as I loop through the database.

Example:
DB           Item #      Description
BTDB1     AB1234     SUSPENSION DIAG TOOL MFG PRT# 32882
BTDB2     AB1234     SUSPENSION DIAG TOOL #67233
BTDB3     AB1234     SUSPENSION DIAG TOOL 89732

Below only show the last database that it search and I want to append.
Sub SearchAllDB()

        'CLEAR
        strDatabase = ""
        strServer = ""
        strUsername = ""
        strPassword = ""

        Dim i As Integer
        i = 0
        For i = 1 To 3

            If i = 1 Then
                strDatabase = "BTDB1"
                strServer = "SVR1"
                strUsername = "sa"
                strPassword = "P@ssw0rd1"
            ElseIf i = 2 Then
                strDatabase = "BTDB2"
                strServer = "SVR2"
                strUsername = "sa"
                strPassword = "P@ssw0rd1"
            ElseIf i = 3 Then
                strDatabase = "BTDB3"
                strServer = "SVR3"
                strUsername = 

Open in new window

0
Hi
Does anyone know how much a Microstrategy 9.0 - SDK License costs?

Thank you
0
We recently migrated to a newer management system. The previous System held a table (for clarity sake I'll name the fields the same between the two systems) called SalesContract.ARBalance this was a field that (often erroneously) held the Contract's Balance. How this was calculated and populated in the table, I don't know.
So the new system does not have a 'static' .ARBalance field, which is a good thing from an accounting standpoint (all calculations are done real time and from one filed) but not from a reporting standpoint.
My goal is to duplicate a Crystal Report used in the old system which grouped by amount owed e.g.

 
if isnull({Contract.ARBalance})then "Credit Balance - $0" else if
{Contract.ARBalance}<=0 then "Credit Balance - $0" else if
{SalesContract.ARBalance} in .01 to 300 then "$0.01 to $300.00" else if
{SalesContract.ARBalance} in 300.01 to 600.00 then "$300.01 to $600.00" else if
{SalesContract.ARBalance} in 600.01 to 1200.00 then "$600.01 to $1200.00" else if 
{SalesContract.ARBalance}>1200.01 then "$1200.01 and Above"

Open in new window


This was fine as the formula only needed to pull from that single field before grouping.

With the new system, I first have to summarize all of the transactions in order to get the above criteria e.g.

 
if isnull(Sum ({MDTrans.Amount}, {SalesContract.ID}))then "Credit Balance - $0" else if
(Sum ({MDTrans.Amount}, {SalesContract.ID}))<=0 then "Credit Balance - $0" else if
(Sum ({MDTrans.Amount}, {SalesContract.ID})) in .01 to 300 then "$0.01 to $300.00" else if
(Sum ({MDTrans.Amount}, {SalesContract.ID})) in 300.01 to 600.00 then "$300.01 to $600.00" else if
(Sum ({MDTrans.Amount}, {SalesContract.ID})) in 600.01 to 1200.00 then "$600.01 to $1200.00" else if 
(Sum ({MDTrans.Amount}, {SalesContract.ID})) >1200.01 then "$1200.01 and Above"

Open in new window



Obviously I can't group by the above formula as Crystal must first evaluate the groups before it can evaluate the summaries.

I need to display summaries for each of the above groups (.01-300, 300.01-600 etc.) How can I accomplish this?
0
Hello,


My report has 3 summary pages for three companies( I have used page break here). I created a bookmark drill through to navigate to the corresponding detailed pages of these companies.

Scenario 1

A->A (summarypage)->A(Detailed Page)
B->B(Summarypage)->B(Detailed Page)
C->C(Summarypage)->C(Detailed Page)

Similarly for other companies.

From detailed pages I created another bookmark drill through to navigate to the  summary page(reverse navigation).That means when I click on Go back button on the detailed Page of any company  it should navigate back to the Summary page of coressponding company.

Scenario 2

A (summarypage)<-A(Detailed Page)
B(Summarypage)<-B(Detailed Page)
C(Summarypage)<-C(Detailed Page)

This is how it should work.


When I click on the Go back button of  company B's detailed page , it should go back to the summary page of company B, but it goes to summary page of Company A. Same Issue happens for company C. The drill through from Summary page to corresponding detailed pages works fine(scenario 1) .

Scenario 2 works only for company A.

Scenario3:

A (summarypage)<-A(Detailed Page)
A(Summarypage)<-B(Detailed Page)
A(Summarypage)<-C(Detailed Page)

currently its working as Scenario 3

Scenario 3 is wrong,The way it should work is Scenario 2.

Please help

Thanks

0
Hi
What is involved in adding a company logo to the MSTR Web home page?
Does anything special have to be done to the image file being used for this logo, so as it displays OK in the MSTR Web home page?

Thanks
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
>