How to set the Summary Report to display transactions in the order of execution

How to set the Summary Report to display transactions in the order of execution

Modify the SQL query in AnalysisSummary.asc

You need to modify the SQL query in the AnalysisSummary.asc file.

1. Close Analysis.
2. Go to <LoadRunner/Performance Center>\bin\dat and open AnalysisSummary.asc in a word editor.
3. Locate the [Line12_Field0] section.

Note: For LoadRunner/ Performance Center 8.1 FP2 Locate the [Line15_Field0] section. For LoadRunner/ Performance Center 9.0 Locate the [Line22_Field0] section.

4. Locate the line for JoinedSelectString.
5. Replace the SQL query with the following:

SELECT [Event_map].[Event Name] AS [Event Name],[Minimum],[Average],[Maximum],StdVal,[Table2].[Value] AS [90 Percent], Round([PassedT].[CountAll],0) AS Pass, Round([FailedT].[CountAll],0) AS Fail, Round([StoppedT].[CountAll],0) AS Stop FROM (((((Event_map LEFT JOIN [Table1] ON [Table1].[Event Name] = [Event_map].[Event Name]) LEFT JOIN (SELECT * FROM [Table0] WHERE [Transaction End Status] = ‘Pass’) AS PassedT ON [Event_map].[Event Name] = [PassedT].[Event Name]) LEFT JOIN (SELECT * FROM [Table0] WHERE [Transaction End Status] = ‘Fail’) AS FailedT ON [Event_map].[Event Name] = [FailedT].[Event Name]) LEFT JOIN (SELECT * FROM [Table0] WHERE [Transaction End Status] = ‘Stop’) AS StoppedT ON [Event_map].[Event
Name] = [StoppedT].[Event Name]) LEFT JOIN [Table2] ON [Event_map].[Event Name] = [Table2].[Event Name]) LEFT JOIN [TempForSummaryRep0] ON [Event_map].[Event Name] = [TempForSummaryRep0].[Event Name] WHERE [Event_map].[Event Type] = ‘Transaction’ and ([Table2].[Percent] = 90 OR [Table2].[Percent] Is Null) GROUP BY [Event_map].[Event Name],[Event_map].[Event ID], [Minimum],[Average],[Maximum],StdVal, Round([PassedT].[CountAll],0), Round([FailedT].[CountAll],0), Round([StoppedT].[CountAll],0),[Table2].[Value] ORDER BY [Event_map].[Event
ID]

6. Open Analysis and open the results.

Note:
1. Make sure that you are not applying a default Analysis template (Tools -> Templates -> Apply/Edit template and clear the "Automatically apply this template to a new session" checkbox).
2. For a saved Analysis session, you need to change the <ResultName>.asc file in the saved Analysis result folder. Follow steps 3 to 5 for the necessary changes.

Advertisements

2 thoughts on “How to set the Summary Report to display transactions in the order of execution

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s