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

 Is there any function in SQL which will allow to to hide cells on my Visual Studio report if theres another cell which is currently showing ?

The data I am reporting from has a user with access to one or more (for instance) branches. The report shows data from one branch. I'm passing in two parameters (user and branch); I'd like to be able to hide the user parameter if I can, as it will be a constant for any given run of the report.
As well as the dataset for the report which is based on the Branch code, I also have one based on
"SELECT Branch, Name from tbl_UserBranch WHERE userID = @user"

Assume User 1 has access to branches A and B. The initial report selection URL is &user=1&Branch=A. I now want the user to be able to select Branch B and click the View Report button again. Can I do this without needing to select the user again, and if so, how, please?

I am trying to create a report in VS 2008.  I have ReportViewer  When I drag the report viewer control to the web page I get an error:  "Error Creating Control:  ReportViewer.  Failed to create designer "Microsoft.Reporting.WinForms.ReportViewer, Microsoft.ReportViewer.WinForms, Version =, culture = neutral, . . .

I have every thing else designed: dataset, report, etc.

Can anyone help me resolve this problem?
Is UTF-8 a requirement for the metadata and/or data?

Note:  We are using Oracle 10g
I write a sql function and publish to Cognos via Framework manager. I am not sure anyone here can help?

It does not work.

The function shown in Congos Report studio:
"OutputDate;0" (MyDate)
The message say it is not working.

--my sql server function code
create FUNCTION [dbo].[OutputDate]
      -- Add the parameters for the function here      
      if (@INPUTDATE is null)
            SELECT @MYDATE = GETDATE()
      if (Year(@INPUTDATE) = 1900)
            SELECT @MYDATE = GETDATE()
      -- Return the result of the function


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?
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 …
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?

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:
ID               BigInt Not Null (Identity)
parentID     BigInt Not Null
catName     VarChar(Max)

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

That contain the following data:
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

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'?
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?

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?
I have just got a job for business analysis (specificaly for customer segmentation) I wondering which good books to buy and read
I need to know how many plans can i create by application in Oracle Hyperion Planing and where i can find this answer (reference)

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.
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
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?

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" …
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 ?
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.  

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?
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?
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.

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


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!

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?

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

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