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!

Register Log in
  • Congratulations Chriss Miller 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. psamedy

    Dynamic Number of Columns, Rows, Width

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

    Filtering Reports

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

    Subreport or Array

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

    Problem linking subreport to main report pm values

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

    Prevent Subreport from breaking to next page

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

    Prevent Subreport from breaking to next page

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

    Connection to XML document

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

    XML Data Connection?

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

    Show SQL Query

    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)?
  10. psamedy

    Show SQL Query

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

    Maximum and Minimum

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

    Birthdate - Actual day this year

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

    Migrate data to Sybase

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

    Migrate data to Sybase

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

    Data Migration SQL to Sybase

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

    SQL Query -History Table

    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?
  17. psamedy

    SQL Query -History Table

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

    Oracle Translate Function in SQL Server

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

    OLE DB(ADO)

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

    Capitalization Formula

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

Part and Inventory Search

Back
Top