Search results for query: *

I have this same problem, did you get any answers yet????

Thanks for the input. I did something similar to what you suggested but without creating another group. I created a formula that did a distinct count on doc# by order # and put it in the group footer 1. I then did a section format on group footer 1 and group footer 2 and suppressed if the...

Perhaps I wasn't clear enough. Here is a sample of my data: Order# Carrier Doc# Ship Date 00000009SA CB Fed Ex Ground 1203803 12/10/2002 00000010SA CB Fed Ex Ground 1204079 12/10/2002 00000011SA CB Fed Ex Ground 1205206 12/10/2002 00000012SA CB Fed Ex Ground 1205434 12/09/2002...

I only want to show duplicate group footers (order number) -I don't want to see any other group footer if there is only one for an order number. Using Previous() in the section visibility area does not work on a group field name. Anyone have a suggestion?

I have a similar problem......but my formula doesn't show up for me to select it. Does anyone know why?????

I have an Informix stored procedure that needs 4 parameters: whse (3), cust (6), begin date & end date. I suspect the dates are giving me problems. When using the .Parameter with ADO how should I be defining the date? I have the #'s around them but do I need something else? Nowhere can I find...

Has anyone come across a problem with accessing a database in Enterprise Manager when Norton Personal Firewall is active? I can't view the database or access it via my VB application when Norton is active. When I disable Norton I am able to get in. I've looked at all my settings (I have the...

BINGO! I think the initialization in the main report worked. I'm now getting blanks and it's not picking up the previous value. Thanks to Ngolem & rogar & chelseatech for all your help. I learned a lot from this forum and I will come back again for answers, thanks again! debunky

Yes it works just fine when there is a product code match. My subreport is in the Group Footer #1A - Product Code section and I have the @MainSubQty formula that has the passed variable in the Group Footer #1B - Product Code section with all the other fields. I was told I needed to have the...

Still doesn't work. Is there anyway I can check the subreport value in the main report without passing any values back and forth? Like I said before, when I show both the values for the @MainSubQty (which is coming from the subreport @StoredQty) and the subreport value itself, the subreport...

It does not work. I have to have the {wascon.qty} = {?Pm-wamprd.prod_code} in the record selection formula in the subreport because if I don't I don't get any of my data for the main report. When I show both the subreport value and the @MainSubQty value side by side on the main, this is what I...

I get an error on the @StoredQty formula. It's looking for a 'then' between isnull and {wascon.qty}.

Thanks! I'll give it a try right now and let you know.

I have a subreport that is linked to my main report via a product code. I am doing the SUM of a quantity field in the subreport. I use a shared variable to pass that quantity to my main report in order to do calculations. Everything works fine when there is a match between subreport and main...