Search results for query: *

For those that may be interested I did find another solution, although not the most favourable, to this issue. I can set up my 1st parameter in the SQL command which asks the user for a date. The date is used for two things in the SQL command; in a formula to calculate a loan balance up to that...

Thanks for the detailed response LB. I was hoping that this wouldn't be the only way around the issue though. If I had to have both parameters running against the SQL command can I create one of them as a dynamic parameter? I did try another solution where I put both parameters in the main...

No there's no subreport involved.

I am using Crystal Reports XI and MS SQL 2000. I have a parameter in a SQL command for my report called "Report Date" which both filters records returned to the report as well as assists with calculations of a loan balance at that date using a sub-query. If I run the report with just this...

We can't use the carriage return or line feed as a row delimiter as fields within the table contain these special characters. This makes the import process think that it has found the end of a row when really it has just found these special characters within a field. This makes for unpredictable...

We have an unusual problem in that we have had to use special delimiters for fields and rows to export data into text files. This is because some of the data in the fields contain commas, quotes and carriage returns. We have used the tilde (~) to separate fields and the vertical bar/pipe (|)...

I am not sure of the fix but I am suffering the same effects from a DTS package. The send mail task substitutes the : and \ characters with underscores as well!

Thanks swampBoogie. Second one worked well.

I am using a Union statement to combine 2 aggregate (sum) select statements but I really want to sum the whole lot where the ParentID is the same number. My statement as it stands is: SELECT Ref_Code AS ParentID, SUM(LMR_CurrentLoanBal) AS CurrentLoanBalance FROM Loan_MasterReference WHERE...

I have a table of loans where 1 loan can be a parent and can have multiple children. The table looks like this: LoanID ParentID LoanBalance 1001 0 200000 1002 1001 300000 1003 1001 250000 1004 0 500000 In this example loan ID 1001 is the parent...

Hey snapicus, We too are looking into this and have found a document that gets us halfway there. Check this out http://www.microsoft.com/technet/prodtechnol/winntas/maintain/featusability/creatuse.mspx. Pay attention to the "Using the %LogonServer% Variable" section. We are using Win2003 in...

I have had the same problem with some of my tapes being classified as "unknown media". Did you find a fix for this problem?

I have had the same issues/symptoms with my Exchange 2000 configuration. For external e-mails the overridding limits on the individual mailboxes are not taken into account. No problems internally though! My work around was to take off the default limits within Exchange and apply message size...

Another way around this issue is to have the attachments zipped by the user trying to send them using a program like WinZip. We have a similar setup and this is how we get around it.

I am having the same problem with our SBS 2000 version of Exchange. Have a look at the post "NDR 5.2.3 on Messages Over 1.5mb" in this forum. Is this the same sort of issue?

I was able to run the script "cscript adsutil.vbs enum_all smtpsvc" and directed the output to a text file. After having a look though the file I have noticed that MaxMessageSize is in the text file twice. The first instance says 2097152 and the second instance says 0. When I look at...

Yes I can send a file larger than 6mb within the network. I tried to run the script from the c:\inetpub\adminscripts folder and received the message "Command not recognized: smtpsvc". Any ideas?

I don't have any message limit restrictions on my SMTP Virtual Server. This is why I am very confused. I have read some of the other messages in the Forum about the SMTP Virtual Server becoming corrupted. Could this be my problem? Should I try reinstalling Exchange 2000 then re-appying my...

It would suprise me that every organisation or person that we are trying to send e-mail to has a limit of 1.5mb. In my testing I have tried to forward a 2mb file to a person that I successfully sent the same file to about 4 weeks ago. I have also tried sending a 2mb file to my personal e-mail...

I receive a NDR 5.2.3 stating "This message is larger than the current system limit or the recipient's mailbox is full. Create a shorter message body or remove attachments and try sending it again." on e-mail that is being sent external to our network. I have been testing this with...