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 modifying reports that someone else wrote and it is going good except for one silly thing.  In the invoice report, there are static labels for Ship To and Bill To.  They are right above an address field that is sometimes null but the label still shows

I have looked everywhere - in the expression, in the group but cannot find these labels.

Please help.

I built a gauge in SSRS and added 3 pointers.  Each pointer is based on a product's manufacturing group.

So, for example, there's a white pointer with an expression as the value:
=IIF(Fields!Manufacturing_Group.Value = "White", Fields!Total_Labor_Hours.Value, 0)

Open in new window

And a blue pointer:
=IIF(Fields!Manufacturing_Group.Value = "Blue", Fields!Total_Labor_Hours.Value, 0)

Open in new window

And a brown pointer:
=IIF(Fields!Manufacturing_Group.Value = "Brown", Fields!Total_Labor_Hours.Value, 0)

Open in new window

I don't want to see a pointer if the value is zero.  How can I conditionally hide a pointer?

I had this question after viewing Tableau 9.2 using SQL server2014.

Am new to tableau. I try to get grand total for the particular sheet. But am getting the message like " Cannot turn on Grand totals for discrete measures" on the sheet "Budget1" . Please help me how to get grand total. Let  me send my current work around and expectations.

1. Created measures over columns for adency divisions (rows). This time i could get grand total, but i lot bars next to %spend..please advise...

Kind regards,
I am trying to dynamically link a photo to an external file on the network.
I inserted an image box. selected External and entered the following in the expression:

="file://SSEPICOR10/EpicorData/EmpPhoto/SS/" & Fields!PhotoFile.Value & ".bmp"

All I get is a red X when I run the report.

Any help will be appreciated.
Hi there, I'm working with SSRS Report Builder 3.0 and have two cascading parameters that appear to be working fine.

I have a dataset set up for Param1 and another dataset configured for Param2.
The Param1 dropdown list works fine, and passes the correct Param1 values to the Param2 dropdown list which shows the correct sublist of items available for multiple selections.  

I have the main dataset edited in the 'Where' clause to filter to the items selected in Param1,, and also to filter to the items selected in Param2.

The problems:
1) When i have both filters applied in the where clause, no records are returned although the cascading parameters appear to be working fine.

2) When i remove the Param2 filter from the Where clause, all of Param1 matches are returned, but Param2 selections are not applied.

Not sure how to confirm this but my guess is that Param2's values are not in a format that the report can use, and I'm not sure about how to resolve this issue. I've found multiple articles on cascading parameter configurations, but I'm apparently missing something around the sub-list and how it passes values to the report to use.  Any assistance would be appreciated

Also the parameters used in the where clause are in parentheses () and i'm stating to look 'IN' the parameter value, and not using '=' equal to.
We are looking for a database, virtualization, and network monitoring tool that can be used in a hybrid cloud / physical environment.  Can you please recommend a tool that is simple to configure, is cost effective, and reliable?  We currently use vFgolight and have looked a Solarwinds.
Hi All,

If anybody has any experience in Hyperion IR to SSRS migration would need your help I would like to know the feature comparison and if there are any compatibility issues between the two reporting solutions.

Any help is highly appreciated.

Hi Experts,

I'm working with Visual Basic 2013, MySQL, Sap Crystal Reports and connection with ODBC, I already made a couple of reports successfully, but now I'm trying to make another report but I can't find a way to do it.

Table: temporal1

Key    Fecha              City                     Office             Docto_A     Docto_B    Docto_C      Total
0001      2016-03-15      Los Angeles     Sede               256             111             12                10,000.00
0002      2016-03-15      Los Angeles     Sede Mat       125             114             12                13,000.00
0003      2016-03-15      Los Angeles     Sede Vesp     130              87              12                 14,500.00
0004      2016-03-15      Los Angeles     CSR1               478             121            12                  9,200.00
0005      2016-03-15      Los Angeles     CSR2               201             67              12                  17,600.00
0006      2016-03-15      Los Angeles     CSR3               995             402            12                   4,500.00
0006      2016-03-15      Chicago            Sede               916             402            12                   4,500.00
0006      2016-03-15      Chicago            CSR1               985             402            12                   4,500.00
0006      2016-03-15      Houston           Sede               995             409            12                   4,500.00

