Hello,

I am trying to create a set of graphs. I don't know how many graphs I will need to present at designtime (could be anywhere from 1 to 5). I first attempted to do this by adding all of the charts to the designer with their different criterias set and then hiding the ones that I didn't need at runtime, however this left me with seemingly random blank pages at the end of my report. I tried to change the report's detail height both at runtime and designtime to no avail.

Next, I took the programmatic approach. I attempted to follow the instructions here but couldn't figure out how to make this work with a pie chart - the graph would show up but the slices of data would not. I gave up on this because I figured it would be more effective to do this at designtime.

Now I'm at the designtime approach. I put the graph in a table, and I am able to repeat the graph for every row of the table, but I don't seem to be able to change any properties of the graph based on the row that it's on (I need to change the title, filter criteria, etc). There also seems to be some overlapping issues.

What is the correct way to go about this? I have read this thread (and the corresponding help articles), but the thread just isn't detailed enough for me follow, and the help articles don't give much of an explanation either.

What are the recommended 'best practices' steps to connect the Telerik Standalone Report Designer to a Progress OpenEdge database and to persist this data connection for subsequent reuse with the standalone Report Designer tool?   Thank you!  

I'm trying to compute the difference between two columns in a crosstab.

 The columns are generated based on a year value in the data source (spanning the last 5 years) and the field values are counts of the number of items in the data set that fall in the given year. I'm trying to add a column at the end which shows the increase/decrease in the counts between two of those columns (the first year in the 5-year period and the last year in the 5-year period). Since I don't know what the values of those years are, I need to determine those at runtime. (See ASCII example below)

Is there an easy way to do this? I've created a report parameter based on a stored procedure which gets me the value of the last year and then I calculate 5 years back from there but it doesn't seem like a very elegant solution.

Thanks,

Chris N

 

2011  2012  2013  2014  2015  5Y Increase

------------------------------------------------------------

3        4         3        6         10     7

olá! Tenho uma consulta no mysql que faz uma contagem da quantidade de inscrições. Mais no relatório está contando todos os itens da cosulta sem aplicar o filtro. Exemplo: 

SELECT
d.department,  
COUNT(d.cod_department) AS total_professionals

FROM department d
INNER JOIN professionals p ON d.cod_department = p.cod_department

where d.cod_business = 1

GROUP BY d.department 
ORDER BY d.department; 

 

run in mysql it returns:

cod_business      department         total_professionals
1                          department 1      32
1                          department 2      10
1                          department 3      15

no relatório substituindo a clausula where pelos filtros, é gerado o seguinte:

cod_business      department         total_professionals
1                          department 1      ​50
1                          department 2      ​70
1                          department 3      ​20​

 

the report returns the company departments '1', but makes the count in all businesses.

the filter is not being applied in the count.​

I am generating a report in which i want to hide some row if it is blank. I am using conditional formatting. I have unchecked visible check-box. So it supposed to be hidden if condition match.
when i try to change the background color of the row, it works. But with the same condition if i try to hide the row (by unchecking VISIBLE checkbox) it do not hide the row.
Why is this happening.
I am using Telerik Reporting Version: 4.2.10.1130

Reply as soon as possible.

I've applied both grouping and a filtering rule to my table. If one of the elements in a group is rejected by the filter, the entire group is rejected. It appears as if Report Designer filters out every entry in a group if any entry doesn't meet the filtering criteria.

Has anyone run into this problem before? Is there any way to filter data before grouping it?

I created my reports into a library class Project but i don't know how show that report in the report viewer in my asp.net app.

 

I added the library class Project in the references and System.ServiceModel , i want to do it programately.

 

thank you

Hi, 

 

We are looking for a reporting tool (in ASP.NET MVC) which can generate reports on the fly based on the selected input parameters. 

In the model class i will have a list<list<string> which will contain the data to be binded to the report. Attaching a similar report which was dynamically generated on the fly for the reference. 

 

Regards,

Balu

Hi,
I have a asp.net MVC 4 application and I'm considering to include a reporting tools "telerik reporting".
Are there some example about how to show a report in HTML5 Report Viewer under these constraints:
1. The report is created with standalone telerik report designer and it is save as trdx file in  /App_Data folder,  so Report has to retrieved from /App_Data folder
     (use CustomReportResolver : IReportResolver  ?).

2. The report has to use a ObjectDataSource (eg.: list of object like List<Cars>) and the binding is done at runtime before the reports is shown, the list of object has to got from a repository class

    How to create fields on report at Design Time from ObjectDataSource  in standalone telerik report designer.



Thanks for any advice.

Not sure the best way to explain so I figured I'd give a description and hopefully it'll make sense. :)

I have a cross tab report that uses the 12 months of the year for the rows and 2 consecutive years for the columns, and sum amounts in the details section. (12x2 grid with sum details).

 

My SQL data source has all the details needed, but these details are split up by an account number. So, if I have 100 accounts * 2 years * 12 months = 2400 rows of data in my data source.

(ex: Acct1, Jan, 2012,12units || Acct2, Jan, 2012, 2units || Acct1, Feb, 2012, 8units || etc.)

 

My end goal is to do a grouping by account and do a page break after group​'s footer to get 100 separate data pages (one for each account) each with a cross-tab containing the 12x2 grid ​showing all the details for only that one account. I'm hoping to do it with the single data  source SQL query (as opposed to making 100 separate round trips that may be needed to do each individual account).

 

Ideas? Thanks!