Recent content by mgallot

Trying to download a file from ftp site but receiving errors. "You cannot call a method on a null-valued expression" Is anybody achieving this? # create the FtpWebRequest $ftp=[system.net.ftpwebrequest]::Create('ftp://ftp.site/files/export/') $ftp = [System.Net.FtpWebRequest]$ftp...

The group header still doesnt suppress when I add this to the section expert. @Balance Due Group 6 = 0

So in this report the user is given a choice of 10 different fields to group on for groups 1-6. Then thare are a few hidden groups. In order to use the sum formula and check it in the Group Header, there needs to be a group created for all of the choices, and then a total for each group needs...

This report calculates the Balance Due for each bill and here is the formula thats in the detail section. @Balance Due whileprintingrecords; Sum ({@Billed Amount}, {ClientAssignmentBilling.Bill Number}) + Sum ({@CashReceiptsAmt}, {ClientAssignmentBilling.Bill Number}) + Sum ({@Write Off...

I tried that but it always suppresses.

Using Crystal 2008 to report on Balance Due. There are 6 groups, and there is a Balance Due calculated in the Detail section as well as in each group footer. If the Balance Due for the group footer is 0, then I would like to suppress the Group Header. Is there a good way to do this...

Its works perfectly now after I removed the group. Thank you!!

I am suppressing the group header (reset formula location) and the details (accum formula location) sections. The group footer is displayed with the Display formula, but just one Client Name shows on each line.

You are right about how I want it displayed. I went back to the comma. I just need to get rid of the blank lines.

Both the Accum and the Display span the width of the page. I changed the comman to chr(13) but nothing changed. The Accum data in the detail section looks like this: Adelphi University (blank line) (blank line) (blank line) Bucknell University (blank line) Carroll University (blank...

Oh boy, its working now. I dont know what I changed. But the list is going vertical with one name on each line. So there is an issue in the Display field.

Using CR XI2 going to a universe. The main report has a parameter display page in the report header. The parameter is Client Name and can be a wildcard search by name or client number. The user wants the actual Client Names that the search found to be display in the report header. Join...

Okay I set up the command. But how should the parameter be set up? I have Client Name as a dynamic parm using the value of Client Name in the command. But it just brings up a list of names. How do I get that smaller list of names to come up as the next parameter selection?

Using CR XI2 against SQL Server db. The user wants the first parameter to be Client Name (of which there are 1000's) so they want to search using a wildcard, such as %United%. Then they would like to see a list of Client Codes to select from. Can I use a cascading prompt for this? I set up a...

I put this code into a command instead and it works perfectly.