Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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 have a tablix.  The last row of the tablix contains a subreport.  I want to put a page break before this subreport prints.  How can I do this when its part of a tablix?
0
Get your problem seen by more experts
LVL 11
Get your problem seen by more experts

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

Today I have a application that was made using webforms and I need to migrate to ASP.NET CORE.

This application uses Crystal Reports to generate many reports in PDF format.

I need a solution to migrate this reports, I intent to migrate this solution to a Linux server, then if I can migrate this reports to a solution that run in linux is better.

I've tried iTextsharp, but this don't work in ASP.NET CORE with Linux.
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
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
Become an Android App Developer
LVL 11
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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 trying to display a report, I have a stored procedure that requires 3 parameters.  I am also using EF6 to push and pull data but I don't seem to be getting any data back to my report data source.  In my edmx file I see the SP in the functions folder and can pull scheme info.

In the code behind I try this
    ReportDataSource rds = new ReportDataSource("dsBOL.PrintBOLDataTable", dt);
but nothing.

Here is a shot of the report data source.

ds.PNG
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
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
Concerto Cloud for Software Providers & ISVs
LVL 5
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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

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
>