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

can user reorder columns like grid in report??
in SSRS or Telerik Reporting.

Thank You.
0
I'm using CR 2008.  I have a crosstab report that allows the user to choose the start and end dates as well as how they want the report sorted.  The choices for how the report is sorted is one of (3) ways.  Alphabetically by Customer Name, Numerical by Customer ID, and by Revenue Dollar.  I have figured out how to get the crosstab to sort by the customer name and ID, but I can't figure out how to do it by revenue.  I want the report to display the customer with the highest dollar amount first and display the rest descending.  The revenue is not a field in the database.  Instead it will need to be calculated.  I'm not sure of the best way to handle this and I have been struggling with getting the sort to work properly.  The revenue is being converted to text so when it sorts it will sort 1, 10, 100 then 2, 20, etc.  I put a tilde (~) symbol between the dollar amount and the customer name thinking that I could create a formula to have it look for that symbol to know how many characters were in the revenue field so that I could then tell it to put in the same number of beginning zeros so that everything would sort correctly.  But I never got the formula figured out that would allow it to run without any errors.  Any help would be greatly appreciated.
--mail-staylor--Custom-Reports-Month.rpt
0
In SSAS had the application create a time dimension.

No matter what I do the Date dimension presents days in this format "Sunday, January 01 1995".

I would like it to show as 1/1/1995 instead.

When trying to configure the Date attribute ;

FormatString : ShortDate
Usage: Key
NameColumn: Cannot modify this - Binding type is Generate Column
0
I am in the process of creating a crosstab report that shows the On Time Delivery (OTD) for a given time period.  I want the report to display the overall OTD % as well as the OTD for each individual customer.  I'm not sure how to display the OTD % for the individual customers.  

I currently display the Total Revenue by customer, the total # of lines shipped, and the total # of lines that shipped LATE.

Whenever I attempted to display the OTD %, it would show the overall percentage for each customer.  For instance, during a given time  our overall OTD was 75%.  Customer # 1, may have been at 100% and customer # 2 may have been at 50% so I want that displayed.  But what I am getting it 75% for both customers.

Is this possible to do in a crosstab report?
--mail-staylor--Custom-Reports-Month.rpt
0
Hello there,

I am creating a report in SSRS 2012 and for some reason I am not able to test my query in the Query Desinger of SSRS(I get some error,please see screenshot) also my supplier parameter is not filtering when i preview the report. CAn somebody please help me.

cheers
Zulf

1
2
and my query is like so

