Solved

Retrieve the number of pages of a group with Crystal Report and VB(S)

Posted on 2009-07-14
2
476 Views
Last Modified: 2013-12-25
The Crystal Reports consists of a group with approximatively 500 elements.
For each of these elements I want to get the number of pages.
(Each element stands for a client for which a couple of pages have to be printed separately)

Sub main
Dim Application
Dim Report
Dim objPageGen
Dim varGroupPath
 
' Export nach CSV mit VB-Script:
 
Set Application = CreateObject("CrystalRuntime.Application.9")
Set Report = Application.OpenReport("C:\CH\Test\Neu\Test1.rpt",1)
	
	varGroupPath = Array(0,1)
	
	' this should retrieve the numbers of pages of this specific group, but 
	'which it does not
	Set objPageGen = Report.PageEngine.CreatePageGenerator(varGroupPath)
    MsgBox objPageGen.Pages.Count
      
       
       
End sub

Open in new window

0
Comment
Question by:Solu
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 50 total points
ID: 24856286
As far as I know there is no way to determine that value.

You could run the report for each client individually and get the number of pages.

mlmcc
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Spell Check in VB6 13 112
Crystal report highlighting 5 38
Crystal image Object type? 7 33
Need help with a Crystal Report in my C#.Net application 2 15
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question