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

Thanks Vidru, that worked. SV, I will be reporting from an XML document using CR 10 what are my options as it relates to performance.

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

I see and error the where clause that's causing my report to draw incorrect data. So I'd like to directly edit the SQL statement. I've changed SQL Statements using this method in previous versions of CR(CR 7.0)?

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

Sorry for the confusion: What I meant was, I need to migrate SQL server Data into a SYBASE table on a weekly schedule: What is the best way to do this. Thanks

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

Thanks guys this TOP function was exactly what i needed. A question though, what reason is there for this in the subquery. Order By Pay_Start_Date DESC is it necessary?

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