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've tried so many things up to now.
I'm trying to solve : "Verify that sufficient permissions have been granted and Windows User Account Control (UAC)" on my local report server. I'm unable to see the Home folder to grant permissions, when clicking the "Home" link, nothing happens
0
Hi,

I have found various posts here and online but cant find one that can do everything I need in one report. I would like to create a SQL Reports for SCCM 2012 to show the following information in one report

PC Name
MS Office Version installed
MS Project version installed(if installed)
MS Visio Version installed (if installed)
MS Visual Studio Version installed (if installed)


I have had a look at the post below but when I select Office version 2010 it brings back 5-6 entries per PC

https://www.experts-exchange.com/questions/28493616/SCCM-2012-determine-what-versions-of-Office-Users-currently-have.html
1
Newbie here so go easy.

I am creating a report based off a share point list. I have three columns total. The first two columns are based off of tables. The first column is called Created and the second is Completion_Date. The third column I added as a calculated field and what it does is looks at the dates in the first two columns and gives me the number of days between the two. This column is called Days to complete and has the following expression: =DateDiff("d",Format(Fields!Created.Value,"Short Date"),Format(Fields!Completion_Date.Value,"Short Date")) + 1

So when I run the report I get the following which is correct:

Created               Completion Date          Days To Complete
10/1/2016            10/3/2016                                  3
10/1/2016            10/4/2016                                  4

