Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mgallot

    Trying to download file from ftp site

    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...
  2. mgallot

    Suppress Group Header if Group Footer Balance is zero

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

    Suppress Group Header if Group Footer Balance is zero

    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...
  4. mgallot

    Suppress Group Header if Group Footer Balance is zero

    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...
  5. mgallot

    Suppress Group Header if Group Footer Balance is zero

    I tried that but it always suppresses.
  6. mgallot

    Suppress Group Header if Group Footer Balance is zero

    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...
  7. mgallot

    Trying to Display Unique Client Names

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

    Trying to Display Unique Client Names

    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.
  9. mgallot

    Trying to Display Unique Client Names

    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.
  10. mgallot

    Trying to Display Unique Client Names

    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...
  11. mgallot

    Trying to Display Unique Client Names

    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.
  12. mgallot

    Trying to Display Unique Client Names

    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...
  13. mgallot

    Cascading Prompt with Wildcard Search

    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?
  14. mgallot

    Cascading Prompt with Wildcard Search

    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...
  15. mgallot

    SQL Expression

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

    SQL Expression

    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...
  17. mgallot

    Truncate after full word

    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...
  18. mgallot

    Making Crosstab extend to More than 1 page

    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...
  19. mgallot

    Making Crosstab extend to More than 1 page

    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...
  20. mgallot

    Load Column Names based on Array

    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...

Part and Inventory Search

Back
Top