Search results for query: *

Hi All, I'm on CRV10, my datasourse is XML. Is it possible or is there some work-around that would allow for a table(similar to an excel spreadsheet) to be dynamically created depending on nature of the data. For instance if i get a data set of 3 fields - varying lengths for each field - and...

Hi All,--running cr10 Is it possible from within crystal designer to create filters on fields used in the report. For example given the following fields. Name, City, State, Zip, Area_Code Can filters be created that would prompt the user to choose a Name, City, State, Zip, Area_Code to...

Hello All, I'm running Crystal v10 against a Ms SQL 2000 db. I have a one to many relationship between two tables (Person, Company).A person can belong to many companies. I need to create a report that displays something like the following. It would be grouped by person.id person.id...

Hello all, My datasourse is an XML Http URL, i'm running v10. I have 4 subreports in the details section of one main report. DETAILS A - SUBREPORT1 DETAILS B - SUBREPORT2 DETAILS C - SUBREPORT3 DETAILS D - SUBREPORT4 The main report takes two parameter values, ID1 and ID2. To prevent having...

I have multiple subreport in main report. Sub1 exists in Details A, Sub2 in Details B, Sub3 in Details C etc. When I preview the report there is whitespace after each subreport, -similar to a page break after each subreport. I'd like for each report print directly after previous subreport...

I'm trying to creata a new connection to a XML datasource located on my C drive. But I get the follwing error:? Invalid Argument provided. Details: Java Server startup failure. Please verify the PATH, CLASSPATH and IORFileLocation properties in the INI File. Help? Pat

I'm trying to creata a new connection to a XML datasource located on my C drive. But I get the follwing error:? Invalid Argument provided. Details: Java Server startup failure. Please verify the PATH, CLASSPATH and IORFileLocation properties in the INI File. Help? Pat

Hello All, I'm encountering a problem when trying to edit the SQL Statement via: DATABASE - SHOW SQL QUERY.... I'm not able to make any changes to the SQL statement behind my report? Thanks for your help in advance? Pat

Hello All I have a graph grouped by Name displaying the average score per Name for q1, q2, q3. I need to display on the page the individuals higest avg score and lowest avg score? THanks for any help. Pat Name q1 q2 q3 ---- -- -- -- Bob 1 4 3 Bob 5 3 4 Jed 3...

I have a birth date field, that I need displayed with that actual date, and the present day that the birthdate falls on. How do i accomplish this. Thanks Pat

I'd like to import data (weekly) into some sybase data from a csv file(it be generated by from a SQL Server database). What are my options? Thanks Pat

Hello All, I have data in a SQL Server Database that I need migrated to a SYBASE database on a weekly schedule. What would be the best way to go about doing this? or what are my possible options? Thanks Pat

Hello all I have a SQL table in my database that records salary changes of employees historically . So a particular person may have had a salary change any number of times within a given time period. What I’d like to do is write a query retrieve the last three pay changes for a particular...

Hello all, I'm looking for a sql server function that works similar to the TRANSLATE function in ORACLE. I have social secturity field currently in format ###-##-####, that i'd like to change to ######### (without the dashes). The TRANSLATE function would work as follows...

Hello all, I'm trying to find out what kind of connection I have with a database i'm reporting on. But the next to the database icon in the database expert im getting what I think is an IP address and the connectivity type (i.e. 123.456.7.89(OLE DB(ADO)). What does this mean and how does it...

Hello All I'm looking for sample code that will help me with capitalizing the first letter of every word in a string -similar to the built in Leadingcaps(x) function - but to include exceptions. For example using leadingcaps a string that may originally read GOLDBERG AND GOLDBERG now reads...

I'm trying to implement the Replicatestring function in my formula, but have not been successful. I'd like to make the data that is returned to look like they are in column format and return to the next line after the third "column". The built in column formatting option available...

Hello I'm trying to implement the Replicatestring function into my formula to create a fixed length string, but have not been successful. I'd like to make the data that is returned to look like they are in column format using Replicatestring and return to the next line after the third...

Hello Im trying to print a variable in a form letter in columnar format. The letter and the embedded variable exists in the detail section of a report. This is what I was using: WhileprintingRecords; StringVar Item := {PPO_GROUP.DESCRIPTION} StringVar Chain; NumberVar ChCnt; if ChCnt = 1 then...

I created a form letter in the detail section of a report. Inside the body of the letter I have a concatanated string variable that accumulates data for each letter. The variable is reset in the group header. In the body of the letter I would like to display the variable in columns using the...