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

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

gauge
0
Hi,
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,
Pooja
twbx1.PNG
expected.PNG
0
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.
0
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.
0
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.
0
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.

Thanks,
VAPV
0
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…
0
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.
0
Hi,

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

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

 Thanks,

Kfs
0
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.
0
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
0
Hi-

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?

Thanks!
0
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
Footer properties
No list
PDf sample
0
Hi,

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 ?

Printer_Prop.png
0
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??
0
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:

table
0
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)

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