What you're asking is not directly related to MSDE, rather it has to do with trusted connection or id/password connection. You may be able to gain trusted connection by simply setting password and id to "" (empty string). Otherwise make the password and ID empty and add...
You're simply using incorrect syntax for CR aliasing. Don't use the keyword "AS" at all. I'm only showing a portion of one line here, but instead of "INNER JOIN "IGSVIEW".ORGANIZATION ORGANIZATION AS ORGANIZATION_1"
use this instead
INNER JOIN...
Fairly straight foreward using shared variables. Create these 4 variables:
1) In your main report section header (Where you have Section 1) declare/initialize
WhilePrintingRecords
shared numbervar QtyOH := 0
2) In your 1st sub report footer (wherever the total quantity is known)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.