473,573 Members | 2,789 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to change start of page number in crystal report

284 Contributor
I am using vb6 and crystal report 10 for making reports.

Now i am making a report , the report works fine just i want that the page number of the report start from the number which i give him.

For example i have a report with 10 pages , when i click on show report the report pages from 1-10 are displayed with number 1,2.3.....10
Now i want to show it like (suppose i give the starding number 13) so the page number of the same report will now 13,14,15.....22 .
that is instead of starting page number from 1 it start from the page number which i give.

How can i achieve this.

any help.

Nov 29 '08 #1
3 8280
2,364 Recognized Expert Top Contributor
Heiya muddasirmunir!

Can you do it through the report design?

Data report allows one to do that seamlessly in VB6.

Care to give that a whilr!

Dec 3 '08 #2
284 Contributor
No, i want to do it in crystal report not datareport.

i Got it about 80% to my requirement
can somebody modify this code to 100% of my requirement

what i did is make a formula field in the crystal report and to the following coding

NumberVar startNum := 5;
"Page " + ToText((PageNum ber + startNum), 0)
its work fine,By using the above mention formula my page number start with 6 not 1.

But still i have one problem, what i want the user to give at runtime the page number to start with , for this i had tried this code but fails and got error

NumberVar startNum := frmsales.pgnotx t.text;
"Page " + ToText((PageNum ber + startNum), 0)
where frmsales is the form to which user click to show the report and pgnotxt is the textbox in frmsales form.

can some body correct this code so we can give value at run time.

Dec 3 '08 #3
1 New Member
pls send me the vb6.0 code for the above for both in data report and crystal
Apr 11 '17 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Chibyboy | last post by:
Hi fellow developers, I have a crystal report with a subreport whose (N of M) special field only shows the page number at the last page of the subreport. The page number is on the subreport and it's supposed to show on every page. I have placed this special field in a group section that's set to "Repeat Group Header on each Page". I tried...
by: Martin | last post by:
I require to add a cover page at run time to the start of my crystal data report. I can do this by adding an OLE object. My problem is that is only adds in the first page of the OLE (windows document) can anyone help me add in the entire multi page OLE object at the start. Regards, Martin, UK
by: puunda | last post by:
Hi All, I had previously asked this question with regard to Cyrstal Reports, which I believe is not the most suitable for doing the job. The problem: I need to create a report with X number of items (statistics), and Y number of graphs/charts. The report will be viewed on screen, printed, or saved as pdf. The report is created as you...
by: Vince Mele | last post by:
We are having a small problem with a couple of reports we developed for a client website. On two of the reports, sometimes (most of the time) we receive a warning message before the output of the report is presented in the browser. The warning message says "This page contains both secure and non-secure items. Do you want to display the...
by: Henry | last post by:
I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that utilizes Crystal Reports. I want to be able to dynamically set the report data source at run time. I'm trying to change the the reports "integrated security" from TRUE to FALSE via the "Set Location" dialog in the report designer with no success. It is not intuitive (at...
by: Big George | last post by:
Hello Gurus, I'm developing with VS2003, ASP.NET with Crystal Report for VS.NET, and I need to change the paper orientation of a Crystal Report to Horizontal... How to do that? I tried to follow the instructions in: ...
by: ngpost1 | last post by:
I have a Crystal Reports.Net report being generated from my C# application. I would like to change the background color of the details section (not the text mind you) of the report on certain conditions. For example if the value of the 'Meeting Number' is greater than 100 the background color of the details section will be light yellow,...
by: Hellotalktome13 | last post by:
Using a simple ASP.net page with a crystal report on it. Loading from IIS using Integrated Secruity in the reports connection string it populates the report in the browser. What User ID and password is Crystal Report using to get permission to access the database? I created a simple ASP.net page with a data grid using integrated...
by: remya1000 | last post by:
I'm using VB.NET 2003 windows application. i'm trying to display Crystal Reports using CrystalReportViewer. Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load CrystalReportViewer1.ReportSource =...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.