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 Wanet Telecoms Ltd 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: *

  • Users: kamv
  • Content: Threads
  • Order by date
  1. kamv

    XML - Element value becomes Element name

    I have a simple XML schema such as: <DDGroup> <Data> <Field_1>x</Field_1> <Field_2>y</Field_2> <Field_3>z</Field_3> </Data> </DDGroup> I have a comma delimited file whose first row contains column names.(The content of the file can change per file but the first row will always...
  2. kamv

    Export to Excel adds commas to number field

    I have a Crystal Report (8.5) which has a numeric field that correctly displays numbers with out commas ex. 4789291. When I try to export the report to Excel using Excel 8.0 (XLS) or Excel 8.0 (XLS) Extended this numeric field appears in Excel with commas ex. 4,789,291. Why is this happening...
  3. kamv

    ODBC Error ORA-00904:invalid column name????

    Hi, I have been creating a report using Crystal 8.5. After creating a parameter for entering a location and a formula to change the text of the location when it displays on the report I got the following error when running: Crystal Reports Database Error: ODBC error...
  4. kamv

    Excel: How Compare Values in 2 Diff. Columns w/Each Other?

    Hi, I have a spreadsheet in Excel 2000. I want to find all the rows that do not have a match between the values in 2 different columns. for example: column A column B 1 900 900 2 698a 698a 3 B432 791 4 89 89...
  5. kamv

    Subreport repeats for every record of main report

    Hi, I have a subreport linked to a main report. The problem I am having is that all the records in the subreport repeat for every 1 record in the main report. How do I fix this? Also, how do I sort the records by name so that all the records in both the main and subreport are sorted together...
  6. kamv

    Linking Subreport with date parameters

    Hi Folks, I am trying to link a subreport to a container report using date parameters from the container report. There are 2 date parameters in the container report: Start Date and End Date. The database field these are connected to, PURCHASE.DATE, is a date/time field. I am only using the date...
  7. kamv

    SQL*Plus Worksheet - How terminate a query???

    Hi I am editing/running a query using SQL*Plus Worksheet. The query returns many many records. I don't really care about how many records it returns I just want to make sure it works. My question is: After executing a query in SQL*Plus Worksheet how do I stop it while its running? How do I...
  8. kamv

    How do I print tables and links

    Hi, This may be very simple but I can't figure it out. I have several tables linked in in a Crystal Report (version 8.5). I would like to print out the tables and thier links. Does Crystal have a way to do this? Any suggestions? Thanks!
  9. kamv

    How Do I Print Tables and Links

    Hi, This may be very simple but I can't figure it out. I have several tables linked in in a Crystal Report (version 8.5). I would like to print out the tables and thier links. Does Crystal have a way to do this? Any suggestions? Thanks!
  10. kamv

    convert text of parameter to appear on report

    Hi, I am writing a report using Crystal Reports version 8.5. I have created a parameter called {?Location}which will prompt a user to select a location from a drop down list. I want the parameter to appear on the page header but not as what the user selected but rather to what I define. For...

Part and Inventory Search

Back
Top