Use customized layouts to mimic print-based reports. Please see my other Telerik report articles. Telerik not only offers many power capabilities to produce standard tabular reports (see other articles), but I can also create highly customized layouts like the following report. Note the precision positioning of many fields, dynamic tables which grow/shrink as needed while conserving vertical…
Use multiple groups to present a multilevel hierarchy Please see my other Telerik report articles. In this article I’ll demonstrate how to present data within a hierarchy using multiple groups. As you can see, I have three hierarchies or level of data by which I wish to group to avoid repeating duplicate data for the last three…
Display data with conditional expressions Please see my other Telerik report articles. In this article, I’ll demonstrate how to use an IIf() expression to determine whether data exists and display it, or display nothing. In the example above, notice how the first Org displays give website links where the last Org only displays one. Note how the…
Use conditional formatting to change the background to only part of a cell Please see my other Telerik report articles. In my other Telerik Reports: Filtered Columns column I illustrated how to filter one column data off the other. You’ll notice in the article one of the column cells display a yellow background and only to part…
Filter Column Data Off Other Column Please see my other Telerik report articles. In the article I’ll demonstrate a four column report where two columns display data based on their relationship with their “parent” column. As you can, the report begins with a county, then region, then two coordinators – primary and assistant. First, I’ll create a…
Use a function to produce a series In this article I’ll demonstrate how to use the R language to create a function to produce a series, then print it to the screen. First, I’ll declare a function which produces a series from 1-5, assign it to the variable ‘f’, then invoke the function, which prints…
Please see my other Business Intelligence articles. R is an open source implementation of statistical programming language S, a programming language and environment in which to program, and provides ability to analyze data statistically and visually. Please click the links below to view examples. R Create a Series Function
Please see my other Telerik report articles. Use an Html Textbox and expression to build clickable links In my report, I display social media links for each organizational record. As you can see, while the data display correctly, it’s layout is static – each row is fixed in position, and when one link is missing (Website), the…
Please see my other Telerik report articles. Use an expression to conditionally display data In my report, I display social media links for each organizational record. As you can see, while the data display correctly, it’s layout is static – each row is fixed in position, and when one link is missing (Website), the entire row space…
Please see my other Telerik report articles. Display Current Windows Username In this article I’ll demonstrate how to display the Windows username of the current user of a report.I’ll start by using the report’s ReportParameter’s editor to add a single Parameter “UserName”. This addition not only is required to display the property in the report,…
TechMbaBi 