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

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

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

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

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

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

I inherited a manual crosstab report in which there are 7 column headings being displayed from left to right and this resides in the main report. Each column heading is displaying shared variables from 3 different subreports, so column 2 is also column 9 as well as column 16. After the report...

I created a CR 12 report and it needs to be runnable via URL. It has a parameter also. Do I need to convert this to XML? Or can a crystal viewer make this happen with the report format?

I need to return data from an address field (address1) starting where a number exists. Example: Sunny Hill Gardens 1601 Sunshine Lane - data in field 1601 Sunshine Lane - data that needs to be returned The numbers are always in different positions in the field. Thanks for your help.

I need to return data from an address field (address1) starting where a number exists. Example: Sunny Hill Gardens 1601 Sunshine Lane - data in field 1601 Sunshine Lane - data that needs to be returned The numbers are always in different positions in the field. Thanks for your help.

I am using Visual Studio 2005 to create a report with 2 parameters. The first parm is division, the second is team (must be within division). I have 5 report parms set up, Div, output, delimiter, team, team_output. There are 4 datasets, div just pulls all divs, output parses the list because...

Using CR 11, I have a bar chart that stacks 2 values by month. The first value A=yellow (thru the formula) the second value is B=green. This report has 12 subreports with these kind of charts. I have grouped and sorted the records to sort by A first then B so that yelllow is always on top. I...

Here is the query I am trying to run with a command in Crystal: SELECT `sheet1`.`Time`, Count(`sheet1`.`ID`) As CountOfConcurrent FROM `sheet1` `sheet1`, `Concurrent For Crystal` `Concurrent_For_Crystal` WHERE `sheet1`.`ID`>=`Concurrent For Crystal`.`AT` and `sheet1`.`ID`<=`Concurrent For...

Hello, I have a hexadecimal value which I converted to decimal with the following formula: StringVar HexValue:= {SP_CALL_RECORD.CONN_ID}; NumberVar DecValue:=0; NumberVar Factor:=1; NumberVar j:=0; NumberVar x; for j := len(HexValue) to 1 step -1 do ( if...

We have Remedy AR system Ver 6 using an Oracle database. I have been tasked to extract the Inventory items by User. I can see the user table, and I can see the inventory items, but I cant find a linking field amongst the many many tables Remedy creates. Has anyone done this before? What...

I am trying to convert to hhmmss from a duration field that contains seconds. I'm using CR 9.0 and SQL Server. I keep getting a message that the 'remaining text does not appear part of the formula'. What am I missing? whileprintingrecords; numberVar dur := {GCDR.Duration} numberVar hrs...

I'm looking for a solution to display a SQL Server Decimal 20 field. The number is correct in SQL Server but rounds when I try to display it in Crystal. Crystal ver is 9.2, SQL Server is 2000. At this point I've tried too many possible workarounds to list, and none have been the solution...

I have an SQL server database that contains a table with a field called Connection Id. The field is defined as decimal with 20 places. When I pull this number into a Crystal 9.2 report and browse the data, the last 2 numbers in the field are always zeros. This is the unique identifier so I...