I also have the report group (don't know if that matters). Here is my issue. I would expect the total for days to complete to total 7 in the example above. I insert a row and on a single cell I put in the following expression [Sum(DaysToComplete)] but when I run the report I receive an error. What am I missing? I have attached a screen shots as well. How do I simply get a total on the days to complete based on it being a calculated field?
screenshot.docx
0
Hi Experts,

We are looking for a query builder tool for end users which can dynamically create parameters, export to excel, adhoc report capability. Please suggest if there are any. Has  any one used IZenda? can it do?

Appreciate quick response
0
I need some help on how to get a Grand Total of Vendor Spend from the Vendor Spend subreport into my main report.  Ultimately, I want to get the overall percentage of Total NC Dollars vs. Vendor Spend.

Please realize that the Vendors listed will change based on whether or not there was an Nonconformance (NC) written up for them and/or the time frame I am running the report for.

I'm at a loss as to what and where I would enter variables for this.
--mail-staylor--Custom-Reports-uniPo.rpt
0
Hi,

I am able to grab the Details in a Sub Report to the Details in the Main Report. The field is called CommRate. On the Main Report, it shows up correctly in the Detais section. Everything looks good, but how can I use that field in a calculation in the Details section in the Main Report?

I watched some videos and on the Sub Report, I created a field called CommRate with the following formula:

WhilePrintingRecords;
Shared NumberVar CommRate := {@CommissionRateSub};

On the Main Report, I have the formula called CommissionRate with the following forumula:

WhilePrintingRecords;
Shared NumberVar CommRate;
CommRate

I am trying to get the Commission Rate to show up on the Main Report in the Details section and be able to use it as a calculation. Right now, it shows zero with these formulas I created.

Any help would be appreciated.
0
Hello Expert

i want to design a report contain two table sale-order and sale-order-line

1 - sale-order contain order details like   -
 id  ordero   name        total-amount  ....
 1    o-112    MADDY     5000   ...

2- sale-order-line contain details like

id   order_id  product  unit_amount
1         1              abc           2000
2         2              xyz            3000

now i want to design i-report where i want to print sale-order and order-line of the order using subreport
how i can paas the parameter to subreport from main report ...
0
Hi,

I am using Crystal reports 2008 to report on the number of open Problems grouped by the month they were raised.

As we do not have open problems for every month, the cross tab only shows months where data is present. ie:
Current report
Is there anyway to get the cross tab to fill in the gaps, so a month is listed even though no data has been returned?
0
Is there a way in PSQL to look at the tables  in (PROD1) and see...

The Maximum possible ID for that table (Or set of tables)
And the current MAX(ID) in that table(s)

This is an old Oracle Database
I have access to TOAD 10.5.1.3
0
Any advice or tool suggestion is helpful and will get points!

I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. For example, installing a firewall, configuring content filtering, installing a switch.

My existing process is a word doc template and a one note full of steps that I paste in as needed. The problem with this is that it's too manual, has no time formulas, and I also need to corollate work instructions with each step. For example installing the switch is on the SOW but the work instructions are more detailed: update current firmware, configure client snmp string, etc...

To solve these problems, I shoved it all into excel and also got some nice math time estimating features. It's still alpha but looks like it could work, abit clunky, hard to manage and version, hard to share with a team, etc...

I've got a sql background and I know I could use something like access to make the forms and output report docs but I know that adp is dead and I'd prefer something web based.

I do not want to pay for a giant document management or proposal generation application which probably doesn't event have the key feature of tying the sow lines to the work instruction steps. I also don't really want to do the DB work and then have a custom program written just for the forms and document generation.

Ideally this would be a webapp (saas or hosted) where I can check some boxes, select …
0
Hi Experts,

I have a report.

I noticed when I open a report.rdl file in VS2013 I see the main part of the report.  When I do a deploy of that .rdl file and copy the link into a browser a Selection Screen appears letting the user select from drop downs.  When the user hits enter they see the report that I see when I open the report.rdl file.  So how do I see this selection screen when I open the report.rdl file?  There is a type fix that I need to do in the selection part.

Thanks for you help.
0
I am looking for an all in one MS SQL tool for my MS SQL servers.  The one that I am looking at is DBForge.  But I am not sure if this is a good choice or if there is a better tool out there that would be better and more robust to using SSMS.

Does anyone have any suggestions of alternative tools to SSMS?

Thanks
0
I have a Parent report and a child report. Each individually function correctly when 2 parameters are passed to it. Unfortunately when I put the child report (subreport) nested or not nested on the parent it doesn't render. Any ideas?

 I have even put a plain form as the subreport... nothing but a header and it still will NOT render the parent.

Please help
0
Looking for some help on a mail merge process.  I would like to group all students into one page however when I run the mail merge all the students have their own page instead of being grouped by school.  

I have the report grouped by school then by group by child on exam description then group by child on the exam date.  


When I go to mail merge in word it will list out the students as individuals.  Where do I add the group by school so all students who fit that exam description & exam date  are under the school.  Where is this option at?  Is this a word mail merge,  SSRS report builder, or done in the sql query itself?


select CONVERT(varchar,ME.members_exams_examdate, 101) as exam_date,
		mem.members_firstname, mem.members_lastname, 
		me.members_exams_id, me.members_exams_score,  me.members_exams_examdate,
		ex.exams_description, 
		sc.schools_name, sc.schools_city, sc.schools_state	
from members_exams as me
join exams as ex
on me.exams_id = ex.exams_id
join schools as sc
on me.schools_id = sc.schools_id
join members as mem
on me.members_id = mem.members_id

Open in new window



This is what the report look like:  
Report.JPG
This is what I am able to get from the mail merge:
Single.JPG
This is what I am looking for :
group.JPG

Thanks for your help,
0
I'm trying to build a program to sort out a stream of statements into relevant and non-relevant statements with regards to a particular domain name. What algorithms and frameworks would be helpful?

I shall clarify further with an example.

 Let me pick a subject like economics. For a given group of sentences and phrases, I should be able to sort out each of those to determine whether they belong to the field of economics or otherwise. If I see something regarding cooking or the weather, I should put that in the irrelevant category, and if I see something with regards to profits and GDP, I should include that in the relevant category. I understand that I should have some sort of knowledge base for that particular domain ie. economics.

I need pointers to where I can start.
How do I go about collecting the domain data?
What basic process structure should the system have?
I'm planning to use Java for the implementation.

Tutorials would also be very much appreciated.
0
Trying to add a parameter to a standard report that will restrict records so that only customers that have accounts 45 days past due will have a statement generated.  Any thoughts would be greatly appreciated!
0
Hi experts!

I'm using PowerShell to render SSRS reports. The report I'm trying to render has a parameter that is dependent on the value(s) selected from the first parameter. I'm trying to obtain the valid values for this parameter. Is there a way to do this please? This is the code I have so far:

#--------------------------------------------------------------
# add assembly
#--------------------------------------------------------------
Add-Type -AssemblyName "Microsoft.ReportViewer.WinForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

#--------------------------------------------------------------
# create timestamped folder
# where we will save our report
#--------------------------------------------------------------
$dt = Get-Date -Format "yyyy-MMM-dd hhmmtt"
$baseFolder = "\\Folder1\"
$tempfolder = "\\Folder1\Excel files\"

# if the path exists, will error silently and continue
New-Item -ItemType Directory -Path $baseFolder -ErrorAction SilentlyContinue | Out-Null

$ReportServerUri = "http://ServerName/ReportServer//ReportService2005.asmx?wsdl"
$global:proxy = New-WebServiceProxy -Uri $ReportServerUri  -UseDefaultCredential;
$items = $global:proxy.ListChildren("/", $true) |
         Where-Object {$_.Path -like "/ReportFolder/*"};

ForEach ($i in $items){
#--------------------------------------------------------------
# report Server Properties
#--------------------------------------------------------------
$rv = New-Object …
0
My application is a Windows Form Application. I am using Visual Studio 2015, Visual Basic (VB.Net) and I am creating my reports with ReportViewer. And that works great for reports that use the Table format.

What I want to do is create a report that has an IRS form image on it with fields that automatically get filled-in with information that is stored in a .accdb Access database. A table format doesn't work because the fields on the report are not in a table format. The fields are scattered in different places on this IRS form report. I was able to do this in Access VBA, but I can't figure out how to accomplish this with ReportViewer.

Is there a NuGet Package that I can add in to Visual Studio 2015 that will enable me to create a free-Style type report. Or is there another reporting package that creates this type of report that I should use?
0
I've created a backup report job on a weekly basis.  Every Friday it emails a report of all the jobs that failed/completed during the last 7 days.  I have one backup job that failed yesterday(says cancelled).  Because of this the report is ONLY showing the one cancelled job and not the 3-4 successful jobs before that.  All the successful jobs reported 7 days worth.  I tried to Google but due to the complexity and the exact issue, I didn't get many results.
0
I have  a table with field names "0616" "0716" "0816" etc for 24 months. These fields contain numbers.
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a CASE statement to replace this excel formula.
=IF(TDMMYY="0816",(N2+O2),IF(TDMMYY="0916",(N2+O2+P2),IF(TDMMYY="1016",(N2+O2+P2+Q2))))

I think it would start
CASE
WHEN 'TDMMYY' = '0816' THEN ...
what would the expression be to add the numbers from the fields named "0716" + "0816" + "0916"
please see attached sheet for screen shots that may make this clearer.

As always, Thanks you for your assistance.
case.docx
0
Hello Experts Exchange
Does anyone know where I can get a UK map with all the postcodes in it so I can use in a SQL Server Reporting Services report.

If you could provide where I can download it that would be great, if I need to purchase please provide URL.

Regards

SQLSearcher
0
Hi Experts

Using Microsoft Visual Studio 2008

Is it possible to create a blank BlankReport.rldc with Header information and create the Table columns and Textboxes on the fly in the
BlankReportDefinition.vb

If so how, where to look and an example would be great

Thanks
0
Hello Experts
I'm looking more of an advice than an answer here.
We are looking to purchase a tool that can help with code migration - this can be DB procedure/ package/ views, DML, DDL statements and also take backups of all information before they are modified.
this can be one or combination of the above mentioned and can have a specific order of execution.
This tool should also maintain code and deploy into dev/test  and prod as needed.
Do you know if there is any such tool in the market?
This is to be run against 11g and 12C Oracle databases.
Thanks in Advance
1
I am creating a billing statement from a SQL DB using Crystal Reports, and need to come up with a way to handle multiple payments for one invoice. The attached statement demonstrates my problem. I'm assuming I need to create a view in the SQL DB, but need help. Here is my thought process:
1. Apply the parameter to select the correct job number from [jobs.job_no] (this is working fine in my Crystal select with a parameter)
2. Get the full invoice amount from [ar_invoice.invoice_amount]
3. Check [ar_cash_receipts.cash_receipt] to see if there is a payment
4. If there is a payment in full, then apply the payment value and the resulting balance due is 0
5. If there is a balance due after a partial payment is applied, then create a result with the value of the remaining balance due.
6. Now the invoice_amount should become the remaining balance from the result above, and any future payments would continue to be subtracted until the final balance = 0

Currently the report I've created does not know that a partial payment has been applied, and if a partial payment is made, the invoice repeats at it's full amount when another payment is received.

If there is a better way to do this please advise as well.  Thanks for your help!
0
Hi DB2 gurus,

I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some assistance from the experts in this group. my question is this:

Given the following critical events in a DB2 database environment, which of the following tools that follows can be used to investigate each event?

What I am looking for is this: I am looking to match a specific type of DB2 system event like I listed in this post and the best tool that can do the best job in monitoring for that event. The more event type a tool can monitor, it rates high or higher depending on how many event that it tool totals.  Can anyone contribute in this regard?

Critical Events---
Server failure
Database crash
Log space ,temp space, database data ,database log ,home file system utilization exceeds threshold.
Pre-defined Key words appear in the system (db2diag.log) files denoting a critical event occurring.
Time to get a lock exceeds a threshold.
Connection can not be made to the database.
Percentage of applications waiting for the Locks.
Memory Usage exceeds threshold.
Scheduled benchmarks queries exceeds threshold.
Required process not executing.
Swap space exceeds a threshold.

Monitoring Tools:---


Alarm Point
BMC Patrol
DB2 Governor
OPM
WLM
TIVOLI
Ganglia
IP Monitor
NAGIOS

Any and all your considered experience and comment will be highly appreciated.

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
>