Search results for query: *

i had similar problems w/oracle 9i timestamp field and cr10. i found a patch (upgrade/sp) that fixed the problem for me.

that worked. i tried something similiar before but i thought that the problem was not the the value might be null but that there was not even a value to test at all null or otherwise.

i have a formula that uses a table and two left outer joined views. if there is no data in either of the two outer joined views i get nothing. this is the formula {RC_BUDGET_ENTRY.AMT} - {RC_BUDGETENTRY_ISSUED_AMT_V.AMT} - {RC_BUDGETENTRY_DRAFT_AMT_V.AMT} both of the views must have data for...

thanks, that will help me out and keep the dba's happy too.

hmmm, i found the sequences tab but it shows only one and it is not associated with any of the tables but an unassociated one that uses a batch job that runs an automatic update at night. it's lastval is 17890, whereas the id in the table i need to use is 250000+. i have a call into the...

thanks for your reply. i checked the sequence generator using TOAD and i get it to be SYS_C003488 but when i try that in the sql statment i get an error stating "ORA-02289: sequence does not exist". that is the name of the index shown by TOAD. apparently it is not the sequence name. how would...

i want to insert a record into a table that has a primary key that is autogenerated. i have used TOAD to generate the insert statement for the record and it includes the key but i want to create a completely new record to replace one that was lost during data migration. i get this from toad for...

thanks for the hint but i was not too clear on what you meant. i kept researching and found a patch on the crystal website that fixed the problem. if others need it go to technicalsupport.businessobjects.com and search for knowledge base article c2018836 and download the patch. it also fixes...

using cr10, oracle 9i client to hit a 9i db. trying to use a timestamp field (don't know why the programmers use it instead of a date but they did). i use other fields that are timestamp w/o a problem. any suggestions?

wow, that was so nice and simple once it was explained. thanks so much. i wonder if maybe you could make sense of my other post, unless that would be greedy. is seems like it should be a cross tab kinda thing but i have not used cross-tabs yet. just read about them. here was the initial post...

db is paradox (yea, i know) and using cr10 - i have a column that contains codes 1, 2, 6A, 6X, etc. in the details section which is within two groups, but a team and individual. no problem getting a total count of the items in the section but i also want to count of each of the occurances of...

imagine it like a spreadsheet. across the top would be site 1, site 2, site 3, etc. down the left side would be the field name for each field. then under the site 1 column would be the data from each field going down the column. hard to represent here but here is a shot field site 1...

trying to hit pdox dbs w/crystal reports i can get it to work on one of my machines but when i try on others i cannot see any tables let alone the data or fields. i am using the intersolv 3.11.0000 driver on all of the machines but not having luck. the machine is works on is getting replaced.

i have a request for a report to list all the data contained in a table w/150 fields. the data is information about a location. it needs to look something like this name bobs dry cleaners addr 123 main st city here state there etc. for all 150 columns. i have tried cross tabs...

the report is only 65 rows this time, not more than 100 before. can't do any service packs as the install is done through a network.

Getting a runtime error message when trying to export a Crystal 10 report to Excel 2003. Error reads: Runtime Error! Program Files\Crystal Decisions\Crystal Reports 10\crw32.exe abnormal program termination This does not happen with all reports. I could run the report without trouble a week...

i have a report in cyrstal 10 that i need to export to excel for other users. when i get the export i get some data on line 1 some on 2, and some on 3, repeated for every line. no subreports in the report but there are formula fields. i find not rhyme or reason to the mangalation of the...

i have at least one user that is unable to change the font size of the printout from IE. we have forms to print and using the view\text size on the tool bar does not work. the font looks good when previewed but when printing it always goes to the largest size. the printers are hp networked...

way cool. thanks to both of you. it worked in an instant. merry christmas and happy holidays from texas (whichever you prefer)

so, geoff if i save this************* update adjust_2 set bi_prev_qt = 0; update adjust_2 set bi_prev_pr = 0; update adjust_2 set bi_add_qt = 0; update adjust_2 set bi_ttl_qt = 0; update adjust_2 set bi_ttl_pr = 0; **************** as myprog.prg and call from the command line do myprog.prg it...