Creating Dynamic reports with segate crystal report 8.5

[abhi.ashok]

Hi all,

My application has reporting feature and i have been showing predefined reports using crystal report 8.5. Now we want to give the user the option to create his own custom defined reports, dynamically and see them . I'm entirely new to dynamic reports.

Please guide me how to start and create the dynamic reports. Do i need any license or something like that.

Thanks

[Lugh]

It depends on exactly what you are doing.

The simplest kind of dynamic report is simply parameter-driven. You have a number of parameters, which can affect record selection and which fields are displayed. You can set Crystal to suppress fields, sections, or subreports, based on parameters. You can also set size and location based on parameters. If you're just looking for users to have the capability of shaping data in one particular view, this is a very powerful, flexible option that has a relatively shallow learning curve.

If you need to get more advanced, such as being able to define the SQL query at execution time, you're going to need to embed the report in a VB application. I'm not exactly sure what you would do with 8.5. I know that VB .Net generally works with Crystal X. The API allows you to reach in and modify all sorts of things at runtime.