467,122 Members | 1,276 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,122 developers. It's quick & easy.

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

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
  • viewed: 3138
Share:
1 Reply
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.

Similar topics

1 post views Thread by SB | last post: by
1 post views Thread by greesh maheshwari | last post: by
1 post views Thread by pdm@patweb.be | last post: by
1 post views Thread by dan.cawthorne@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.