Recent content by MrWilly

What version of rptserver are you using? I would recommend using the version delivered with CR8.5 - If you don't have the setup cd handy you can find it here(default install path): C:\Program Files\Seagate Software\Crystal Reports\Samples\En\Code\Web\Active Server Pages\rptserver.asp You...

Thanks for the prompt reply. I apologize for the lack of detail. CR 8.5 The main report is a shell for four subreports - one for each of four specific types of data. The join info I posted earlier was for the tables within the subreport not between main and sub. You are correct, the sub is...

Can anyone explain why a subreport would duplicate itself - in its entirety? Probably a join issue, right? Main report has only one table and no fields are displayed or used. Joins on the subreport look like this: Transactions.CustID -LOJ-> Cust.CustID -Equal-> CustSettings.CustID...

Never mind.... I figured it out. --This will show that you currently have x # of records where [column] length is greater than 16 characters select count(*) from [tablename] where datalength [(column)] > 16

Can anyone point me in the right direction here... I'm looking to write a query to return a list of values that meet a certain condition... I thought it would be pretty simple...I'm stuck. The query should only return those values which are over a certain length (say 16 characters)...

Is anyone familiar with how to add an appontment to a shared mailbox on MS Exchange? I have the code in place that adds the appointment to the user's calendar in the default profile, but I would like to change this to add it to a group/shared Calendar. Any pointers??? I've included...

if you have Crystal Developer installed on the machine running the Access database, viewing reports with the ActiveX viewer is rather simple... If you are planning on coding in VB: go here: http://support.crystaldecisions.com/library/kbase/articles/c2009907.asp If you just want to use the...

Check out thread768-318300

Do you still need assistance? The file you are looking for is called ActiveXViewer.cab. Open it with WinZip and find the file called "crviewer.inf", right click and select install. That should do it... HTH

If you haven't solved this yet, perhaps this will help: First, be sure you have a virtual directory in your website (in IIS) called "Viewer". The home Directory of this should be similiar to C:\Program Files\Seagate\Viewers... You want to make sure the Permissions for the Viewers...

Did you run a "Verify Database"? This will allow you to fix your report if any changes to the db tables/fields have been made. It will allow you to remap your fields.

Worked like a charm! Thanks Paul! One last thing, can you tell me if this is the correct format for determining previous year totals, eg 2002: =DCount("Standard_Issues","tblIssues","Standard_Issues ='Amendment Questions' And [Date_Time] Between '1/1/2002' &...

Thanks Paul! I've put this into an unbound text box on the report, and it's now returning the total amount of records from tblIssues. Any ideas?

Microsoft has an article regarding this error: http://support.microsoft.com/default.aspx?scid=kb;en-us;226526 HTH

Perhaps this link will help: http://www.visualbasicforum.com/t36893.html