;
WITH
    CTE_Product_Detail AS
    (
        SELECT
            COALESCE (ProductSalesData.ProductCode, ProductAvailableData.ProductCode) AS ProductID,
            COALESCE (ProductSalesData.SalesQtyInclDis, 0)                            AS SalesQty,
            COALESCE (ProductSalesData.SalesDis, 0)                                   AS SalesDis,
            COALESCE (ProductSalesData.PurchasePrice, 0)                              AS
                                                                                   PurchasePrice,
            (ProductSalesData.SalesQtyInclDis * ProductSalesData.PurchasePrice) AS TotalPuchaseRial
            ,
            COALESCE (ProductSalesData.SalesPrice, 0)                        AS SalesPrice,
            (ProductSalesData.SalesQtyInclDis * ProductSalesData.SalesPrice)      AS TotalSalesRial,
            ProductSalesData.SaleDate                                               AS SaleDate,
            COALESCE (ProductSalesData.ShamsiMonth, 0)                              AS ShamsiMonth,
            COALESCE (ProductSalesData.ShamsiYear, 0)                             

Open in new window

0
I have a report that I'm developing for our sales department.  The goal is to get the total sales (by invoiced $) from the same month for the previous year and then use that number plus a percentage as a new goal listed for the current year and current month to date (report runs daily).  I have this mostly working and I'm using a sub report to target the previous year / month's sales.  The problem is in the selection criteria for the sub report.  It's only capturing the sales MTD (previous year) and instead of the full month.

This is what I am using in the report selection:
{ARTABLE.INVOICE_DATE} in date(year(currentdate)-1,12,1) to dateadd("yyyy",-1,currentdate)

How can I modify the selection criteria to report all sales for the current month (previous year).  I'm close just haven't been able to get through.
0
I have an issue with InfoMaker 12.0. Currently we have an existing report with a request to enhance the report to allow multi-select. The SPROC [EXEC dbo.SPROC ( a int, b int );]. The setup window is setup correctly and has been running fine until I select the MS checkbox and save the changes. The datatype for parm 2 changes to string from integer and throws a warning error at runtime for the report.

Any thoughts?
0
Hi Experts,

I have starttime and endtime option in SSRS and user will select the those values. Selection of time has some logic and business user will know how to select it. If the user selects datetime which doesn't comply the business logic, SSRS will not be rendered. So, business users want a indication of start and endtime to show them upfront.  
I have added a parameter and it's should the value in the text box where it's in editable mode. I want to grey out this option. I know this is not possible by default SSRS setting. Is there any solution out of box which will help me.
0
This would be for a sql server or oracle database. Currently we are using Crystal reports, but we need something a bit more helpful as far as making business decisions.  We would start, though, by simply pasting the sql from the crystal reports into the dashboard tool. The goal (if possible) is to create a package with  perhaps ten dashboards. My research so far shows that the licensing for most software is pretty expensive, even for only 5 or ten users, which is what we would probably be looking at.  Is  open source software a possibility? The dashboards should be versatile and interactive, and capable of going in depth.
0
I have the WLM Contacts file (*.edb) but am unable to convert it to a CSV file.  I've checked several site and program that are so called conversion programs but have been unsuccessful.  This file is no longer on the original system since it had a corrupted OS and has now been upgraded to W10.  Can someone please suggest a way to convert this EDB file to a CSV.  Thanks.
0
Example:  1 table with 10 columns/fields and 5 records
2 report files: Page1.frx and Page2.frx

I need to print 5 fields on on Page1.frx on pg 1, the the last 5 fields on Page2.frx on pg 2.  The next record would print on pg 3 and 4, etc.
0
Hi guys, the title says it all really. I have a main query which returns 5 Input Groups, each input group can have multiple Voting Groups, each voting group can have multiple Voting Setpoints and each Voting Setpoint can have multiple Inputs. Should I use reports inside reports inside reports, or can i achieve this with a main report and multiple datasets in some way?  Obviously I don't want blank areas where (for example) Set points do not exist So you have Input Group > Voting Group > Inputs

An example structure could be:

- Input Group 1
      - Voting Group 1
            - Voting Setpoint 1
                    - Input ID's
             - Voting Setpoint 2
      - Voting Group 2
- Input Group 2

Thanks,
Dean
0
I am trying to calculate a percentage using the value of one column through a condition.  A sample dataset is below:

County       AVG For 2015/08   AVG For 2015/09       AVG For 2015/10    AVG For 2015/11      % of time Avg > 10

XXX             15.6                         9.09                             8.56                           5.76                               ?
YYY              12.5                        16.56                           9.56                           10.86                             ?

For example, for County XXX the percentage of time Avg > 10 should be 1/4 or 25% in the past 4 months.  For county YYY it should be 3/4 or 75%.  

How do I write an expression to calculate that percentage automatically by checking for the avg from the other column?
0
hello.  I outputted several reports from impromptu to Excel 2010 by using the Save As with Excel Format.  All of the excel files open except one.  that one gives me the message "902410.xls cannot be accessed.  the file may be corrupted, located on a server that is not responding, or read-only."

All the reports are coming from the same impromptu application from the same server and database.  I even tried saving the report on another computer and got the same error.  Any suggestions.

Thanks.

ic
0
We are developing a Java REST based application and we have to convert reports in the following format (PDF, Excel, CSV, XML and HTML) and also there is a requirement to schedule reports at a predetermined intervals.

The data exchange format is JSON, what would be the best way for the user to download reports (for example PDF reports)

1) Do we need to send the PDF content as a JSON response
2) or do we need to send the title of the report and the URL link as the JSON response. In this case the URL link will represent the PDF file on the server side and by clicking the link, the user can download the report from the server
3) or do we need to send the data (row, column etc) as JSON response and then construct the PDF at the client side (browser front end) using any JavaScript libraries?

