Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

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 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
Free Tool: Site Down Detector
LVL 10
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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
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
I'm trying to figure out how to get rid of space at the top of a report, between the header and matrix. it makes it hard when exporting to excel. it adds an extra row to the spread sheet, which the users find annoying.
0
Good afternoon,

I am very new to cognos report writer and have a calculation question. The report I created pulls in purchase order lines and quantities. Based on critera of period received that is selected so when I run the report I get a result like the following (which is correct)

Period Received         PO Number     PO Line Number     PO Quantity
1                                   123                    1                                 2500
2                                   123                    2                                 2500
3                                   123                    1                                 2500
3                                   123                    2                                 2500
4                                   456                    1                                 1000

What I need to calculate is if the PO Number is the same and has multiple line numbers that are the same calculate the PO quantity based on the PO line number. So in this case the total PO quantity I would like to show at the bottom of the report is 6,000. In other words lines 1 + 2 total 5000 for periods 1-3 and since period 4 has a different po add an additional 1000. How would I accomplish this?
0
Hi,

We have a CRXI report with a watermark.  We want the watermark to show in all sections EXCEPT group footers which contain subreports.  The subreports should not show the watermark.  Is there a keyword or formula that can suppress the watermark (it is excel) if the section is a group footer?

Thanks.
0
Hi Experts,
could you please help by giving some lead and list of applications/products that can be used to view dashboard on mobile

Also pls suggest few options on below scenarios

Scenario 1:
1. Data will be flow in from different format. E.g csv, txt, mysql, oracle etc.
2. Need a product to consume this and produce report/chart basically dashboard especially supporting Mobile device. Also on a web browser.
3. Interesting to these products....splunk and tableau. But not sure how well they support mobile device.
4. suggestions on licensed and open source dashboard.
5. Any application/product specialized for mobile device