As you see, I have six…
I need to check specific user and group what permissions are assigned to reports created in sql server  reporting services.
SQL server and reporting services are sql 2008r2.

How can I combine same ID's comments and display it on each column?

Below is the current data output:

ID        Line     Type   Comment
23         1           A         This is
23         2           B          Test
24         3           B          Null
25         1           C          Testing
26         1           B          Testing

Below is what I want to display:

ID        Line     Type   Comment
23         1           A         This is Test
23         2           B         This is Test
23         3           B         This is Test
24         1           C          Testing
25         1           B          Testing

Thanks in advance.
Environment:    CRM 2011, RU 14, SQL Server 2012, Visual Studio 2010

I have some SSRS reports that I need to make some minor changes (field names, remove fields, etc).  Can you tell me the easiest tool to use and where I get it.  I have created and modified RDL based reports before but it was a long time ago.

I have access to whatever software I need so what should I download to quickly modify the rdl and re-attach it to CRM.

I had this question after viewing Power Query Switch Function vs If statement.

After numerous hours of researching this issue for 2 days, I am really stumped.

I have tried to create a simple function of either If or Switch and both return the above mentioned error.

I even created a sample based on the example supplied on MSDN for the IF Function, trying to use it both in the Power BI Desktop and/or Power Query for Excel 2013 (32 bit) environments. Without any luck.

I am using the latest download of Power query and PBI,  I just set up my computer in the last week.  Urgently need of help.


I built my first SSRS report. We have 2 requirements

1. Send the SSRS report in form of PDF to *internal users*. To do this, I email the internal users a link to the SSRS report in PDF format. I also email them a link to the actual report to view it on the report server.

2.  We have to email the report to external users/clients. I can't give them a URL in email. The report has to be in PDF format, attached to the email.

I can get the report in PDF format using the SSRS URL with "PDF" as the format. But, anyway I can attach this to an email? Someone here said I need to use memory stream.

This is MVC/ C#/ SQL 2015.
Hi there, after trying for three days, i'm asking for assistance. Not sure how to post this, so here goes.
I’m building a drill down ledger report in Report Builder and need to return a SUM of the total posting amounts of the matched child codes based off of the parent code.

Basically this is the flow.

Field 1 - return store
Field 2 – return statement code
Field 3 – return posting dollar amount of code in Field 2

Logic for Field 3:
If parent code in field 2 has one or more associated child codes then lookup and sum the posting dollar amount for all the child codes and return that total.
If no child codes exist, then simply ‘return posting dollar amount of code in Field 2‘

What’s the best way to handle this, and would you have any sample code to get me started or through this.

Much appreciation

Looking for some practical advice. I'd like to download about 10 million rows of data from a SAP BusinessObjects data warehouse. I don't have direct access to the underlying database(s). The problem is that when I build queries, the result usually times out before I can download any data. It seems that it chokes at about a million rows, so I'd like to divide the data into manageable chunks. I DO have the capability of writing queries in SQL directly, but I don' t think I am allowed to make temporary tables, So....

How do I write a query that downloads a fraction (say 5%) of the database each time I run it? Is there any way to automate this process and then cause it to download the results automatically? For that matter, is there any way to determine the underlying database?

Still on my first SSRS report :)

I have a "Footer". I have it because the report might go longer than one page and I need to keep the header and footer on all pages.

On "Footer", I need to display a section for contact names. For example, 5 names. I have a SQL statement/Dataset that brings back the 5 rows of names.

