Telerik Forums
Reporting Forum
8 answers
424 views
Getting the following error when report is rendered.. Once refreshed, error disappers...
Nasko
Telerik team
 answered on 19 Jan 2016
1 answer
147 views

Hello,
I am doing a report with the option of exporting to excel and pdf.
I open the print preview in the excel file, I see an extra blank page
I setting BackgroundColor check problem,I find pageHeaderSection out of the scope of the paper,

my PageSetting

PaperKind:A4

Margins:Left 20mm Right30mm

Please help.

In attached ,pageHeaderSection BackgroundColor is green

 

 

 

Katia
Telerik team
 answered on 19 Jan 2016
7 answers
361 views

Hi, I'm trying to produce the attached report, and as you can see the x-axis in this is grouped by a week (starting with Monday). I have written an extension method for determining the first day of the week for a date and given a DayOfWeek to treat as the "start of the week".

I have two questions, please:

1. I can get a chart working where it groups together all data for each week, so there is just one point for each week (for each series).  However as you can see I need to still plot the series data on a day-by-day basis, so it's just the labelling of the x-axis that i want to be at a weekly level.  Can you please advise if there is a way to do this?

2. How can I format the area series so that it fills the entire space for a given date? See second attachment for a (hopefully) better explanation of what I mean, comparing it with the "Chart requirements" JPG.

Thanks

Katia
Telerik team
 answered on 18 Jan 2016
1 answer
48 views

Hi, we are trying to achieve the attached chart, and as you can see some categories have a second level, for example:

    -- Finest
    -- Graze
    -- Manufactuuring
    -- Butcher
        -- GFYG
        -- Supp
        -- Grass
        -- Market

Is there a way to have this 2nd level shown as per the attached?

Note that the categories (1st and 2nd level) are dynamic, so hard coding them is not an option.

Thanks.

Stef
Telerik team
 answered on 15 Jan 2016
1 answer
137 views

I have a CrossTab report that has 3 groups and in the lowest (last) group I have made the column heading text vertical by setting the angle of the textbox to 270. 

When I run the report it is not growing or shrinking that textbox even though both CanGrow and CanShrink are set to true - it appears to be remaining at its initial size on every page.  Our client would much prefer that it is able to grow so that the occasional longer text still fits without truncation.

The other column headings that have not been made vertical are still growing when needed.

Currently using Reporting Q3 2015. 

 

Stef
Telerik team
 answered on 15 Jan 2016
1 answer
97 views

Hey everyone,

I'm experiencing a problem with Telerik Reporting. First, I desgined all the tables for the Report and added all the static content (like table headers, etc.). Then, I added my data sources. The Problem is: When I drag a field from the Data Explorer and drop it into a table-column, the whole table disappears. When I remove the data source, the table is visible again.

Any ideas on what went wrong?

Thanks,

Simon

 

Nasko
Telerik team
 answered on 15 Jan 2016
3 answers
202 views

Hello,

I'm considering to switch from SSRS to Telerik Reporting and I'm testing Clustered Column chart. As datasource I have simple table as this:

BillDate (Date), BillAmount (Money)

 On X axis I have BillDate and I'm showing Sum(BillAmount) as data.

 I set Label step to 7, LabelUnit Days, BaseUnit Auto. It works great for daterange of one or two months, each day has own column of data, label is for seventh column. But When user choses great range for this report, for example from 2015-01-01 to 2015-12-31 then there is too much data, labels ale unreadable. Is it possible to set automatic switch to Month BaseUnit or even Year BaseUnit when there is too much records? Attached are samples of both graphs.

 

Nasko
Telerik team
 answered on 15 Jan 2016
2 answers
578 views

Just started out with the reporting tool and have a few questions I can't seem to find.

 1. Is it possible to group by a field's values? Ex. I have a field Fields.Products, and I want to sum the cost of the products that fall under fruits.\

2. Is it possible to specify the order the column group appears in? Ex. meats | fruits | vegetables. I realize I can do ascending/descending but neither of those is what I want.

Stef
Telerik team
 answered on 15 Jan 2016
1 answer
144 views

I have a bubble chart on a report.  The data source lists physicians, issues and counts.  The size of the bubble is based on the Sum(IssuesFound).

Our client base is split between those with only a few issues and those with quite a few.

I am attempting to place a dynamic filter on the chart, so that a points are plotted when there are less than 8 but limit to points with larger bubbles when there are more than 8 bubbles.  At Series > lineSeries2 > SeriesGroup > Filters I entered:

Expression: = Sum(Fields.IssuesFound)
Operator: >=
Value: = IIf(CountDistinct(Fields.AuditIssueId) >= 8, 5, 0)

However, the results are that it always shows all items on the chart (the false result of the IIF).
I've added text boxes in the report header to show me the values of Sum(Fields.IssuesFound) and CountDistinct(Fields.AuditIssueId) and they are correct.
I suppose that the IIf is not evaluating properly during the chart rendering.

If I hard code the Values, like =5, the filter works great and only those issues with a count of 5 or more are plotted.
Is it possible to make this dynamic?

Best,
Scott

Nasko
Telerik team
 answered on 15 Jan 2016
1 answer
79 views
I would like to present the following use case and ask for suggestions on the best approach we can use in this situation:

My company provides customized reports on demand to our customers.
Customers buy new customized reports on our database. They will be available in the administrative environment of each client on our site. These reports are developed by us and implemented in VBA (Word and Excel). Usually, we develope a stored procedure that will provide data to the report and VBA is used to run the stored procedure and supply data to a spreadsheet or word document. VBA is dealing with a report queue and sending e-mail to customers with these reports attached. This structure has existed for about 12 years and we believe that it is necessary to improve this proccess. The main problem is the VBA instability to the volume of cases, high volume of decentralized code and difficult to maintain (typical procedural code).

We would like to implement improvements that will improve the quality and delivery time of these projects. Especially ensuring stability in the processing of reports and better error handling, among other expectations we have. And I would like to read suggestions and use cases that can assist us in making decisions.

Our doubts and ways we think of tread:
1) Replacement of VBA technology for a modern platform that adds time and quality in the generation of reports, since VBA is quite unstable. Including the SERVER and also SUBMITTED REPORT. We thought of many options: Jasper Reports, Pentaho, Crystal .. and continue research, but still no conclusive results, since I must ensure that the new technology could replace the VBA in everything he does;
2) The creation of stored procedures for data extraction for the report is the same as the best one? Or should we start from for BI tools that can assist in data extraction more efficiently? Something to help us to configure the data extractions easier.

Our plataform:
1. SQL SERVER;
2. Windows machine with VBA runing (control the report queue and proccess/generate reports).

We are open to platform changes. But with respect to use another database management system, it can be a little tricky… as in most cases, I believe.

What do you recommend? What usually employ on your company? Your suggestions will be most welcome!


thank you
Nasko
Telerik team
 answered on 15 Jan 2016
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?