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 new to the SSRS reporting building. Can you please suggest/correct my expressions for the report calculated field?
 
 IIF(((IsNothing(Parameters!AgeByDueDate.Value)),
 (IIF((Fields!adItemAgeByItemDate.Value >= 0 AND Fields!adItemAgeByItemDate.Value <= Parameters!AgeBreak1.Value),0,Fields!exCalculatedReportingOpenAmount.Value)),
 (IIF((Fields!adItemAgeByDueDate.Value >= 0 AND   Fields!adItemAgeByDueDate.Value <= Parameters!AgeBreak1.Value),0,Fields!exCalculatedReportingOpenAmount.Value ))))

Open in new window


Many thanks
0
New to SSRS. I watched a PluralSight tutorial and got help here as well.

This is SQL 2014

I created a sample report and want to deploy it. However, I'm getting an error:

Could not connect to the report server http://msi:666/ReportServer_MSITRADER. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

I did the following. I'll keep Googling and see what else I can find

1. I checked the URL here. It was "80" at first. I tried 8080 and 666 just to see if it works

SQl 2014 Reporting Services Configuration
2. Clicked on the URL itself  http://msi:666/ReportServer_MSITRADER
and got this error. The "online help" link is an old one and doesn't offer info. It's says "sorry, there aren't any additional info" or something

Reporting Services Error
The report server has encountered a configuration error. (rsServerConfigurationError) Get Online Help
SQL Server Reporting Services

3. Double checked the connection in Visual Studio and it's the correct URL

Visual Studio
4. I checked the installation

Installation
0
I'm following Kimball Fact - Dimension design principles, but I've encountered a scenario that lends itself to a Snowflake structure, which I'm trying to avoid.

In our ERP, we have a table that contains both customer and vendor information.  Here is a simplified version:

BusinessPartner Table
BP_ID,
BP_Type,  --either Customer or Vendor
BP_Name,
SalesPersonCode,   -- this only occurs on Customer records
AssociatedCustomerID  --on some Vendors, this will be the BP_ID of an associated Customer

So, for example, we have:
BP_ID  |  BP_Type  |  BP_Name  |  SalesPersonID   |  AssociatedCustomerID
1           |      C          | FooBar        |           123                   |   NULL
2           |      V          |  BlueBar      |         NULL                  |   NULL
3           |      V          | ShoeBar       |        NULL                  |    1

Certain accounting transactions will reference the Vendor ID, but these need to be associated with a customer ID in order to tie them to a salesperson.  To help explain the relationship here is the SQL Query I'd use against the ERP table:

SELECT v.BP_ID, v.BP_Name, c.SalesPersonID
FROM BusinessPartner v
INNER JOIN BusinessPartner c ON c.BP_Type = 'C' AND c.BP_ID = v.AssociatedCustomerID
WHERE v.BP_Type = 'V'

note:  this is NOT the query I'd use to load data for the datawarehouse

1.  Should I split this BusinessPartner table up into a Customer Dimension table and Vendor Dimension table or keep them in …
0
Hello EE,

I am hoping you may be able to give me some direction on this problem we're having with SSRS 2008R2.

2 Reports:
Source - has no parameters
Destination - has 2 parameters, EmployeeID & DateOfBirth

Goal: Call Destination report sending only 1 of the 2 parameters from Source and then have Destination report prompt for remaining parameter.

Example: Source report displays new hires for the day.  One of the new hires is selected which calls Destination report sending only the EmployeeID.  Destination report receives the EmployeeID from Source and then also prompts for the missing parameter, DateOfBirth.

The above example works if the reports are run from within Visual Studio.  The example fails, however, once deployed to SharePoint and run from there.  What happens in the failed run, via SharePoint, the Destination report shows only the error of a missing parameter but does not display the parameter entry bar.

Interestingly, however, the above goal works if the Source report has any incoming Parameters.  Say, for example, the Source Report asks for the color of your shoes, and then calls Destination report once an employee is selected, it works.  The parameter on Source doesn't even need to be used in any way, just the fact that it prompts for it allows for the Destination report to prompt correctly.

Any ideas?

screen1: Source running in Visual Studio
screent1-SourceNoParams.jpg
screen2: Destination running in Visual Studio after being sent a parameter from Source
screen2-DestinationInVS.jpg
0
Hi everyone,

My team is using JasperSoft Studio to design/create reports for our customers. We've created all of the report templates and know how to manually run the reports and save them to PDF; however, we now need to automate the process. I've researched this for the past several days and have yet to discover any functionality that would allow for automation. Ideally, the customer will upload a data file that our product creates for them to a web app, and we'll pass that data file along with the report template to JasperSoft Studio. In return, the customer will receive a PDF of the completed report.

We are using JasperSoft Studio 6.2 and are required to use this software. Additional software can be incorporated into the solution, but support of the jrxml file format (the format of the report template) is necessary.

