HasData (subreport) Is Negative on Main Report

Joe8915 · Feb 20, 2004

Hasdata (subreport) now is negative on main report HELP!!!!!!

If Rich is reading this one, I hope I can get a feedback. I just now got the subreports to work in my main report (well halfway). My problem is now when I try to add my subreport fields into my main report, I get a negative number. Does it make a difference is one or two fields are Null?

The subreport has three fields:

Name Assign Task Completed
xyz 10 4
abc 10 null

Ok now whats my problem. I have tried various combinations, but when I do that all kinds of errors come up. Now I will say this, in my subreport I do have two seperate fields (Assign Task and Completed) that I have to add on my main report.

Any help would be great

Rich · Feb 20, 2004

Post the code

Joe8915 · Feb 20, 2004

Hey Rich thanks for taking the time to look at this

This is located on my subreport, which gives me the total records for each person. I viewed my subreport and the information is correct.

Subreport
=Sum(qryactiveconstRpt.[Count Of tblProclog])

This is located on main report footer
=([subreport name ].[Report].[HasData])

Now just where do I add the field (in code) to get a total on the main report

Rich · Feb 20, 2004

=Iif([MainReportName]![subreport name ].[Report].[HasData],[MainReportName]![subreport name ].[Report]![ControlName],"NoData")

Joe8915 · Feb 20, 2004

DANG DANG

Rich

Now its not recognizing my main form name

Rich · Feb 20, 2004

Form?

Joe8915 · Feb 20, 2004

Rich said:
Form?

Main Report

Joe8915 · Feb 21, 2004

Joe8915 said:
Main Report

Rich is there anyway can you send me a sample on how you did this? For some reason this just has me whipped.

Thanks

Rich · Feb 22, 2004

Post a 97ver zipped here

Joe8915 · Feb 23, 2004

Rich said:
Post a 97ver zipped here

Ok I give up Rich, I just about tried everything possible. I even found one of your replies that had a zip file, didn't even understand how he did.

O well thanks for all the help with this Rich, I owe you a cold one

Thanks again

Rich · Feb 23, 2004

You need to post a 97 version of your db

Joe8915 · Feb 25, 2004

OK Rich

Here it goes. Bottom line all I need to do is add the fields (qty and Count), show as "sum" from all three subreports to the main report. I know you are going to make me look like idiot, but it was worth it.

Again thanks for all the help on this one

Rich · Feb 25, 2004

I've done some of it, you should be able to do the rest from that

Joe8915 · Feb 25, 2004

Rich said:
I've done some of it, you should be able to do the rest from that

Rich, you got to be kidding, no way would I have ever figure that out. But thanks a million

HasData (subreport) Is Negative on Main Report

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Rich

Guest

Joe8915

Registered User.

Similar threads

Users who are viewing this thread