Scenario 2:
1. Develop dashboard in house which should support mobile device and web browser (responsive ?)
2. what are the best set tools available to achieve this.
3. If you could provide high-level tool set and their integration point. E.g. java + plugin/module + AWS + etc etc. (I'm just mentioning what comes to my mind.) :)

Thanks in advance
0
We have an enterprise system with several hundred canned reports (most of which are never used, but that's another story).  We use BusinessObjects Web Intelligence to write the canned reports, and also users run their own Ad hoc reports using the same Universes as the Developers.

We do not have a Data Warehouse, but I'm trying to sort out operational reporting (with no data latency) vs OLAP coming from a Data Warehouse.

We keep saying we want a Data Warehouse but we're really not all that literate about what that means, imo.

We say we're the Business Intelligence team, but what we really are is the Operational Reporting team, and we also allow users to run reports out of this system.

I'm trying to sort out how to "position" a Data Warehouse, and how people would actually use it along with the Operational Reporting system.

Also, our BusinessObjects Universes pretty much match the data model of the OLTP. So it's a big mess, imo. It's got every relationship in the same manner as the main data model. So we don't utilize Data Warehouse techniques (e.g., flattening of the data), we just basically re-build the data model in the Universe. So it ends up hard to maintain and confusing to the users.

So some specific questions
- am I on track to separate out operational reporting from Data Warehouse functions? If so, what's the right term for the operational reporting?

- is a data warehouse necessarily going to have some measure of data latency ? Say at most 24 …
0
Get free NFR key for Veeam Availability Suite 9.5
LVL 1
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

I have four fields that are all 144 char in length and data type is String.  The value is either 0 or 1 with no separating characters or spaces, and I want to sum the string.  Data example is:

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111111111111111111111111111111111111111

Thank you in advance for your assistance!

BethS
0
Dear Team,

Currently in my project we are using SSRS (.rdlc)2005 version. Now we want to upgrade the SSRS 2016 . If i open the rdlc in ssrs 2016 . Its convert its schema to 2016 but not running . Its giving an error as "An error occured during local report processing. Error in the application .
Object reference not set to an instance of an object" . If i delete all the content from report then still giving the same error .
For this i m not  able to understand where ssrs store its data scheme.
Please help or guide How to upgrade ssrs 2005 to 2016 .
thanks in advance
0
I am using Report Builder 3.0 in order to connect to SSRS report server http://mosaic.catex.com/reportserver.
Is there a way to use Power BI to connect to SSRS report server instead in order to build dashboards?
report-builder.jpgDatasource.png
0
Hi,

I can't get rid of the blue border on the signature images i'm producing in my report, Border is set to None, Sizing is set to Fit, example is attached...any ideas ??

Thanks

Steve
SignatureBorder.PNG
0
I have built 4 reports in Access as part of an Attendance Tracking Database. The reports are all built in a similar fashion with VBA code in the event on open of the report that populate some textboxes. I have also added a button on the report that brings up the built in macro "ExportWithFormatting" to allow the user to save the report as a PDF,

For 3 of the reports when the file is exported to PDF all of the fields populated by VBA code are saved but on the last report when it is saved to PDF the fields which were populated by the VBA code appear blank in the saved version. I am losing my mind as I built them all the same but am getting a different outcome.

Does anyone know why these fields are saving blank to the PDF?
0
Hi expert

Currently i am given a task to display on the Transaction monitor.

My question how to uses script recording to simulate an action.

Please note i am do have a transaction recorder and how to do display or show on the dashboard.

Thanks
0
I made a huge mistake and tried to copy an existing RDL and must have clicked the OK button as it was trying to set up a new connection...

Then I tried to see the management form for the page and pushed F5. This broke al the reports on our QA machine.

Now, i get a database error and none of the hundreds of reports are associated with a valid data source.

I get:

An error has occurred during report processing.
    Cannot create a connection to data source 'MyDataSource'.
        For more information about this error navigate to the report server on the local server machine, or enable remote errors

How do I force the existing reports to use a given Data Source?

 

Thanks.
0
I am very new to SSRS, and also very new to the project I am supposed to support. So new I thought pressing the F5 button in Visual Studio would open up a web-page of the hundred or so reports. Instead, it proceeded to deploy them to the QA server.

I generated an error in the process but I can not find where to look and find the error.

This is the error...

An internal error occurred on the report server. See the error log for more details. (rsInternalError)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
0
We are few legacy reports written in IBM Cognos BI 7.5 with Date option working via Prompt Manager.
We now want to run same report on schedule and like to replace Prompted date with a calculated one.

Calc logic is simple
 we do need Enddate=date()+1 (business day)
 for every day of the week Enddate will be currentDateDate + 1 , while on Friday it will be CurrentDate +3

For today Thursday Jan 12  Enddate = 1/13/2017
for Friday  1/13/2017  EndDate= 1/16/2017
for Monday 1/16/2017 EndDate= 1/17/2017

could someone provide such syntax and where to insert it into report?
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hello,

I need to edit an existing .qrp file to show a total of a sales order in a currency of a country to which the product is sold using Gupta Report Builder.
Can't find where the currency symbol is inserted in front of a number and how to edit it in the first place. I need Japanese Yen to appear in the field instead of Euro and the description changed from EUR to YEN.

Your help is greatly appreciated. Thank you.
0
Hello All:

I have, what I'd like to consider an elaborate report I am building for upper management. We have a manufacturing company, and have a unique customer that needs some data e-mailed to them every morning and I've gotten about 98% of the report done but hung up on this one part.

So I am trying to build an area on the report that counts the number of items that has 3 certain statuses, Ready to Manufacturer, Images Printed and Completed (aka: Shipped).

I am running in to an issue where, when I double check the data it's not the same. So I think I figured out what the problem is but I don't know how to solve it basically.

When I pull the report, there is a MFG Order # and in side the MFG order # there may be several lines in that orders - all with a status of "Ready to Manufacturer", "Images Printed", or "Completed". I think my report is counting those lines vs just the status of a particular MFG Order # and I am stuck at how the report will know, even though it see's multiple lines to only look at the lines that are unique and capture the over all status and consider it just "1", not the # of items in the order.

Here is what I am using for the expression:
=COUNT(IIF(Fields!ProdStatusName.Value="ReadyToManufacture",1,Nothing))


There is a column label "ProdStatusName" and in side there has the different status I previously mentioned. I'm not a 100% SRSS guru, know my way around a little but this is peak my interest for my company and believe that …
0
Hello:

I am trying to generate a report in Report Builder 3.0 for SQL 2008 for a client.

I am looking for something very specific, but having a hard time finding it.

I have 99% of my report built, however the client needs to know the following. The report is a Daily report for the previous day of orders received. It is broken down my Order #, Customer, SKU, Description and Quantity.

I currently have a table on the report that takes the data below and sums of the # of orders that came (ex: 500) and another table that shows the total quantity of items (in those 500 orders) received (ex: 1,500 items). The client wants to know, out of those 500 orders, how man total orders have a Quantity of 1 (ex: 550), how many orders have quantity of 2, etc. etc. based off the Details listed below on the report. Call it a "summary" area at the top of the report for the info listed below that area on the report.

Does this make sense to anyone?
0
hi i have a report in 11g is returning null but when i test  the report query in sqlplus is returning everything what could be the problem
0
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

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
>