Any help/advice is appreciated.

Thank you.

(PS. I know that the selected topics aren't a great fit)
0
Experts,

I have a table has data in scattered  columns (Dx1 - Dx12).  Can someone tell me how to move the data from all respective columns to ensure that columns 1 -4 are populated when they are blank.

See attached spreadsheet. ( I would like the data moved in order from its respective column to columns 1-4).
Move_to_Four.xlsx
0
I ,  mean my company, have Licensed GrapeCity.Active Report 9. I have been using it with Visual Studio C# project.
But recently I cannot open any report in design mode.
It says, Could not load file or assembly 'GrapeCity.ActiveReports.VisualStudio.v9, version = 9.0.1678.0,Culture=neutral, PublicKeyToken=cc4967777c49a3ff' or one of its dependencies. The system cannot find the file specified.
I am not good at handling dll files. Please let me know what I can Do.
I don't see GrapeCity.ActiveReports.VisualStudio.v9 in Library folder.
Do I have to have it?
Please help me
0
Hi Experts,

I am creating an iReport where I have one Parameter called "Date", I want to extract year from the date parameter. Please suggest me syntax for this.

Thanks
0
I can open the report server home page on a remote server from my own Chrome or IE browser after connecting to my vpn but no matter what I try I cannot get it to deploy to the same server url.
It even prompts me for username and id but always ends up saying it can't find the url.
0
I'm trying to use the iif logic on two text box properties but it doesn't seem to be saving the expression.
1) Under the Border Color property I can set it to  =iif(true, "Black", "Red"),but after I save the Text Box properties it drops the expression and sets the color setting back to its default Light Gray.
2) Same problem with the Border Width:  =iif(true, 1pt, 3pt) drops the expression after saving the Text Box properties

Any ideas?

Thanks,
- Dan
0
I'm building a report that will compare a field from one table to a field from another table, and change the font color based on the result of the comparison.

(T = Table, F = Field)

If T1F3 does not equal T2F3 then change T1F3 font color.

Table 1 & Table 2 are from different datasets.  The report is a sub-report which receives its parameters on load.

Is there a way to have an event triggered on report load to do this comparison & action?

Thanks,
- Dan
0
I have a report that has a tablix grid in it and a textbox with some legal info on it. I'd like the legal info textbox to not show when an item type is not in the tablix grid. I have a column "item_type" and those rows contain #s that identify that type of item it is. I'd like it to hide the textbox if item # "804800001" is in any of the rows of the item_type column. I have:

=IIf(First(Fields!item_type.Value, "ProductLineItemsAndAmount") = 80480001 , False, True)

but using this it either always shows or is always hidden (depending on the order of True, False), so it's not reading the rows in the item_type column.

I got the field info from the expression dialogue (clicking on Datasets then Item, then value).
0
Trying to create a SSRS report using Report builder 3.0, calling a stored procedure in sql 2012 R2 i have very little experience with ssrs.  I am able to connect fine and execute the query in the from the datasheet.  I see all my results in the query designer.  When we execute the report and pass in the same values nothing is returned.  The connection string checks out fine, the only values i see on the report are the parameter values.  I have attached 3 screen shots not sure if they will help.,
query1.PNG
query2.PNG
query.PNG
0
Hi,

I was wondering if there was a way to have highlighted conditions for the format of the y-axis labels. I currently have a formula field set the Y-Axis on my graph, the formula is made of other fields, I added a picture example below, I know I could do this with the data in the graph, but I would also like the label to stand out as well :

totext({@noWeekEnds1}-{@test1},0) & "/"& totext({@noWeekEnds1},0) & "..." &  {projets.prjNumber} &" " & propercase({clients.cliName}) & "..." &  {@tester1}*100 & "%..." &  {budget.revenue} & "$..." &  {@percent} & "$"

If not would there be a way in the formula to make only 1 value a different color? such as the  {@percent} formula field


Example
0
Hi,

I have a number of automated reports that are e-mailed from our SQL server on a daily and weekly basis.

Nine times out of ten, these reports run fine but occasionally they are not delivered to the recipients...

On further investigation, it appears that the e-mail was not delivered because the table/results were empty for that particular day.

For example, we have a report which lists how many telephone calls were made by a particular team. Behind the scenes, there is a view which compiles the data based on user ID, extension, etc. but the end result is a simple table showing how many calls were made in the last 24 hours.

When no calls are made, the e-mail is not delivered. This isn't ideal as from a user's perspective it looks like an issue. Also, I have a report with three separate tables in and when one of the tables does not have any data in - the e-mail is not sent.

Would it be possible to have the table show zero values, or just the table headings instead of not sending the e-mail at all?

I look forward to hearing your thoughts and comments.

Thanks in advance!

