Posts tagged with 'activereports'
Grouping is one of the most commonly used feature when it comes to designing a report. Its implementation can vary from one report to another based on the requirements of the user. A very common scenario is starting each group from a new page. This helps in encapsulating the groups in one page or a range of pages, thus making it easier for a user to identify each group individually. The good thing here is that the GroupFooter section in ActiveReports provides a NewPage property which if set to "After", automatically starts the report from the next page, once the current group is completely rendered.
Microsoft's Entity Framework since its inception has become developer's favorite for mapping a Relational Database to a Conceptual Model. Its strength lies in the way it allows developers to modify the Conceptual Model as per their business logic and still be connected to the Relational Database. In simpler terms Microsoft Entity Framework creates a set of classes from the database schema and allows developers to work on these objects without worrying about the relational object model that works behind the scenes.
I'm pleased to announce ComponentOne PowerSuite. This new, limited-time offering from ComponentOne gives you three award-winning products in one suite:
Many times users come and ask for the CanGrow property of the Shape control in ActiveReports. Basically, this requirement arises for a shape, which surrounds Textboxes and requires to grow whenever the Textboxes inside it grows. As of now, ActiveReports 7.0 does not have any property to support this implementation.
Oracle happens to be a widely used datasource and let’s see how we can bind Section Reports to this database. So before we get started let’s get the ingredients in place that we would need for connecting to an Oracle datasource. The only thing that we would need is an Oracle Data Provider for .NET which would allow us to take advantage of Oracle database functionality and expose us the API that we would need to work with Oracle inside a .NET application. We have used the one that is provided by Oracle i.e. the ODP.NET library(Oracle.DataAccess.Client assembly). This library can be downloaded from here.
We have already discussed about using XSD (Typed Dataset) as a datasource for ActiveReports' Section Reports in this article. However, we didn't discuss about how to use it in case of Page Reports. The tricks of the trade remains almost same with some minor changes to make this work.
Any reporting tool cannot be called complete without a charting feature. ActiveReports 7 being a very robust reporting tool provides a nice support for different types of charts. In one of the blog posts, I discussed about creating a dynamic Pie Chart and in this blog post I would be discussing about creating a Stacked Bar chart at run time. A Stacked bar chart is a graph that is used to compare the parts to the whole. The bars in a stacked bar graph are divided into categories. Each bar represents a total.
ActiveReport’s End User Designer (EUD) has always being the star attraction for both developers and end users. The idea of giving the real end users the power to Create or Edit reports and Write Script code, seems to be what has captured the imagination of many customers. They always wanted to take this functionality a step further and use it on the Web as well. Unfortunately, this is where a line needs to be drawn since the EUD is a Windows Form control and therefore cannot be used on the Web.
The best thing about ActiveReports is that it can be customized the way you like to. Exporting a report to PDF, over the web is one of the coolest feature of ActiveReports. However this can be made more presentable and attractive by including a "Loading Spinner" to indicate that the report is being exported, and work is in progress. The following image will make it more clear.
ActiveReports 7 being a powerful and flexible report tool supports parameters and stored procedures. Parameters allow users to display a report in accordance to the values they pass to the report. In ActiveReports 7, the HtmlViewer type of the WebViewer control allow users to pass parameters to the report; however one common question which users have is how to pass parameters over the web from a different aspx page.
ActiveReports 7 happens to be latest addition to the legacy of ActiveReports. Talking of legacy, we still have few customers who are still using the COM version of ActiveReports, and would like to migrate to ActiveReports 7 which targets the .NET platform.
The Grouping feature of ActiveReports allows to group the data (keep them together) in a report. All you need is to set the Group Header section's DataField property to the field on which you want to group the report. When you run the report, it renders the group header, followed by all the related instances of detail section, and then the group footer (considering non-multiple grouping scenario). You can set one or more than one nested groups in a report, known as multiple grouping. You can find more information about this in Grouping Data topic in our documentation site.
Users often want to display both positive and negative values on the Bar chart and require the bars to be plotted on either side of the X Axis depending on whether the Y value is positive or negative. This can be achieved by setting the Position property of the X Axis to 0. This results in X Axis to be plotted from the position where Y value is 0.
If you ever wanted to export SectionReports from ActiveReports 7 to JPEG image files and thought that it was a dead end, then you may not be aware of the the flexibility that ActiveReports offers. Let's get into the technicality of this subject and make our way through exporting SectionReports to JPEG Files.
ActiveReports 7 is natively not supported in the WPF environment. However it can be hosted in WPF with the help of WPF's WindowsFormsHost control which allows you to host a Windows Forms control inside WPF applications. You just need to host the ActiveReports 7 Viewer control (which is responsible for rendering the report) using the WindowsFormHost control and you can view ActiveReports 7 reports in WPF .
Sorting is currently not supported in the Section Based Reports available within ActiveReports 7. The most common approach which a user has to take to sort a report is to use the Order By clause while defining the SQL query for the data source. This approach works well for a static sorting on a particular column. However, a user is still not able to interact with the report on the viewer and sort it once it is displayed. So what if user wants to sort any column of the report in Ascending/Descending order but only after it gets displayed on the Windows Viewer?
ComponentOne provides two reporting tools namely ActiveReports 7 and C1Report . These components give developers and the end users similar flexibility to connect reports to various data sources. One data source that has been garnering a lot of attention has been the XSD or the Typed Dataset.
A few days ago we released ActiveReports 7 Hotfix 1 to add full support for VS2012! In addition to supporting VS2012 and .NET Framework 4.5, this release also adds several other features:
When we talk about official reports, Charting is one feature which plays a very important role while analyzing a report and sometimes in decision making.