Search results for query: *

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

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

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?

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

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

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

I want to wrap up a bunch of append from and update statements into a script so that they run all at once. the help for fp does not list begin as a function.

i need to change every record's memo field in a table that i have extracted from a main table. i have figured out the append memo part - APPEND memo bi_text FROM oct_dec.txt OVERWRITE and it does the first record. i cannot figure out how to make it change every record using sql. for loops...

i have excel spreadsheets pulling data from an access db. i need to move the db to another server. i have tried everything to get the queries (about 40 of them) redirected to the new server w/o luck. i have deleted the system odbc driver and the queries will still pull the data. it seems that...

i am trying to get a field to stand out in a report when the data is null. i am using if isnull({TASK.TASK_END_DATE}) then crGreen else crPurple as a test. the field bg does turn purple when there is data but does not turn green when it is null just no color. i have checked the data and it is...

is this a built in function of crystal? i can get the data in an RTF file or in a PDF, but if i want something useful like a csv, chr, or other type of format (word, excel, etc) i get nada for the subreport data?

is there a workaround for crystal rpts 8.5 inability to retieve data from large varchar2 fields in a formula. we have a text description field 2000 characters long and i need to get it into a report. the problem is that i need to use a formula because i only need the data if another field...

i have a report with a subreport that includes totals for each group. i need to get a grand total of all of the totals for each subreport. the summary field cannot be selected in the main report. how do i pass the grand total to the main report?

i am pulling data from a db and need to push into a 2d array a column at a time. will loop through the following up to three time (so $k will be from 0 to 2). the sql statement will pull one set of data at a time out and there can be up to three recordsets in the results. i need to get the data...

i need to print two name/address data sets in one subreport and have them side by side. is there a way to specify where the second set of data starts (i.e., say 50 columns from the left of the field). what happens is that the data does not line up in the second set. it moves according to the...

our oracle db is set so that in order to execute a stored procedure the users password, id and role must be passed (oracle will only allow a vb application to connect if it is running from an exe (executable) file). to do so first must connect then pass the following varSetRole = "BEGIN...

i have an app that can't do some functions when installed on win95 because the third party active x/dlls wont't install on the machine (i know, but i work at a state agency and only just getting around to rolling out win2k on some of the 3k plus machines). i need to disable/make invisible some...