Or is there any alternate ways (best practices) for the user to download PDF reports in the modern browser (We assume only the latest version of major browsers will be used by our users ex. Firefox, Chrome, IE, Edge, Safari and Opera

Any pointers or links to some useful examples would be of immense help.

Thank you
0
Hi,

I would like to hide the dialog that appears when sending Email Reports in Access. Instead, I would like the report sent as a PDF, without giving the user the option to select a format. How would I achieve this?
0
We are implementing BI Suite in the next several months or so. I was asked to look into Crystal Reports, of which I have passing but credible knowledge of. I've also been using Web Intelligence for ~6 months, so have a pretty good idea of its features and capabilities.
 
Dave Rathbun has a nice write-up of .UNX vs .UNV (from 2013), which touches on Crystal for Enterprise and Crystal Reports (2013 ?). In particular, his article says Crystal for Enterprise ONLY works with the (new) .UNX universes (which uses the new Info Design Tool), and Crystal Reports does NOT work with the (new) .UNX universes and only has LIMITED support with the (older) .UNV universes.
 
On other blogs, I just didn't get the warm and fuzzy on Cyrstal, for various reasons, but primarily these:
- Crystal for Enterprise is fairly new and not nearly as stable as Crystal Reports (2013?)
- Crystal Reports is stable but doesn't work with the (newer) .UNX universes
 
The other blog articles were also written in 2013, so I didn't see anything newer.
 
So - - -
- can I NOT use Crystal for Enterprise with the (older) .UNV universes ?
- Is Crystal Reports (2013?) going to work with both .UNV and .UNX universes ? and for the long term ?
 
With our BI Suite implementation, we are planning on just going with what we have - .UNV universes and the (older) Universe Design Tool. But we have some critical needs that cannot be …
0
I want to know what's the best way of assigning task. Reminders to employees for uncompleted task. before they close during the day.

There are naturally traditional daily task which has been clearly defined when starting.. . But some come along the way.

How is it possible to be clear on defined expectations.

Will be good to have this on our local server ( windowns and Linux) or Qnap NAS Serve, but also welcome online solutions.
0
Hi guys,

I need help with SSRS layout. I have a tablix and I do not want it to start half way down page two and fall across to page 3. So I have set 'Keep together' so as the tablix starts on page 3, however I have a problem when the tablix is bigger than one complete page? It just breaks up and looks terrible. How can I get the tablix to start on a new page in the initial instance, but then run across into another 2 or 3 pages if required without breaking?

I hope that makes sense.

Thanks,
Dean.
0
What "End User Report Creation/Tweak" software
do you recommend for my Microsoft SQL Server 2014
database ?

Current Steps
 1. users submit report tweaks to me
 2. I change in SQL Server Reporting Services and redeploy

Desired Steps
 1. user runs existing SQL Server Reporting Services report
 2. uses something like http://www.logianalytics.com 
    to tweak on their own, contacting me if they need help
0
Hi,

 I have a problem with SSRS windows File share subscription. I am trying to post a file from Server A to Server B using windows filesharesubscriptions.  The account (ABC) I am using to post the file has access to shared folder on Server B, is an administrator on both Server A and B. But I am still getting Impersonation error. Please advise what needs to be done.
0
I've taken over the SSRS reports in our organisation and have the responsibility of developing new reports. I can do this (although not as well as the previous incumbent coming as I do from more of an SQL background).
Anyway, I'm having a problem with login credentials for some reports I've developed; we have a bespoke solution provided by our application vendor which passes credentials through to the reporting server. For some legacy reports this works fine and the reports open. However, the new reports I have created prompt for an SSRS login, UNLESS I have already opened one of the reports that does work. It seems that running a report that does work stores the credentials meaning that subsequent report requests do not require SSRS login.
So, what I would like to do is figure out why a working report does not require login credentials and see if I can replicate the setup in my new reports. Looking at one of the reports in BIDS, I can see that there is no data source shown, either embedded or shared. Obviously the report will not run in BIDS. However, the same report runs perfectly happily in Report Builder 3.0. I can't see any connection strings hidden anywhere, no parameters or variables appear to be set up, so I'm just wondering how it is possible for that report to work with no data source?

For information, here is a screenshot of the report in Report Builder:

Report Builder Design
And the Report results:

Report Results
0
Is there a tutorial that would explain step by step how to set up a Telerik report in the following scenario?

Winforms application
The report includes 5 parameters and a table
The data is decided by the user based on an interface
The application adds the data to a DataTable.
The parameters are calculated by the code based on user choices.

So when the user clicks I want to be able to
populate the dataTable
populate the parameters
call and show the report

My questions include
Does the code go into the Viewer or the report
Can I use a single form with a report viewer for many reports

Thanks in advance:)
0
I am trying to open a pop up window in SSRS without any parameters (just need it to go to this report) and when I click on the link from the main report nothing happens. I have done countless numbers of these with passing parameters, just never without. Am I missing something painfully obvious?


="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"&"/Billing Reports/links/ICDQuick)"
0
Hello there,

I have developed a report with SSRS 2012 and when I view the report on the reporting server for some reason the first row of the tablix on page 2 gets hidden under the column header. What could it be??. Also I have enabled to show the column header as and when I scroll down the page but it is not working in here. But this feature is working in the SQL Server Data tool when I test there. I am testing on IE 11. Please help,.

1
cheers
Zolf
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
>