Search results for query: *

what happens when u print out the sql string? what's the command that it comes out with?

thanks lb it worked great. one last question. is there anyway to remove a field if there's nothing in it??? -KS

so far the last part with the supression formula want a string from the pic above? any idea on what I should do?

i think the last part with the supression formula should work after we got all the distid's from the subreport. Man.. I really want to get this done. lol thanks guys for all your patience.

inputing the SQL always gives me the error that's

I did everything you said LB accept when i tried to suppress it in the last step i get this error.

here's what i get when i click on fields in the SQL Expressions Editor.

but wouldn't that filter out everything under 2004?

I hope this helps with the kind of group selection I'm trying to do.

lbass seriously thanks for your patience. I'm terribly new at this that's why I'm so lost. My firm pretty much wants a report that has a range of orders from 2002-2004. In that report would be a list of people and their orders. Next the want any customer who ordered in 2004 not to appear in...

but would that eliminate the distid throughout the whole report? that's the my goal I was wondering if all those distid's could be stored somewhere and if in the report we can supress all those ids;

also to read what's in the script name you can use Request. ServerVariables (SCRIPT_NAME) to get it from your page and write it out as DeleteAccount(ID,FIRST,LAST,<%=Request. ServerVariables (SCRIPT_NAME)%>)

i wouldnt see why not try it and if you want use a URLEncode function so the url isn't as noticable when passing it thru.

can you put up the code for more help pls.

this may not be a problem with the asp code what so ever but a problem with the db connectivity. try creating a UDL file and speciying it to look for the datasource. you can then test the source to see if it functins correctly or if there needs any adjustments. you can create a udl file with...

I think better explaination of this may be needed. if you want you can do a replace function like this Replace("href="/ ","href="http://www.company.com/ ")

I was wondering would there be a way where we can suppress the distributor ID everwhere. like say if the distributor id has a entry date in 2004 then can we supress all those distID??

im sorry not page in line 2 pageName

sure.. um i would use the following code on that page pageName = Request.ServerVariables("SCRIPT_NAME") if page <> "index.asp" then response.redirect "index.asp" end if

i would get the url and then do a response.redirect if the string is not "index.asp"