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 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
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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
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
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
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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 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
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
Cloud Class® Course: Amazon Web Services - Basic
LVL 12
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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
looking for solutions how to create interactive surveys whereby at the end of it, some customized reports would shown instantly to the user online. e.g of this is this link https://www.nab.com.au/personal/investments-super/financial-advice/financial-health-check
0
Hi,
I want to compute balance cashbook reconciliation statement in crystal ,
I have STATEMENT  BALANCE which is initial balance depending to period have selected,
I have two columns for Deposits and withdrawals.
My problem is I want to get running balance  depending whether is withdrawal or deposit.thank you
0
how to run crystal reports in batch
0
I am using Delphi Berlin and QR6, when I preview my report, on the preview window left corner I see a "page 1 of 10", "page 2 of 10" expression. How can I use de "of 10" part on my report? In the new quick report that is done without the ".prepare" option, which causes delay on showing the 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
>