Thanks John, however, a condition of the original spec was to deliver the actual report in a format that the user can then fax/email/print/save - all in one click. I have that working but just not as reliable as I need it to be.
long story short - I hired a consultant to recreate a report and deliver it to the browser as a PDF. He created an ASP page that calls a javascript page that calls another ASP page that uses a CR 8.0 .dll to convert the report from an .rpt to a .pdf. (I believe he mentioned the .dll being a...
I'm not a SQL expert but can offer this: one of my DBA's had a fit when one of my consultants coded a SELECT DISTINCT in his ASP. DISTINCT locks the database from other users (and DBAs). Instead, use GROUP BY and you should see the desired results.
Select * from table
where blah blah blah...
I've run into similar problems. It's the way you concatenate the string. Try this...
response.write "<a href='" & file & "'?userid='" & userid & "'&tempid='" & tempid & "'>Click here</a>"
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.