Search results for query: *

Hi Jon, Thanks for the response. You are right semantically your example is better. However I am basically trying to deal with a comma delimited file whose contents will vary quite often. The file, though, will always have the first line as the colunmn names. So I want those values to become the...

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

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

Never mind folks. Problem solved (I had the wrong link between 2 of the tables) Thanks anyways! Kamv

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

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

The group is by name.

You are correct I don't want a result for every record in the database, I want the subreport after a group in the main report. Thanks again. Kamv

The formula is: Date({PURCHASE.DATE}) It is created in the subreport. I have 2 parameters in the main report - Start Date and End Date. I want to link the subreport to the main using those two parameters so what ever data the main reports gets for that date range the subreport gets its data from...

I have tried placing the subreport in both the detail section and a group section and have gotten the same result - all the records in the subreport repeat for every 1 record in the main report. The link is set up based on a formula (See my earlier posting: Linking Subreport with Date parameters...

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

Should this formula be created in the container report or subreport? Thanks

If I convert the date parameter to a date/time parameter it changes the the parameter for the user (they will have to select a date and time, instead of just date). Is there another way to do this. I am still pretty new to Crystal. Thanks for the help.

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

Thanks for the response. I tried closing the SQL*Plus Worksheet the problem with that was I think that the query continues to run (I could not log back in for a good 10 min.) There is no Ctrl key or function key command to stop the query? Kamv

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

Thanks for the response. The problem I am having is that some of the tables are very long so there are vertical and horizontal scroll bars. I don't think a screen dump will capture the whole &quot;picture&quot;. I also tried using Snagit but cannot seem to capture the all the 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!

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!

I am not sure if this is what you are looking for... but this is what I have done in the past (based on Microsoft help feature in Access): Automatically delete duplicate records from a table In this procedure, you create a copy of the structure of the table that contains duplicates, make...