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

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

Manager
0
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
{tcspodet.psuppcd} in ["ACCWEL", "ADVWEL", "AERSUP", "AERTES", "AGCINC", "AIRWEL", "AMKWEL", "ANOPLA", "BALCOM", "BENHEA", "BODBER", "BODWOR", "BOUMAC", "CAMTEC", "CINTHE", "COLCOA", "CONINS", "CONMET", "DAPRA", "DICTES", "DIPBRA", "DIRLAB", "EBTEC", "ELEMET", "ELLSUR", "EMCOR", "FLAPRE", "FOUPLA", "GENBUR", "HARCON", "HARLIN", "HAYHEA", "HITEMC", "HSEPF", "HYDHON", "HYGPRE", "INDINC", "INDSAW", "INTBEA", "INTFAC", "JETTEC", "KENEXT", "METALI", "METFIN", "METPRO", "METTES", "METWAK", "MOUBAS", "NECUST", "NEHTS", "NITCOR", "NYLWES", "OWHEA", "PARPRO", "PLAPLA", "POLFIN", "PRAAIR", "PRASUR", "PRAXAI", "PTIIND", "PURCOA", "QUAMEA", "RIVMAC", "RONMAR", "SIFAPP", "SPESTL", "SUPTHR", "THRROL", "UNAGRI", "UNICEN", "UNIGEA", "USCHRO", "USCHWI", "VALPLA", "WESELE", "WESPEN", "WETTOO", "ZZTOOL"]

If I remove some of the …
0
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
ATT_1457616719644_Capturevaluesnotdi.PNG
ATT_1457506199268_Capturehalfreport.PNG
0
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.
0
hi am in report 11g am having this error when runing the report what could be the problem
REP-56048: Engine rwEng-0 crashed
0
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

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
>