473,382 Members | 1,717 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

crystal report 9.0 help please

RJN

Hi,

I'm new to crystal report and require a help urgently.
My requirement is something like this.
I have a main report from where I call 2 subreports,
say summary and details.

The main report has a group based on a certain column and say this
results in "n" distinct groups. The details of each group I'm getting
from a subreport.
(For eg., If I have 5 distinct customers, I will group by customer name
and get the details for each customer from the subreport by linking with
the customer name)

I need to reset the page numbering after each group. This means each
group should have its own page numebring starting from 1. I need to
display 3 fields on the main report:
one which displays how many total pages were created for all the groups,
second which displays the total number of pages created for that group
and third which displays the current page number for that group.

And also I have to create a summary page at the beginning of the report
which displays each group and the total number of pages created for that
group something like:

Customer1 3 pages created
Customer2 5 pages created
Customer3 8 pages created
...............

I'm generating the summary by way of a subreport by calling from the
main report.

Can anyone tell me how I can set these dynamically. Is there any option
in Crystal report which helps me to do this? Your help is highly
appreciated

Regards

Rjn
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #1
1 1916
Al
Right Click on the Session where you want to reset the number.

for instance Detail <RIGHT CLICK> on top of <DETAIL> and in the format
session you will see the Reset Flag. The Button on the right is for you to
put formula like reset when this is 0 or <> "" etc

Good Luck..!
"RJN" <rj*@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

I'm new to crystal report and require a help urgently.
My requirement is something like this.
I have a main report from where I call 2 subreports,
say summary and details.

The main report has a group based on a certain column and say this
results in "n" distinct groups. The details of each group I'm getting
from a subreport.
(For eg., If I have 5 distinct customers, I will group by customer name
and get the details for each customer from the subreport by linking with
the customer name)

I need to reset the page numbering after each group. This means each
group should have its own page numebring starting from 1. I need to
display 3 fields on the main report:
one which displays how many total pages were created for all the groups,
second which displays the total number of pages created for that group
and third which displays the current page number for that group.

And also I have to create a summary page at the beginning of the report
which displays each group and the total number of pages created for that
group something like:

Customer1 3 pages created
Customer2 5 pages created
Customer3 8 pages created
..............

I'm generating the summary by way of a subreport by calling from the
main report.

Can anyone tell me how I can set these dynamically. Is there any option
in Crystal report which helps me to do this? Your help is highly
appreciated

Regards

Rjn
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Stephan | last post by:
Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal...
2
by: Tim Burda | last post by:
I posted this in another forum, but I'm adding it here to for more exposure.I am using Visual Studio 2003 and trying to get Crystal Reports to produce output. If you have any ideas, please let me...
7
by: Phin | last post by:
I need your HELP! I've seen all the posts on using Crystal Reports within vs.net (vb.net) and changing a SQL query at runtime. When I tried to pass in a dataset into the crystal report at...
3
by: Robert Schuldenfrei | last post by:
Dear NG, I have Crystal Reports working to a file and directly to the printer with the following: private void mnuInvRep1301_Click(object sender, System.EventArgs e) {
5
by: Robert Schuldenfrei | last post by:
Hi Again, Forgive me for posting this again, but old items seem to get little review. I thought I could adjust the viewer properties without any further aid from the NG, but I was wrong. When...
3
by: Deasun | last post by:
I need some help please! Crystal is driving me nuts. Heres my code so far, see below. Problem: On the .export() line it comes back with error #5 Login failed! I know the login info is good so...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
1
by: Sachin | last post by:
Hi, I am working on ASP.Net 2.0 Beta 2 I am having problems creating crystal report using dataset I created a new dataset (DS_ExpCode) and a datatable (DT_ExpCode) under App_Code folder....
2
by: microsoft . public . sqlserver | last post by:
I am a Web developer. I am new to VB 6.0 and Crystal Report. I have joined an organisation where there is an application running(developed in VB6 and crystal report 7). I have to modify one report....
3
by: firozfasilan | last post by:
I am new to visual basic 2008. In the past I have used vb6 to display an existing crystal report. I would like to accomplish the same with vb.net. However I am not clear on the syntax to display a...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.