Report Bursting with SAP Crystal Reports Server 2008

Visit www.sapdiary.com

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.

View the original article here

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.

View the original article here

Report Bursting with SAP Crystal Reports Server 2008

(Post #3 of 3 for Reportapalooza – Focused on SAP Crystal Reports Server 2008).

The idea to write about Report Bursting in SAP Crystal Reports Server 2008 came to me on the shuttle bus on the way to the airport in Orlando after a very successful (and one shiny iPad later) ASUG SAP BusinessObjects User Conference. The idea came by way of friend and fellow Reportapalooza expert – Brian Durning.

We were having a conversation about the “Reporting Remix” challenge and I asked his opinion on topics to discuss when writing about SAP Crystal Reports Server 2008. Brian is a highly accomplished SAP Crystal solutions expert and his immediate recommendation was Report Bursting. After some investigation, I now know why he made this suggestion. Report Bursting is a really powerful, convenient, and efficient process that minimizes the need for excessive individual report scheduling.

As the previous paragraph suggests, the inclusion of Report Bursting is one of the most anticipated enhancements to SAP Crystal Reports Server 2008. If setup correctly, this elusive feature is an SAP Crystal and BOE administrator’s dream. But if setup incorrectly, it will quickly become a DBA’s nightmare.  That’s why Report Bursting should be carefully researched and tested before implementing in a production environment. Once you’re ready, scheduling reports will never be the same (in a GOOD way).

What is Report Bursting?

Report Bursting in SAP Crystal Reports Server 2008 allows multiple groups of reports (known as Publications) to be scheduled and distributed to personalized groups of recipients with each group receiving reports containing data filtered differently. This is accomplished when the SQL statement is submitted to the database by the individual SAP Crystal Reports multiple times with different filtered values fetching different data values for each group.

This process provides the most efficient way of scheduling and distributing reports to a large number of users who require the same or similar reports but filtered by different parameters.

The reason that Report Bursting should be entered into cautiously is because of the potential impact on system resources. If the option “One database fetch per recipient” is selected when creating a Publication, the SQL statement of each report will query the database one time for each recipient. This option will almost definitely catch the eye of the DBAs if the recipient list is of significant size. But one database fetch per “batch” of recipients might be much less expensive and fly well below the DBA’s radar.

Creating a New Publication for Report Scheduling

To create a new Publication, begin by selecting a folder from the file menu in InfoView. Once you’ve done this, click New in the default toolbar and select Publication. This is displayed in the screenshot below.

Once “Publication” is selected from the list of choices, you’ll have three options when the “New Publication” window opens.

SummaryGeneral PropertiesSource Documents

In the General Properties section, give your new Publication a name, description (optional), keywords (optional), and then select the Source Documents option. Next click Add to select the reports that will become a part of the Publication that will “Refresh at Runtime”. Multiple reports can be selected as part of a single Publication.

As soon as reports are added, six new options are made available. The “New Publication” now has the following property sections.

SummaryGeneral PropertiesSource DocumentsEnterprise RecipientsDynamic RecipientsPersonalizationFormatsDestinationsAdditional Options

The “Additional Options” section contains eight different options:

Print SettingsDelivery RulesMerged PDF OptionsDatabase LogonRecurrenceEventsScheduling Server GroupAdvanced

Select the Advanced category and you’ll see settings in three different groups:

Profile ResolutionPersonalizationReport Bursting Method

The Report Bursting Methods section provides three choices for bursting:

One database fetch for all recipients (recommended for minimizing the number of database queries)One database fetch for each batch of recipients (recommended for high-volume scenarios)One database fetch per recipient (recommended when using row level security within Universes or Business Views)

Report Bursting Methods Described

One database fetch for all recipients – This option will submit the SQL statement of each report to the database once per report then deliver the data in the specified format to each recipient.  This method uses the database logon credentials of the publisher.One database fetch for each batch of recipients – This is the default option when scheduling Crystal Reports. Batches can run concurrently on different servers to reduce the load on the system (keeping the DBAs happy). The size of the batches depends on the specified personalization. This method uses the database logon credentials of the publisher.One database fetch per recipient – This method uses the data source logon credentials of each recipient as the query is submitted to the database once per report for each recipient in the publication. This option provides the greatest level of security but also produces the greatest load on the system if the recipient list is large.

Publications

In addition to Report Bursting, Publications provide an extensive set of options. Among the options that you’ll want to pay special attention to are the: Print Settings, Delivery Rules, Database Logon Credentials, Recurrence, and Events. Settings such as: Personalization, Formats, and Destinations should also be configured completely before saving and implementing a Publication.

Be sure to view the Summary option and review your selections before finalizing your Publication. You should also test your Publication before making it live. Refer to official SAP documentation for a more in-depth discussion of Publications and information regarding the various other options to configure, save, schedule, and view publication results.

Summary

After finally experiencing SAP Crystal Reports Server 2008, I am surprised at the great deal of sophisticated methods of delivering reports to users across the enterprise. Whether through the convenience of the portal , the use of automated report scheduling, or the use of personalized Publications for Report Bursting, SAP Crystal Reports Server 2008 is an excellent product for sharing information with users.

Questions? Please contact me.
Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

Report Distribution Options in Crystal Reports

There are various ways you can distribute the reports you designed in Crystal Reports even if you aren’t using Crystal Reports Server or any other Enterprise Servers. Some of the ways are the old standby methods such as PDF and MSWord. These methods work fine, as they definitively meet the needs of the organizations report readers.

Some designers choose to Export the reports to Excel or other applications. There are two methods of exporting to Excel – one has the suffix ‘Data-only’ in the Export box.

This particular Export Format allows the designer to include “Worksheet Functions” to the Export allowing more calculations on the report data. The other Export Format to Excel does not offer that option: it is more like a photograph of the report.

Other Export options include:

HTMLODBCRecord Style (columns with or without spaces)Comma Separated TextTab Separated TextRich Text Format and XML

All of these are accessed through the Export dialog box above under the File Menu.

Aside from the Export, the report designer can assist a user in downloading the Crystal Reports Viewer. This is a free download sent to local machines. When the user wants to view the report, the user opens the Viewer and opens the report in the Viewer. The report is displayed as the designer intended it to be seen. The Viewer can also display any ‘drilldowns’ that were designed into the report, which many other formats cannot.

The last method I will mention here is crystalreports.com. This is a secure report hosting service available at crystalreports.com; for those that simply need to see reports. The user logs into specific URLs to view specific reports within the folders you have created. No need for hard copies or email attachments. This is available with free trial for three named users at above website. It offers several different options, with a monthly structured plan.

View the original article here

Report Bursting with SAP Crystal Reports Server 2008

(Post #3 of 3 for Reportapalooza – Focused on SAP Crystal Reports Server 2008).

The idea to write about Report Bursting in SAP Crystal Reports Server 2008 came to me on the shuttle bus on the way to the airport in Orlando after a very successful (and one shiny iPad later) ASUG SAP BusinessObjects User Conference. The idea came by way of friend and fellow Reportapalooza expert – Brian Durning.

We were having a conversation about the “Reporting Remix” challenge and I asked his opinion on topics to discuss when writing about SAP Crystal Reports Server 2008. Brian is a highly accomplished SAP Crystal solutions expert and his immediate recommendation was Report Bursting. After some investigation, I now know why he made this suggestion. Report Bursting is a really powerful, convenient, and efficient process that minimizes the need for excessive individual report scheduling.

As the previous paragraph suggests, the inclusion of Report Bursting is one of the most anticipated enhancements to SAP Crystal Reports Server 2008. If setup correctly, this elusive feature is an SAP Crystal and BOE administrator’s dream. But if setup incorrectly, it will quickly become a DBA’s nightmare.  That’s why Report Bursting should be carefully researched and tested before implementing in a production environment. Once you’re ready, scheduling reports will never be the same (in a GOOD way).

What is Report Bursting?

Report Bursting in SAP Crystal Reports Server 2008 allows multiple groups of reports (known as Publications) to be scheduled and distributed to personalized groups of recipients with each group receiving reports containing data filtered differently. This is accomplished when the SQL statement is submitted to the database by the individual SAP Crystal Reports multiple times with different filtered values fetching different data values for each group.

This process provides the most efficient way of scheduling and distributing reports to a large number of users who require the same or similar reports but filtered by different parameters.

The reason that Report Bursting should be entered into cautiously is because of the potential impact on system resources. If the option “One database fetch per recipient” is selected when creating a Publication, the SQL statement of each report will query the database one time for each recipient. This option will almost definitely catch the eye of the DBAs if the recipient list is of significant size. But one database fetch per “batch” of recipients might be much less expensive and fly well below the DBA’s radar.

Creating a New Publication for Report Scheduling

To create a new Publication, begin by selecting a folder from the file menu in InfoView. Once you’ve done this, click New in the default toolbar and select Publication. This is displayed in the screenshot below.

Once “Publication” is selected from the list of choices, you’ll have three options when the “New Publication” window opens.

SummaryGeneral PropertiesSource Documents

In the General Properties section, give your new Publication a name, description (optional), keywords (optional), and then select the Source Documents option. Next click Add to select the reports that will become a part of the Publication that will “Refresh at Runtime”. Multiple reports can be selected as part of a single Publication.

As soon as reports are added, six new options are made available. The “New Publication” now has the following property sections.

SummaryGeneral PropertiesSource DocumentsEnterprise RecipientsDynamic RecipientsPersonalizationFormatsDestinationsAdditional Options

The “Additional Options” section contains eight different options:

Print SettingsDelivery RulesMerged PDF OptionsDatabase LogonRecurrenceEventsScheduling Server GroupAdvanced

Select the Advanced category and you’ll see settings in three different groups:

Profile ResolutionPersonalizationReport Bursting Method

The Report Bursting Methods section provides three choices for bursting:

One database fetch for all recipients (recommended for minimizing the number of database queries)One database fetch for each batch of recipients (recommended for high-volume scenarios)One database fetch per recipient (recommended when using row level security within Universes or Business Views)

Report Bursting Methods Described

One database fetch for all recipients – This option will submit the SQL statement of each report to the database once per report then deliver the data in the specified format to each recipient.  This method uses the database logon credentials of the publisher.One database fetch for each batch of recipients – This is the default option when scheduling Crystal Reports. Batches can run concurrently on different servers to reduce the load on the system (keeping the DBAs happy). The size of the batches depends on the specified personalization. This method uses the database logon credentials of the publisher.One database fetch per recipient – This method uses the data source logon credentials of each recipient as the query is submitted to the database once per report for each recipient in the publication. This option provides the greatest level of security but also produces the greatest load on the system if the recipient list is large.

Publications

In addition to Report Bursting, Publications provide an extensive set of options. Among the options that you’ll want to pay special attention to are the: Print Settings, Delivery Rules, Database Logon Credentials, Recurrence, and Events. Settings such as: Personalization, Formats, and Destinations should also be configured completely before saving and implementing a Publication.

Be sure to view the Summary option and review your selections before finalizing your Publication. You should also test your Publication before making it live. Refer to official SAP documentation for a more in-depth discussion of Publications and information regarding the various other options to configure, save, schedule, and view publication results.

Summary

After finally experiencing SAP Crystal Reports Server 2008, I am surprised at the great deal of sophisticated methods of delivering reports to users across the enterprise. Whether through the convenience of the portal , the use of automated report scheduling, or the use of personalized Publications for Report Bursting, SAP Crystal Reports Server 2008 is an excellent product for sharing information with users.

Questions? Please contact me.
Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.

View the original article here

Report Distribution Options in Crystal Reports

There are various ways you can distribute the reports you designed in Crystal Reports even if you aren’t using Crystal Reports Server or any other Enterprise Servers. Some of the ways are the old standby methods such as PDF and MSWord. These methods work fine, as they definitively meet the needs of the organizations report readers.

Some designers choose to Export the reports to Excel or other applications. There are two methods of exporting to Excel – one has the suffix ‘Data-only’ in the Export box.

This particular Export Format allows the designer to include “Worksheet Functions” to the Export allowing more calculations on the report data. The other Export Format to Excel does not offer that option: it is more like a photograph of the report.

Other Export options include:

HTMLODBCRecord Style (columns with or without spaces)Comma Separated TextTab Separated TextRich Text Format and XML

All of these are accessed through the Export dialog box above under the File Menu.

Aside from the Export, the report designer can assist a user in downloading the Crystal Reports Viewer. This is a free download sent to local machines. When the user wants to view the report, the user opens the Viewer and opens the report in the Viewer. The report is displayed as the designer intended it to be seen. The Viewer can also display any ‘drilldowns’ that were designed into the report, which many other formats cannot.

The last method I will mention here is crystalreports.com. This is a secure report hosting service available at crystalreports.com; for those that simply need to see reports. The user logs into specific URLs to view specific reports within the folders you have created. No need for hard copies or email attachments. This is available with free trial for three named users at above website. It offers several different options, with a monthly structured plan.

View the original article here

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.

View the original article here

Report Distribution Options in Crystal Reports

There are various ways you can distribute the reports you designed in Crystal Reports even if you aren’t using Crystal Reports Server or any other Enterprise Servers. Some of the ways are the old standby methods such as PDF and MSWord. These methods work fine, as they definitively meet the needs of the organizations report readers.

Some designers choose to Export the reports to Excel or other applications. There are two methods of exporting to Excel – one has the suffix ‘Data-only’ in the Export box.

This particular Export Format allows the designer to include “Worksheet Functions” to the Export allowing more calculations on the report data. The other Export Format to Excel does not offer that option: it is more like a photograph of the report.

Other Export options include:

HTMLODBCRecord Style (columns with or without spaces)Comma Separated TextTab Separated TextRich Text Format and XML

All of these are accessed through the Export dialog box above under the File Menu.

Aside from the Export, the report designer can assist a user in downloading the Crystal Reports Viewer. This is a free download sent to local machines. When the user wants to view the report, the user opens the Viewer and opens the report in the Viewer. The report is displayed as the designer intended it to be seen. The Viewer can also display any ‘drilldowns’ that were designed into the report, which many other formats cannot.

The last method I will mention here is crystalreports.com. This is a secure report hosting service available at crystalreports.com; for those that simply need to see reports. The user logs into specific URLs to view specific reports within the folders you have created. No need for hard copies or email attachments. This is available with free trial for three named users at above website. It offers several different options, with a monthly structured plan.

View the original article here

Report Bursting with SAP Crystal Reports Server 2008

(Post #3 of 3 for Reportapalooza – Focused on SAP Crystal Reports Server 2008).

The idea to write about Report Bursting in SAP Crystal Reports Server 2008 came to me on the shuttle bus on the way to the airport in Orlando after a very successful (and one shiny iPad later) ASUG SAP BusinessObjects User Conference. The idea came by way of friend and fellow Reportapalooza expert – Brian Durning.

We were having a conversation about the “Reporting Remix” challenge and I asked his opinion on topics to discuss when writing about SAP Crystal Reports Server 2008. Brian is a highly accomplished SAP Crystal solutions expert and his immediate recommendation was Report Bursting. After some investigation, I now know why he made this suggestion. Report Bursting is a really powerful, convenient, and efficient process that minimizes the need for excessive individual report scheduling.

As the previous paragraph suggests, the inclusion of Report Bursting is one of the most anticipated enhancements to SAP Crystal Reports Server 2008. If setup correctly, this elusive feature is an SAP Crystal and BOE administrator’s dream. But if setup incorrectly, it will quickly become a DBA’s nightmare.  That’s why Report Bursting should be carefully researched and tested before implementing in a production environment. Once you’re ready, scheduling reports will never be the same (in a GOOD way).

What is Report Bursting?

Report Bursting in SAP Crystal Reports Server 2008 allows multiple groups of reports (known as Publications) to be scheduled and distributed to personalized groups of recipients with each group receiving reports containing data filtered differently. This is accomplished when the SQL statement is submitted to the database by the individual SAP Crystal Reports multiple times with different filtered values fetching different data values for each group.

This process provides the most efficient way of scheduling and distributing reports to a large number of users who require the same or similar reports but filtered by different parameters.

The reason that Report Bursting should be entered into cautiously is because of the potential impact on system resources. If the option “One database fetch per recipient” is selected when creating a Publication, the SQL statement of each report will query the database one time for each recipient. This option will almost definitely catch the eye of the DBAs if the recipient list is of significant size. But one database fetch per “batch” of recipients might be much less expensive and fly well below the DBA’s radar.

Creating a New Publication for Report Scheduling

To create a new Publication, begin by selecting a folder from the file menu in InfoView. Once you’ve done this, click New in the default toolbar and select Publication. This is displayed in the screenshot below.

Once “Publication” is selected from the list of choices, you’ll have three options when the “New Publication” window opens.

SummaryGeneral PropertiesSource Documents

In the General Properties section, give your new Publication a name, description (optional), keywords (optional), and then select the Source Documents option. Next click Add to select the reports that will become a part of the Publication that will “Refresh at Runtime”. Multiple reports can be selected as part of a single Publication.

As soon as reports are added, six new options are made available. The “New Publication” now has the following property sections.

SummaryGeneral PropertiesSource DocumentsEnterprise RecipientsDynamic RecipientsPersonalizationFormatsDestinationsAdditional Options

The “Additional Options” section contains eight different options:

Print SettingsDelivery RulesMerged PDF OptionsDatabase LogonRecurrenceEventsScheduling Server GroupAdvanced

Select the Advanced category and you’ll see settings in three different groups:

Profile ResolutionPersonalizationReport Bursting Method

The Report Bursting Methods section provides three choices for bursting:

One database fetch for all recipients (recommended for minimizing the number of database queries)One database fetch for each batch of recipients (recommended for high-volume scenarios)One database fetch per recipient (recommended when using row level security within Universes or Business Views)

Report Bursting Methods Described

One database fetch for all recipients – This option will submit the SQL statement of each report to the database once per report then deliver the data in the specified format to each recipient.  This method uses the database logon credentials of the publisher.One database fetch for each batch of recipients – This is the default option when scheduling Crystal Reports. Batches can run concurrently on different servers to reduce the load on the system (keeping the DBAs happy). The size of the batches depends on the specified personalization. This method uses the database logon credentials of the publisher.One database fetch per recipient – This method uses the data source logon credentials of each recipient as the query is submitted to the database once per report for each recipient in the publication. This option provides the greatest level of security but also produces the greatest load on the system if the recipient list is large.

Publications

In addition to Report Bursting, Publications provide an extensive set of options. Among the options that you’ll want to pay special attention to are the: Print Settings, Delivery Rules, Database Logon Credentials, Recurrence, and Events. Settings such as: Personalization, Formats, and Destinations should also be configured completely before saving and implementing a Publication.

Be sure to view the Summary option and review your selections before finalizing your Publication. You should also test your Publication before making it live. Refer to official SAP documentation for a more in-depth discussion of Publications and information regarding the various other options to configure, save, schedule, and view publication results.

Summary

After finally experiencing SAP Crystal Reports Server 2008, I am surprised at the great deal of sophisticated methods of delivering reports to users across the enterprise. Whether through the convenience of the portal , the use of automated report scheduling, or the use of personalized Publications for Report Bursting, SAP Crystal Reports Server 2008 is an excellent product for sharing information with users.

Questions? Please contact me.
Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

Report Bursting with SAP Crystal Reports Server 2008

(Post #3 of 3 for Reportapalooza – Focused on SAP Crystal Reports Server 2008).

The idea to write about Report Bursting in SAP Crystal Reports Server 2008 came to me on the shuttle bus on the way to the airport in Orlando after a very successful (and one shiny iPad later) ASUG SAP BusinessObjects User Conference. The idea came by way of friend and fellow Reportapalooza expert – Brian Durning.

We were having a conversation about the “Reporting Remix” challenge and I asked his opinion on topics to discuss when writing about SAP Crystal Reports Server 2008. Brian is a highly accomplished SAP Crystal solutions expert and his immediate recommendation was Report Bursting. After some investigation, I now know why he made this suggestion. Report Bursting is a really powerful, convenient, and efficient process that minimizes the need for excessive individual report scheduling.

As the previous paragraph suggests, the inclusion of Report Bursting is one of the most anticipated enhancements to SAP Crystal Reports Server 2008. If setup correctly, this elusive feature is an SAP Crystal and BOE administrator’s dream. But if setup incorrectly, it will quickly become a DBA’s nightmare.  That’s why Report Bursting should be carefully researched and tested before implementing in a production environment. Once you’re ready, scheduling reports will never be the same (in a GOOD way).

What is Report Bursting?

Report Bursting in SAP Crystal Reports Server 2008 allows multiple groups of reports (known as Publications) to be scheduled and distributed to personalized groups of recipients with each group receiving reports containing data filtered differently. This is accomplished when the SQL statement is submitted to the database by the individual SAP Crystal Reports multiple times with different filtered values fetching different data values for each group.

This process provides the most efficient way of scheduling and distributing reports to a large number of users who require the same or similar reports but filtered by different parameters.

The reason that Report Bursting should be entered into cautiously is because of the potential impact on system resources. If the option “One database fetch per recipient” is selected when creating a Publication, the SQL statement of each report will query the database one time for each recipient. This option will almost definitely catch the eye of the DBAs if the recipient list is of significant size. But one database fetch per “batch” of recipients might be much less expensive and fly well below the DBA’s radar.

Creating a New Publication for Report Scheduling

To create a new Publication, begin by selecting a folder from the file menu in InfoView. Once you’ve done this, click New in the default toolbar and select Publication. This is displayed in the screenshot below.

Once “Publication” is selected from the list of choices, you’ll have three options when the “New Publication” window opens.

SummaryGeneral PropertiesSource Documents

In the General Properties section, give your new Publication a name, description (optional), keywords (optional), and then select the Source Documents option. Next click Add to select the reports that will become a part of the Publication that will “Refresh at Runtime”. Multiple reports can be selected as part of a single Publication.

As soon as reports are added, six new options are made available. The “New Publication” now has the following property sections.

SummaryGeneral PropertiesSource DocumentsEnterprise RecipientsDynamic RecipientsPersonalizationFormatsDestinationsAdditional Options

The “Additional Options” section contains eight different options:

Print SettingsDelivery RulesMerged PDF OptionsDatabase LogonRecurrenceEventsScheduling Server GroupAdvanced

Select the Advanced category and you’ll see settings in three different groups:

Profile ResolutionPersonalizationReport Bursting Method

The Report Bursting Methods section provides three choices for bursting:

One database fetch for all recipients (recommended for minimizing the number of database queries)One database fetch for each batch of recipients (recommended for high-volume scenarios)One database fetch per recipient (recommended when using row level security within Universes or Business Views)

Report Bursting Methods Described

One database fetch for all recipients – This option will submit the SQL statement of each report to the database once per report then deliver the data in the specified format to each recipient.  This method uses the database logon credentials of the publisher.One database fetch for each batch of recipients – This is the default option when scheduling Crystal Reports. Batches can run concurrently on different servers to reduce the load on the system (keeping the DBAs happy). The size of the batches depends on the specified personalization. This method uses the database logon credentials of the publisher.One database fetch per recipient – This method uses the data source logon credentials of each recipient as the query is submitted to the database once per report for each recipient in the publication. This option provides the greatest level of security but also produces the greatest load on the system if the recipient list is large.

Publications

In addition to Report Bursting, Publications provide an extensive set of options. Among the options that you’ll want to pay special attention to are the: Print Settings, Delivery Rules, Database Logon Credentials, Recurrence, and Events. Settings such as: Personalization, Formats, and Destinations should also be configured completely before saving and implementing a Publication.

Be sure to view the Summary option and review your selections before finalizing your Publication. You should also test your Publication before making it live. Refer to official SAP documentation for a more in-depth discussion of Publications and information regarding the various other options to configure, save, schedule, and view publication results.

Summary

After finally experiencing SAP Crystal Reports Server 2008, I am surprised at the great deal of sophisticated methods of delivering reports to users across the enterprise. Whether through the convenience of the portal , the use of automated report scheduling, or the use of personalized Publications for Report Bursting, SAP Crystal Reports Server 2008 is an excellent product for sharing information with users.

Questions? Please contact me.
Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

Report Distribution Options in Crystal Reports

There are various ways you can distribute the reports you designed in Crystal Reports even if you aren’t using Crystal Reports Server or any other Enterprise Servers. Some of the ways are the old standby methods such as PDF and MSWord. These methods work fine, as they definitively meet the needs of the organizations report readers.

Some designers choose to Export the reports to Excel or other applications. There are two methods of exporting to Excel – one has the suffix ‘Data-only’ in the Export box.

This particular Export Format allows the designer to include “Worksheet Functions” to the Export allowing more calculations on the report data. The other Export Format to Excel does not offer that option: it is more like a photograph of the report.

Other Export options include:

HTMLODBCRecord Style (columns with or without spaces)Comma Separated TextTab Separated TextRich Text Format and XML

All of these are accessed through the Export dialog box above under the File Menu.

Aside from the Export, the report designer can assist a user in downloading the Crystal Reports Viewer. This is a free download sent to local machines. When the user wants to view the report, the user opens the Viewer and opens the report in the Viewer. The report is displayed as the designer intended it to be seen. The Viewer can also display any ‘drilldowns’ that were designed into the report, which many other formats cannot.

The last method I will mention here is crystalreports.com. This is a secure report hosting service available at crystalreports.com; for those that simply need to see reports. The user logs into specific URLs to view specific reports within the folders you have created. No need for hard copies or email attachments. This is available with free trial for three named users at above website. It offers several different options, with a monthly structured plan.

View the original article here

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.

View the original article here

Report Bursting with SAP Crystal Reports Server 2008

(Post #3 of 3 for Reportapalooza – Focused on SAP Crystal Reports Server 2008).

The idea to write about Report Bursting in SAP Crystal Reports Server 2008 came to me on the shuttle bus on the way to the airport in Orlando after a very successful (and one shiny iPad later) ASUG SAP BusinessObjects User Conference. The idea came by way of friend and fellow Reportapalooza expert – Brian Durning.

We were having a conversation about the “Reporting Remix” challenge and I asked his opinion on topics to discuss when writing about SAP Crystal Reports Server 2008. Brian is a highly accomplished SAP Crystal solutions expert and his immediate recommendation was Report Bursting. After some investigation, I now know why he made this suggestion. Report Bursting is a really powerful, convenient, and efficient process that minimizes the need for excessive individual report scheduling.

As the previous paragraph suggests, the inclusion of Report Bursting is one of the most anticipated enhancements to SAP Crystal Reports Server 2008. If setup correctly, this elusive feature is an SAP Crystal and BOE administrator’s dream. But if setup incorrectly, it will quickly become a DBA’s nightmare.  That’s why Report Bursting should be carefully researched and tested before implementing in a production environment. Once you’re ready, scheduling reports will never be the same (in a GOOD way).

What is Report Bursting?

Report Bursting in SAP Crystal Reports Server 2008 allows multiple groups of reports (known as Publications) to be scheduled and distributed to personalized groups of recipients with each group receiving reports containing data filtered differently. This is accomplished when the SQL statement is submitted to the database by the individual SAP Crystal Reports multiple times with different filtered values fetching different data values for each group.

This process provides the most efficient way of scheduling and distributing reports to a large number of users who require the same or similar reports but filtered by different parameters.

The reason that Report Bursting should be entered into cautiously is because of the potential impact on system resources. If the option “One database fetch per recipient” is selected when creating a Publication, the SQL statement of each report will query the database one time for each recipient. This option will almost definitely catch the eye of the DBAs if the recipient list is of significant size. But one database fetch per “batch” of recipients might be much less expensive and fly well below the DBA’s radar.

Creating a New Publication for Report Scheduling

To create a new Publication, begin by selecting a folder from the file menu in InfoView. Once you’ve done this, click New in the default toolbar and select Publication. This is displayed in the screenshot below.

Once “Publication” is selected from the list of choices, you’ll have three options when the “New Publication” window opens.

SummaryGeneral PropertiesSource Documents

In the General Properties section, give your new Publication a name, description (optional), keywords (optional), and then select the Source Documents option. Next click Add to select the reports that will become a part of the Publication that will “Refresh at Runtime”. Multiple reports can be selected as part of a single Publication.

As soon as reports are added, six new options are made available. The “New Publication” now has the following property sections.

SummaryGeneral PropertiesSource DocumentsEnterprise RecipientsDynamic RecipientsPersonalizationFormatsDestinationsAdditional Options

The “Additional Options” section contains eight different options:

Print SettingsDelivery RulesMerged PDF OptionsDatabase LogonRecurrenceEventsScheduling Server GroupAdvanced

Select the Advanced category and you’ll see settings in three different groups:

Profile ResolutionPersonalizationReport Bursting Method

The Report Bursting Methods section provides three choices for bursting:

One database fetch for all recipients (recommended for minimizing the number of database queries)One database fetch for each batch of recipients (recommended for high-volume scenarios)One database fetch per recipient (recommended when using row level security within Universes or Business Views)

Report Bursting Methods Described

One database fetch for all recipients – This option will submit the SQL statement of each report to the database once per report then deliver the data in the specified format to each recipient.  This method uses the database logon credentials of the publisher.One database fetch for each batch of recipients – This is the default option when scheduling Crystal Reports. Batches can run concurrently on different servers to reduce the load on the system (keeping the DBAs happy). The size of the batches depends on the specified personalization. This method uses the database logon credentials of the publisher.One database fetch per recipient – This method uses the data source logon credentials of each recipient as the query is submitted to the database once per report for each recipient in the publication. This option provides the greatest level of security but also produces the greatest load on the system if the recipient list is large.

Publications

In addition to Report Bursting, Publications provide an extensive set of options. Among the options that you’ll want to pay special attention to are the: Print Settings, Delivery Rules, Database Logon Credentials, Recurrence, and Events. Settings such as: Personalization, Formats, and Destinations should also be configured completely before saving and implementing a Publication.

Be sure to view the Summary option and review your selections before finalizing your Publication. You should also test your Publication before making it live. Refer to official SAP documentation for a more in-depth discussion of Publications and information regarding the various other options to configure, save, schedule, and view publication results.

Summary

After finally experiencing SAP Crystal Reports Server 2008, I am surprised at the great deal of sophisticated methods of delivering reports to users across the enterprise. Whether through the convenience of the portal , the use of automated report scheduling, or the use of personalized Publications for Report Bursting, SAP Crystal Reports Server 2008 is an excellent product for sharing information with users.

Questions? Please contact me.
Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!