crystal reports viewers, crystal reports schedulers, view crystal reports, report analyzers, burst reporting, report scheduler
 
view crystal reports, rpt viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler
desktop viewer, crystal reports viewers, crystal reports schedulers, report analyzers, burst reporting, report scheduler

Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 


Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
Analyzers
Bestsellers
CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs
ReCrystallizePro


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
 

CrystalReports
on Steroids

Crystal Reports:
Changing the selection formula on a Web report

The Web component server is very easy to invoke from a Web page. But you can also modify the record selection formula when you call the report. This allows you to have one report, with links invoking different selection formulas.

The selection formula is invoked using the sf tag as follows:

http://servername/folder/this.rpt?sf=xxxxxx

where xxxxx is a valid crystal selection formula. The catch is that you cannot type a equals sign (=) in directly to the formula. The equal sign is interpreted as another tag to send to the report. 

So, how do you enter these record selection formulas? You have to replace the equal sign with its URL equivalent. To select region equals to "CA" enter the URL as:

…./this.rpt?sf={Customer.Region}+%3d+’CA’

This will general a record selection formula of:

{Customer.Region}=’CA’. Group Selection formulas can be done in a similar way with the ?gf= tag

 

Now, this leads to another concept. What if you don't use the full-blown, high-dollar version of Crystal Reports and you want some Web functionality? It's still possible.

The solution is Recrystallize Pro. With this program, you can view your Crystal Reports on the Web with live data.

You can provide user-specific information to your managers, sales force, stockholders, employees, customers, or anyone you choose--with a few easy steps.

ReCrystallize Pro creates Web pages for viewing your Crystal Reports with up-to-the-minute data.

ReCrystallize Pro allows you to make your Crystal Reports available on your intranet or extranet. Now you can provide user-specific information to your managers, sales force, stockholders, employees, customers, or anyone you choose--with a few easy steps. Whether you have dozens of reports or you're just getting started, ReCrystallize Pro helps you to leverage your investment in Crystal Reports.

ReCrystallize Pro is designed for for Crystal Reports versions 7, 8.0, 8.5, 9, 10, XI, XI R2, 2008, and 2011. See below for features.

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.

 

Recrystallize Pro Features

General:
  • Requires no programming.
  • Generates customizable, user-friendly Web pages to prompt for report parameters.
  • Can automatically default or calculate report parameters such as the current date, last day of the week, or last day of the month.
  • Web pages can be easily customized using most popular Web authoring tools.
  • Automatic report option improves response time by refreshing data from your database only when the specified time has expired. Great for reports that change daily!
  • Presents your report using your choice of HTML, HTML with Frames, Java, or ActiveX page-on-demand viewers or as Adobe PDF, Microsoft Word, Microsoft Excel, or Rich Text Format (RTF) files.
  • Allows you to customize the Crystal Report Viewer interface. If desired, you can prevent users from saving the data in your Crystal Report by disabling printing and exporting.
  • Allows you to email reports directly from your Web page in Adobe PDF, Microsoft Excel, Microsoft Word, or RTF formats.

Static vs. dynamic:

  • Static report option runs your Crystal Reports with saved data to provide nearly instantaneous response times when your report data doesn't change frequently.
  • Dynamic report option refreshes data whenever your report is requested to provide up-to-the-minute reports that may contain different information for each user.

Works with:

  • Virtually any data source.
  • The Crystal Web Component Server/Crystal Enterprise and virtually any Windows-based Web server to run your reports on the Web.
  • Active Server Pages (ASP) andCrystal Reports Web components to run your reports on the Web, providing additional security, power, and flexibility.
  • Your Web server and data source to provide report level, table level, and/or record level security; using ASP ensures that data source user ids, passwords, and preset report parameters can be securely hidden from users.

About the .NET based Crystal Reports viewer:

  • Works without any download or installation to client web browsers. It eliminates viewer downloads, confusing installation prompts, and issues with the ActiveX viewer not installing properly when using Internet Explorer 9.
  • Iis compatible with practically all full web browsers, including Chrome, Firefox, Internet Explorer, Opera, and Safari. It even works with iPhone, iPad and Android mobile devices. Now you can provide a clear, consistent, and fast report delivery experience to Web users regardless of the platform or browser.
  • The parameter panel allows easy, on-the-fly changes to parameter values with no need to back up to the previous web page and run the report again.

ASP:

  • ASP.NET is available for better support of current Crystal Reports and Windows Server / IIS versions.
  • ASP code can be customized by developers to change the report's appearance or behavior.
  • Native Crystal Reports parameter prompting is available to provide the same look, feel, and capabilities on the web as in the Crystal Reports designer.
  • Dynamic, cascading, and optional parameters are fully supported when using ASP.NET.

Version compatibility:

  • Crystal Reports versions 2008 and 2011 are supported with version-specific downloads that allow you to take full advantage of new Crystal Reports features.
  • Older Crystal Reports versions are supported with no changes to your .rpt files. You can use ASP.NET and the .NET viewer with older reports or use “classic” ASP with the Java or ActiveX viewers familiar from previous versions.