Search results for query: *

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.

Using Crystal XI r2 going to SQL Server DB. Need to pull the maximum rate set for each employee and create totals for them so I am using an sql expression. Each employee has multiple records in the rate table. This expression gives an 'error near Select statement' Select...

Crystal version 11.5 Anyone know of a way to display the values a user selected from the parameter list, but truncate at a full line but only after a full word? Desired display (represents a full line) Regions: Chicago, San Diego, New York, Washington Current display Regions: Chicago, San...

Yes the crosstab is a subreport in a report footer section b, the dummy crosstab is in the same section right below it. The pages do appear vertically because there is a text field in the dummy crosstab that has a hard coded Size in order to show 3 pages to the right. Each page can fit 7 group...

CR XI I have a crosstab that only expands onto more than 1 page if I hard code a large Size and Postion number into the empty crosstab below it. This causes pages to extend off to the right, but will always show them even when groups dont fill the pages. So there are blank pages if not as many...

Using CRXI, I have an array that is initialized in the report header called Valid Columns Array. //init whileprintingrecords; shared numbervar array colHdrValid:=[0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0]; true The array is to check on valid Market Groups...