PS. An example of such a report is below:

DECLARE @title nvarchar(200)
DECLARE @tableHTML nvarchar(MAX)
SET @tableHTML = 
N'<style type="text/css">h2, body {font-family: Calibri;} table{font-size:14px; border-collapse:collapse;} 
td{text-align:center;background-color:#F1F1F1; border:1px solid black; padding:4px;} th{background-color:#99CCFF; padding:4px;}
h4{font-family: 

Open in new window

0
Hi guys,

I want to make a tablix invisible if a certain value does not exist in a dataset (not linked to the tablix in question).

So I want to make tablix invisible if value moc_environmental_impact_cl does not exist in dataset 'value_check'

Many Thanks,
Dean
0
I need to add a row that has the totals for 'count' and 'revenue' at the bottom. In my case count is 1 every time.


$objPHPExcel = new PHPExcel();

$result = domain_funcs::HHH_rev_details($from, $to, $domain, &$db);
$data_title = "HHH_details_$domain-$from-$to.xls";

// Set properties
$objPHPExcel->getProperties()->setCreator("$domain HHH Report")
							 ->setTitle("HHH Report");
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle("HHH Report");
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50); //Place
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20); //Date
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); //Trans Count (1)
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); //Revenue	 

$objPHPExcel->getActiveSheet()
				->setCellValue("A1", "Place")
				->setCellValue("B1", "Date")
				->setCellValue("C1", "Transaction Count")
				->setCellValue("D1", "Revenue");
$objPHPExcel->getActiveSheet()->getStyle("A1:D1")->getFont()->setBold(TRUE)->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle("A1:D1")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('E5E8C7');
$excel_row = 2;
	

$count = mysql_num_rows($result);
if(mysql_num_rows($result) > 0)
{		
	while($row = $db->get_next_row($result))
	{
	    $school = $row['place'];
	    $thedate = $row['ldate'];
		$domain_name = $row['domain_name'];
		$Count = 1;
		$revenue = 

Open in new window

0
Experts,

I have a requirement of installing the "CERTIFICATE" for Jaspersoft. Can someone provide me with the details on what is involved with "..installing the CERTIFICATE...". I believe this certificate is actual a PRIVATE KEY that allows access to our Jaspersoft Server.

ANY and all information on how to install the Certificate would be greatly appreciated!

THanks
0
Can anyone recommend a "simple" Report Generator for printing Excel/CSV files?
Just need to print a 1-page Report for presentation with line breaks, sorting, maybe filters.
Emphasis on Simple ... want to be able to spin a diff version of a Report while presenting in front of a group.
Do not need color, not graphics/images. Mostly Report Title with Line spacing, line breaks, etc to look neat & understandable.
It would be a bonus if there is a MAC version, but we can always run it on the PC/Windows.

:)
0
Hi
I wonder if there is a tool that convert Crystal Report into Jasper Report.
Regards.
0
Hi All,

I have a report which gives me daily sale at specific interval through out the day.

I want to display this report on a report machine like a LED MONITOR.

How can i do that and is there any software available in the market which i can use? i dont want to write a client server application myself.

Thank you

A
0
Hi,
I have 1 SQL server instance (A) running for my application, and is it possible to have another instance (B) which is running parallel sync (mirror) with the (A), and serving for reporting only?

That mean Active-Active. (A) is for main application, and (B) is for reporting.

if possible, pls advise how?

Thanks
David
0
We are currently in the process of compiling reporting in order to make some projections with our cloud/storage environment.  However, we currently have no baseline(s) in place, with regards to monitoring software.  Does anyone have any recommendations/suggestions to gather/compile information based on event logs, etc. for predictive analytics (i.e. data transfer, SQL transactions, etc.)?  Looking for the most common/specific counters for IIS, FTP, and SQL traffic.
0
I am looking for a tool (library, free program, robust propriétary tool...)  able to access my banks, ask for my transaction data, retreive them and string them under an identical format whatever the bank in the world. NOTHING more.
Does this exist?  

Thank you for the help
0
I need some help setting up SSRS for the first time.
My goal is to build/edit reports from my desktop using Visual studio 2013.

Here is what I have so far:
Server:
SQL server 2014
Reporting services Config manager it is setup with a database called ‘ReportServer’ and  virtual directoy and URL of ‘Reports’
From my PC, the URL takes me to a home page with folders and with a link to launch ‘ReportBuilder’
I think the server side is working ok

My PC:
Installed Visual Studio 2013
Installed  BI Tools for 2013
From My PC, I can open a new project and build some basic reports

Concern is that the PC install is not looking at SSRS on the server in anyway, it is all self-contained on the PC.
I was told to configure Visual Studio to point to the SSRS server. I am not sure how to go about this. Can anyone guide me what need to be done, or any other issues with my setup.

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
>