Recent content by gooseriver

I am trying to convert this to an update statement in which I want to update tb2.effdt = tb1.startdt where tb2.type = 'zenster' and tb2.effdt< tb1.startdt select distinct * from Table1 tb1, Table2 tb2 where tb1.id=tb2.id and tb2.type='zenster' and tb2.effdt< tb1.startdt; I have tried...

This did the trick - thank you.

How can I flag (true or false) if there are two @ symbols in a cell

bborissov Do I need to add brackets???

I have two date parameters DT1 and DT2. If I enter two dates - return data from within those two dates. If no values are entered in the parameters, return everything. Not sure how to incorporate both.

I have a pdf file on my web server. I want to be able to have the user download the pdf file from an asp page - a link. For security purposes would it be possible to hide the actual path of the file on the web server, etc... C:\temp\test.pdf.. On the asp page have Download File Here.. When you...

lbass, i inserted the section and added the condition to New Page Before and New Page After as you suggested-for some odd reason this did not work. I took that condition and placed in New Page After and New Page Before in the GrpHeader1d and it seems to be working..

Actually it is 2 instead of 3 - typo the new page parameter is for a label surpress condition

lbass, I modified my report using the remainder(pagenumber,2) <> 0 but it does not seem to be inserting a blank page when the lastmiddlefirstname starts on an even number page. I used your suggestion on using names I added Middle name to it.. Here is my structure: Page Header GroupHeader1a -...

Thanks lbass, only issue is I need to suppress the Page Footer on the blank page.

Yes but how to do this on an even page number?

I am using Crystal Reports 10 Report Structure: GrpHeader1a - d (ClientLastName) GrpHeader2 - Registration Number In GrpFooter1d - I have New Page After This put a new client on each page. However if the client starts on a even page number I want to insert a blank page so that the client...

I keep getting this err on our server logs. Can anyone help me out here: Rule Details:- Log File Type - application Event Type - Error Event Id- 35301 Source - ANY Category - ANY User - ANY Check for the String in Description - ANY The Following Events Matched with the Rule Source : Event...

I am checking the status of a scheduled report. I need to use a loop in which I check the status of the scheduled job when the "status" is = 1 then exit the loop... I tried this and it did not work it stays in the loop.. Dim infoObjects Set infoObjects = IStore.Query("Select Top 1* From...

Ce 10 I am using the ASP COM SDK to schedule reports using the smtpoptions. The requirements are to send the report VIA email - this is successful. The other requirement is to send only the link and not the report. I am able to send the link but the attachment of the report is included in the...