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

This is related to the question I asked here. Mark Wills and Chinmay had great input.

https://www.experts-exchange.com/questions/29110740/Sanity-check-for-the-dymanic-Report-code-ex-developer-wrote.html#a42634519

I looked at the links Mark has in the question above. My manager is going round and round.

We have a Query Builder custom page that the ex-developer built. I've cleaned it up a lot. Just one more section that needs to be changed (ex-developer has hardcoded IDs and I need to change that).  I'm taking Mark's advice and just cleanup one more section and take the approach of "it works".
Now, my manager says we need to look at a 3rd party tool.
Things to consider.
a. it has to be part of our website. User can't open a new tool. It has to sit on our data and integrated into our website Like drop-in controls..similar to Telerik maybe (I've used Telerik and it wasn't felxible)
b. User searches something somewhere else in the code , for example, for an invoice. We want to save that query for the user and plug it in the reports page and automatically bring up the report
c.  We need to adapt this code and make it work for other sections. For example, it works for "Assets". Now we need to make it dynamic enough to work for "Invoice" section of site.
d. My manager is in a rush. Geez.

I looked at EasyQuery that Mark mentions https://korzh.com/easyquery

Is there a Query Builder tool that's like controls...we can drop into our website and …
0
CompTIA Network+
LVL 12
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Dears,

1. can we generate 1 report from different data sources (MS SQL and Oracle)?

2. Should we propose separate HWs for reporting for better performance if many DB's are being fetched?

3. Does SSRS SW require any license ?
0
I had this question after viewing Ms Access Crosstab Report with variable number of columns.

Dear Experts,
I am facing a similar situation but the problem is instead of numeric columns, i have Text Fields as columns. Any addition of column (Storage_Port) does not reflect in report. However, any change in Product / Qty gets updated.

Would be obliged if i can get help.
Db is attached herewith for reference purpose.
0
Hi I have report in 11g I what the data to display in excell format with heading I did use delimateddata it's showing data in html
0
User come up to me this morning and told me that he can access http://server/ReportManager. When you got the webpage, you get the following error
The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version

I logged into the server and tried to access the reporting services from SSRS and get the error below:
Unable to connect to the server at Server. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)


I tried the following to fix:
1)      Reboot – didn’t do anything
2)      Restart services – did nothing
3)      Log files showed an error: library!DefaultDomain!5ac!05/04/2018-08:43:12:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "Report_Server" …
0
I am researching the best Reporting Programs out there to fit our needs.  I've used both Crystal Reports and Cognos - years ago (I know they've changed).
I need to be able to connect to our database and allow users to create their own reports.  Of course I would want to create some and publish those to our website.

Any recommendations on the best programs out there (that don't cost a fortune) to configure and get something out there for our users?  I don't need something that is going to take
me months to get reports available.
0
I need to reset a value at the change of a GH1 in Crystal Reports , but I cant seem to get the formulas correct
CrystalQuestion.docx
0
Windows 2012, SQL 2012, Dynamics 365

The ReportServer and ReportServerTemp databases, from our CRM 2011 SQL server, were restored to our Dynamics 365 SQL Server.  This did not work and made all reports in Dynamics 365 non-functional.

I have tried creating a new ReportServer database using the SQL Reporting Configuration Tool however this does not make the existing reports functional.

What is the solution to get back to where were before the  ReportServer and ReportServerTemp databases were restored from our CRM 2011 SQL server?

Is there a method to map the existing reports to the new ReportServer datasource I created?

Thanks
0
The rectangle is too complex to export data to word using ssrs report
0
I have an issue with a calculation in SSRS 2016. My tablix reports on orders and has 3 row groups. From outside to inside that is:
- Whether the order was closed or missed (boolean)
- Market segment
- Market subsegment
I also have a column groups for month and year-to-date.
My problem is that I want to perform a calculation for the ytd column group that involve results from both the "closed" and "missed" results in the row groups, for the market group and subgroup records. I've tried to illustrate it in attached example.
Anyone have any idea what expression i can use to achieve this? Not sure if it matters, but the datasource is an SSAS MDX cube.
Thanks.
0
Build an E-Commerce Site with Angular 5
LVL 12
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

I have a question about crystal reports.

I have a Running Total Formula that I need to do the following below but it is not working. Basically I am trying to sum all the Kansas products that are in category 41,42,43.  If no products are found in the those category display inventory products as 0.  My report shows results as blank

if ToNumber({KansasInventory.cat})>40 and  ToNumber({KansasInventory.cat})<44
then
TonUMBER({@DisplayKKansasInventroyProductsy})
else
ToNumber({@DisplayKansasInventroyProducts}) = 0
0
Print button and date picker  of SSRS Report viewer of asp.net,  are not visible in non-IE browsers (google chrome)
0
Need to know if its possible in SAP Plant Maintenance to do a manual call on just ONE maintenance item # on a multi-item maintenance plan. For example, I have a maintenance plan # 1001 that has 99 task list items on it, varying in intervals from daily to annually, and one of those task lists maint items is # 567, I want to manually call just that 567 item to generate a work order tomorrow. I know if I were to create a maintenance plan for every task list, this would not be a problem, but my maintenance plans have many task lists on them and I cannot figure out how to manually call just ONE of them and not any others on that maintenance plan.
thx experts
BobR
0
I have a client that needs to delete two transaction expenses from a program called Cuncur. His employer does not give delete rights. Is there a way that this can be done?
0
I recently downloaded the new version of jaspersoft studio (6.5.0) for eclipse.  I used to be able to choose specific dates for a parameter when previewing a report, now if I pick a specific date it treats it as null.  The only values I can get to evaluate to non-null are the relative dates like "DAY" or "MONTH".

Switching to an older compatibility mode doesn't seem to work either.

DATERANGE("2017-12-22") evaluates to null when I preview.
DATERANGE("DAY") evaluates to the correct Date, 2017-12-22.

Anyone have any thoughts?

Edit: Here's the documentations on Jasper's Date Range object: http://jasperreports.sourceforge.net/sample.reference/daterange/index.html
0
I have 3 servers for this scenario. webserver1, newwebserver, sqlserver.
webserver1 uses SQLserver 2008 R2 for SQL Reporting Services
newwebserver uses SQLserver 2012 R2 for SQL Reporting Services
sqlserver uses SQLserver 2008R2.
webserver1 have been connected for SQL Reporting services to sqlserver.
Today, we tried to add newwebserver for SQL Reporting service to sqlserver, and for some reason it screw our current webserver1 SQL REporting services.
I need to be able to reconnect my webserver1 via SQL reporting services with my sqlserver. I have the "SWL REport key.snk" and password that was originale used to create this service. i have been trying to restore and error below.
encryption keyserrori need to be able to reconnect back. I already disconnect newwebserver, but i believe it is still connected for some reason. what i can do to reconnect back to ReportServer database.
0
Has anyone seen an article on a comparison of features between Tableau, qlikview or any of the other data analysis tools that are current "hot"?
0
I'm trying to create a report in Cognos with the following format:

Output
My current output is a crosstab query below:

Crosstab Output
Actual CT query
0
I'm trying to create a report in Cognos 11 with the following format:
Desired Output
I have a crosstab query in the format below which I would like to convert to the format above or create a new report:
Crosstab
Query
Thanks
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Can you please give me some information about these tools?

Looker, Qlik, Tableau
0
Qlikview Help!!!
I have a pivot table in Qlikview 11.
1) Original - is my original pivot table
2) Final - is the pivoted version of Original
3) Result - this is what the result needs to be

