We help IT Professionals succeed at work.

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.

Situation: For production administration my client uses an Access database for storage. The database is being used for safety reasons. However, it isn't that friendly for the average users to screen/analyze & report data from it. For those reasons we want to (externally) connect it with Excel (as front end & Access as backend).

What options are there to edit Access data from Excel and vice versa? So far I was only able to edit data within Access itself. We want edits from both ways because we use another sync platform to sync data from mobiles to the Access database.
0
Dear Experts

We are looking for reporting and analytics tool which to connect to various business applications and provide reports and analytics and visual charts would like to understand the difference of Reporting, Analytics and Visuals, please help with details.
0
I had this question after viewing how do you back up the cognos fm model.

I just started at a new company and they are having trouble with the model.xml that all files for the framework are located on the network - the reports run but can not be modified the error returned is 'Metadata not available.' they did put a copy of the model.xml and the .cpf file to make it available but I'm not sure how to fix the error. Any help will be greatly appreciated.
0
Getting 'Metadata not available' when modifying existing reports and creating new reports - the reports will run and return data but cannot make any changes to the report. The Model.xml file is size 0 in the framework folder. Was able to get a model.xml file from a backup but not sure what to do with it so the .cpf recognizes it.

When I try to open the framework file .cpf it doesn't open it just flashes and closes immediately.
0
Dear Experts
We are using CRM application which uses MYSQL database. we have customized the CRM application for our core process therefore the CRM modules marketing, sales and contacts and opportunities are not made use instead we have completely customized, the solution is deployed on premises.
Challenges: to build/develop certain reports which are very much essential for daily operations and monthly reports and analytics. At present we are taking csv dump from crm and preparing it manually by applying formulas,  this is time consuming and resource dependent and as reports are not ready made available therefore end users to depend on the technical resource to export the reports and bring it to the required format and then provided to the end users. We also require analytics from the CRM data.
We are planning to implement SQL Server Reporting Services (SSRS) and integrate with Power BI for analytics the data source will be CRM application either integrated OR excel as input to the SQL Server Reporting Services (SSRS) or Power BI.
Please suggest will this approach work for us.
0
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
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
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
Print button and date picker  of SSRS Report viewer of asp.net,  are not visible in non-IE browsers (google chrome)
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
>