Now, I have the "Footer". I added a "rectangle". I want to add a "list" but it's not in the list to choose from. I tried it yesterday when I added it to another section (not header or footer). So, how can I add a list of rows to footer.

Please see below.
Footer properties
No list
PDf sample

In our reporting application, we are using Active Report version 9 with vb.net 2010 for reporting.

Here then we want to override some functionality when user clicks on "OK" button on printer property while printing the report (I have attached a screenshot detailing the same).

Does anyone know if there's a way to call vb.net function when user clicks on "Ok" button on printer property page.

Any ideas ?

I built my first SSRS report. It's a letter with confirmation number on top, the company image, date and the address.

In the middle of the report, I have the order detail.

At the bottom, I have the names of the people the letter is going to. For example, "CC" with the name.

Now, sometimes the middle section is long and we will have 2 pages of the report. On the second page, I will have the same "top" and "bottom" but the rest of the "middle" detail goes on the second page.

How can I do that??
My first SSRS project is going well :)

Now, I want to show several rows of data for a field. I added a table and the SQL statement I added to the dataset brings back 2 different rows of data. This is correct. I see it in SQL Management.

Now, I open the report, and I see 2 rows of data (2 rows is correct) but the 2 rows are the same. It's not like what SQL shows. I even tested the SSRS dataset and it brings back the correct rows. It's just when it's displayed in the table that the first row is repeated.

This is SQL 2014

So, am I using the correct control in SSRS? This is how it looks like:

I'm building a report...it's actually an invoice letter. On top, there's a field, Customer PO.

There's a main table, table A, and a second table, Table B. This field is in Table B and this table can have several rows with CustomerPO that relates to the main table, table A

I'm displaying CustomerPO on top of the report.

Is there anyway to have 2 SQL statements in a dataset? one to bring the customerPO and one to bring the rest of the data? I don't think because I tried it and "query designer" threw an error. Looks like there can only be one select statement.

Do I need to create a second dataset?? (I just thought of that)

I'm new to SSRS. I setup a ReportServer locally on my laptop and it works. I can deploy a report, open the report server database and look at the tables. So far so good.

This is SQL 2014

1. We have a Test server and I see 2 databases on it: "ReportServer" and "ReportServerTempDB". When I click on the databases, I get this message.

2. I restarted Services and tried it again but didn't work.

3. I can see it setup in this screen and I tried "test connection" and that worked. The ReportManager Web Services and Manager URLs work as well. So, howcome I can't open the database? Should I create another Reports Server database?

Hello, I am getting an error when running a Crystal report. It first says “Failed to open a rowset”. I click “OK” I then get the following:
“Failed to open a rowset.”
“Details: S1000:[Microsoft][ODBC Visual FoxPro Driver]SQL:Statement too long.”

I know why I am getting the error, I just don’t know how to fix it. If it can be fixed. The problem is I want to report on a group of vendors. These vendors do not have any unique identifiers to group them by other than their ID so I have to list them out. Here is the gist of the report:

{tcspodsq.psopen} > 0.00 and
{tcspodet.postatus} <> "C" and
{tcspodet.popen} > 0.00 and
{tcspodsq.psdte} in {?FROM} to {?TO} and

If I remove some of the …
hi am in oracle report my report does not dislay the body it only displaying header and footer what could be the problem,but i can dispaly in report developer
Currently I have a main report, ReportA.  It contains a single parameter when it drops down it has about 15 items in the parameter.

I would like to create 3 linked reports from ReportA but I want to limit some of the available items listed in each reports parameters.

1. Created Link report 1 with only 4 items listed in the parameter
2. Created Link report 2 with only 7 items listed in the parameter
3. Created Link report 3 with only 11 items listed in the parameter

Is this a possibility, how would I create some sort of parameter filtering in the linked reports to make this occur.
hi am in report 11g am having this error when runing the report what could be the problem
REP-56048: Engine rwEng-0 crashed

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