How to calculate the difference columns - DIFF1, DIFF2, DIFF3 in the same format as attached? Please help.

Capture2.PNG
0
I am trying to pass two parameters through my report to get a report window to pop up. I am getting the following error and cannot see my issue. Perhaps tired eyes and could use a hand.

Name 'PATIENTVISITID' is not declared.

="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"

&"/Billing Reports/Jeffs/Testing Folder/Sub_rdl_Detail_QuestionAnswerChecklist&rc:Parameters=False&rc:Toolbar=False
&PATIENTPROFILEID="& Fields!PatientProfileId.Value & PATIENTVISITID="& Fields!PatientVisitId.Value &"
','DetailsWindow','left=300,top=180,width=850,height=365,status=no,menubar=no,scrollbars=yes,location=no'" & ")"

Open in new window

0
I'm using SSRS 2016 and facing rendering issue in IE 11 (one e.g. Drilldown button is missing when we browse reports via IE 11 ). It works fine with Chrome, but our end users preferred browser for  SSRS reports is IE 11. Is there anything can be done at server level to fix the rendering issue.

Your help is highly appreciated.
0
Hello Experts

I have a collection of SubReports inside a MasterReport. I'm having a small problem where SubReport number 9 (for instance) doesn't show up if there are no records. Instead there is just a blank section in the MasterReport, and then it shows the next SubReport. Its worth noting that SubReport number 9 does show up in Report View and Layout View, but does NOT show up in Print Preview or during an actual Print.

Ideally, we'd like it to display the headers for this SubReport and no records underneath them - instead of just all white space because this MasterReport is structured with numbers in the Titles, etc. (Check Number 1 - Expenses; Check Number 2 - Overdrafts, where 1 is SubReport 1 and 2 is SubReport 2). The numbers are important, and the order is also important.

For what its worth, I am using Office 365 Access.

Thanks for your ideas and thoughts!
-IT_Crowd
0
Hi,

I am migrating an old Crystal Report to an alternative Dashboard application.
My crystal report (which works very well, shame I have to migrate) reads from a table of monthly stock sales history.

e.g.

STOCK CODE   MONTH1UNITS   MONTH2UNITS   MONTH3UNITS   MONTH4UNITS   MONTH6UNITS   MONTH7UNITS
ABC123            100                         87                          69                          93                          108                        111
ETC
ETC

My Crystal Report had a parameter to prompt the user for number of months to report on.
A calculated field in the report registered all 60 of the month columns into an array and then looped through the correct number of months based on the user parameter for number of months to aggregate for each stock record in the report.
This solution was simple, elegant and worked very well.

I don't have the facility of arrays in the alternative Dashboard app.
Can anyone suggest an alternative way of achieving similar through SQL in Stored Procedure?  I'm struggling...

Hope i've explained clearly enough?

Thanks in anticipation...
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
>