
Reports that are based on SAP queries and InfoSets behave similarly to reports that are based on
stored procedures in mainstream databases. You can insert subreports that are based on different
queries or InfoSets into the main report.
Note:
• If you want to join two or more InfoSets or SAP queries, you should consider creating a brand new
InfoSet or SAP query instead. The new join will be processed on the SAP server allowing the report
to respond faster.
• Your SAP queries and InfoSets may contain parameters that you can use to limit the data that is
returned from the SAP system. For example, you might specify a date range to get data for only a
certain period. If parameters are included in the SAP query or InfoSet, Crystal Reports prompts you
to specify the values that you want to include in the query.
Tip:
You can use transaction SQ02 to create an InfoSet in SAP, and transaction SQ01 to create an SAP
query. For more information about designing SAP queries and InfoSets, refer to your SAP documentation.
Accessing an InfoSet or SAP query
User groups are groups that are managed in SAP. They allow you to control user access to InfoSets
and SAP queries
An SAP query can belong only to a single user group (which must be shared with the InfoSet that the
SAP query is based on). In contrast, InfoSets can belong to multiple user groups. For a user to report
off an InfoSet (or SAP query based on an InfoSet), the user and the InfoSet/SAP query must belong to
a common user group.
Tip:
To associate existing InfoSets and users with additional user groups in SAP, use transaction SQ03.
Selecting an InfoSet or SAP query in Crystal Reports
1.
Start Crystal Reports.
2.
Connect to SAP as instructed in Using the Log On Server command. Select the SAP InfoSet driver,
and provide your user credentials.
The "Data Explorer" dialog box appears.
3.
Click Options.
The "Options" dialog box appears with only the Database tab displayed.
2012-03-14593
Integrating Business Applications with Crystal Reports
What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a
Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in
Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen
In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit
Hello, im noob :)