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

Hi all,

After creating a CAFE list within Excel, we are assigning an excel "named range" in order to reference the "Cognos" list in VLOOKUP, HLOOKUP functions etc.
From what we can see, the named range gets lost (disappears) after pressing the "Refresh all data" button.

Is it the expected behavior? Is there a workaround? This does not happen when using Cognos for MS Office but the functionality there is different too (no exploration module). Obviously, without being able to use formulas like VLOOKUP functions in combination with Excel Ranges (which are dynamic and not static), the power of the module is very much limited.
In Cognos for MS Office, we can refer to the "identifier" of the Cognos list inserted in the report in order to create functions in Excel, and it does not get lost when refreshing.

Any help welcome …
Thanks!

Vinc
0
Amazon Web Services
LVL 13
Amazon Web Services

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.

Hi All,

I have a report that have been created a long time ago in Cognos 8, then migrated to Cognos 10, then now in Cognos 11.
It is working perfectly fine in Cognos 10, and the validation of this report gives only a warning "XQE-WRN-0018 The dimensionInfo in V5 query has been deprecated. The query will be planned regardless of dimensionInfo.". Warning I've never been able to solve, and that is not blocking for Cognos 10.

Now in Cognos 11. when trying to validate, the only message I get is "RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: java.lang.NullPointerException ".
I have checked all queries: they are all working when using "view tabular data". No errors, some data are displayed, etc...

Does anybody know how to solve this?
Any help, advice, etc.. will be appreciated...
Thanks!
Vinc
0
Hi all,

My MS office version is Office 365 MSO (16.0.11727.20222) 32 bits.
I used to have the Cognos Go Office 10.2.2 installed and working correctly. But now, since 2 weeks, the Cognos pane on the right supposed to display the Cognos elements, reports, etc .. is always blank. I can login, I can even refresh data of existing reports, but I cannot browse anymore in my Cognos items and select another report or see the elements of an existing report embedded.
Does anybody experience the same problem? Is there an official "bug" or something.
I tried to install the Cognos plug for Cognos Analytics, but I have the same behavior.

Thanks!
VincImage of empty Cognos plugin pane in PowerPoint
0
Is it possible to use SSRS 2016 reports in a ASP.Net Core Web Application?

If so anyone have a link to an example?
0
Hello experts,
I created a report which is displaying 2 records for each student. The student ID, Name, DOB all these fields are repeated and is same, the only difference is there are other fields that are not similar, 'Submit Date', 'Approved by ID, 'Approved by'. I would like to merge this data into one record. Is this possible in Crystal report?  Thanks in advance.
This a dummy data for reference.

Current result:

StudentID Name 'Submit Date'                     'Approved by' 'Approved by ID'

1234,        SAM, '10/01/2018 4:04:18 PM',     Hary,              hry243

1234,        SAM, '10/02/2018 12:30:51 PM',   John,              jhn334

Open in new window


Expected result:

StudentID      Name     'Submit Date 1'               'Approved by 1' 'Approved by ID 1'             'Submit Date 2'             'Approved by 2' 'Approved by ID2'

1234           SAM      '10/01/2018 4:04:18 PM',           Hary,            hry243,                  '10/02/2018 12:30:51 PM'      John                  jhn334

Open in new window

0
Hi,

I have an rdlc report in Legal papersize. I have set the report properties to Legal. The problem I am having is when I load it in to the reportviewer  and go to print the pagesize under page setup is always set to letter so it has to be changed manually. I need to be able to set the page settings in reportviewer programmatically so I can switch between letter and legal sizes via the code.  I have tried various things but nothing seems to affect the page setup dialog. What is the correct procedure to do this. I am coding in vb.net.

Thanks

Nick
0
Hi EE,

We have just installed SSRS 2014 upgrade from 2008 and we start the reporting service we receive 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.

Attached is the reporting log error messages.

I have no idea about SSRS, any assistance is appreciated.

Thank you.
ReportServerService__11_21_2018_19_5.log
ReportServer-error.PNG
ReportServer-Error-2.PNG
0
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
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'm upgrading from an older (5.1) version of Jasper Reports in my java project.  I've re-compiled a report in the new Tibco Reports Designer.  When I try to run it, or any other report, I get no output.  I downloaded and compiled the jasperreports 6.0.2 source and am using it for debugging the problem. screen shot of last executed statement  I've included a screen shot of the last statement that tries to execute.  It's line 823 in JasperCompileManager in function getCompiler.

This is a working app and I believe I've updated all the required libraries.

I don't catch any exceptions (at least not any I'm expecting) and the program returns to my finally statement after trying to run the jasper report.  The only other thing I can add is that if I hover over the JRCompiler  item in the previous sentence it says, JRCompiler is not a known variable in the current context.  Not sure if that helps.  It also doesn't hit the catch (Exception e) statement it just fails.  Not sure how to progress from here.
0
Become a Certified Penetration Testing Engineer
LVL 13
Become a Certified Penetration Testing Engineer

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.

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
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
Bootstrap 4: Exploring New Features
LVL 13
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

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

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
>