By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Urgent,Plz help me .......need to calculate the total of a field in subreport.

P: n/a
Thank you in advance for any suggestions...
I'm using crystal reports version 8 & SQL server.
I've created a report that is composed of 2 parts: 1st part contains
the main report which uses database1 (db1) located on server1(S1), 2nd
part contains the subreport which uses database2 (db2) located on
server2 (S2), and I've used (parameter field & a certain fields) to
link the subreport to the main report.

The subreport is composed of 2 columns: the 1st one is from db2 &
S2, the 2nd one is a result of multiplication of the 1st column to a
column field situated in the main report (that I've imported it to the
subreport through a formula field that I've created in the subreport
and I've assigned to it the value of a column situated in the
main report by using the subreport links).

And what I'm trying to do is the total of the 2nd column
situated in the subreport: I've tried many ways such as running total
& the ∑ to calculate it but always the result is false. I've
tried also to put the subreport in the footer of the main report but
because of the subreport links that must exist the data column itself
has became false.
Any suggestions ???
Plz help !!!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Microsoft.public.vb.crystal may be an appropriate group for a Crystal
Reports and SQL Server question, but all the "access" groups to which you
posted this are not -- it would only be by chance that you'd get a useful
answer there.

For other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
"Manal/report designer" <ma***********@hotmail.com> wrote in message
news:21**************************@posting.google.c om...
Thank you in advance for any suggestions...
I'm using crystal reports version 8 & SQL server.
I've created a report that is composed of 2 parts: 1st part contains
the main report which uses database1 (db1) located on server1(S1), 2nd
part contains the subreport which uses database2 (db2) located on
server2 (S2), and I've used (parameter field & a certain fields) to
link the subreport to the main report.

The subreport is composed of 2 columns: the 1st one is from db2 &
S2, the 2nd one is a result of multiplication of the 1st column to a
column field situated in the main report (that I've imported it to the
subreport through a formula field that I've created in the subreport
and I've assigned to it the value of a column situated in the
main report by using the subreport links).

And what I'm trying to do is the total of the 2nd column
situated in the subreport: I've tried many ways such as running total
& the ∑ to calculate it but always the result is false. I've
tried also to put the subreport in the footer of the main report but
because of the subreport links that must exist the data column itself
has became false.
Any suggestions ???
Plz help !!!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.