Search results for query: *

Hi, I have a report that I have used for several years which has I had to fix after upgrading to Crystal XI. I create labels for our tab folders with the following: if ({GM_FOLDERS.FIELD1}="1") then color (255,20,147) else if ({GM_FOLDERS.FIELD1}="2") then color (255,193,37) else if...

Hi, We recently purchased SQL Server 2005 and are planning a migration from Oracle. I need to set the front end (forms, reports) for the database. What do I use? If it's Visual Studio, what's the best choice of the different flavors? ie visual basic, c, silverlight.... I already own Crystal...

Hi, I am using Crystal XI and Oracle 9i. I am reporting information from the footer of my document (gf4).This is the only area that will print. But the information I need to display should show in one field the data of the first record within the #3 group. I have the data sorted so that it...

Crystal XI, Oracle 9i Hi, I am trying to replace the hard returns within a text field with a space. I have tried Replace ({@return1},chr(0013) ,"" ) But my data remains unchanged. Do I have the correct character code? Thanks

Hi, I have report under Crystal XI, 11.0.0.2495 connecting to Oracle 9i via odbc. I have a grouping based on a date field within one of my tables:Lease.doc_date. I have found that the group header field (and what shows on the tree) is a completely different date than what the field shows. I...

I am using Oracle 9i and forms 6i. I am trying to display a bfile within a form. I have read on blobs and it looks like I need to use dbms_lob.fileopen....but how? I tried to write the code in a trigger for a button to execute to display the file, but I'm not getting it right. Table...

Hi, I am using crystal reports 11 and oracle 9i. I am getting the error "...group section cannot be printed because its condition field is nonexistent or invalid". I have checked through the section expert and I can't find ANY special formula conditions. The group is based on a formula. I...

A coworker has set up a powerpoint slide with 2 bulleted text areas. One text area was copied to create the other text area. The space between the bullet dots and the start of the text is different between the areas. This is on the same slide. They have the same font, point, formatting...

Hi, All of my forms are currently in forms 6. My current database is oracle 9i. I have available forms 9 to upgrade my forms. I just found out we will be going on to 10g in November (database and forms). Should I go ahead and crank through my forms to 9 or wait until version 10 is available...

Hi, I'm checking on a question for my dba. She's new to Oracle (coming from SQL server). Is there a system field that saves the user that last updated a row of data? We found the sysdate to get the date and time. But what about who did the update/creation of the row? Thanks

I will be printing a report that is 8,000 pages long (to date). This report has two groups in it. Is there a way to send the report at one time but get it to send as separate print jobs for each group break (already set as a page break)? What I want to do is to staple each individual group as...

I have a preprinted form that my crystal report will print on. It is a simple report with one grouping. If the detail section has too many rows, it will overwrite the preprinted footer section on the form. Can I count the no. of detail rows and pagebreak after the count = a certain no.?

I'm trying to export all of the tables from an 8 (8.1) oracle database and their data. I have been using sqlplus 3.3 and spooling the data to txt files. Anyway, Some tables have buffer overrun or inconsistent data types error messages when I "select * from table". Also, one of the...

In CR 9, I just tried to insert a summary field by clicking on a currency field in the detail section and clicking on the insert summary icon. The summary field is being created but is not being located in the report. I can create a variable and define it by double clicking on the summary field...

Hi, I am using crystal 9. I am generating a report with 3 groups 1 - county, 2- lb, 3 - lessee (all numeric values). I would like to be able to limit the report in the following way. If the lessee exists within the data, don't print any of the groups. Example, lessee 1 could exist in county...

I have CR ver. 9 report that is set to portrait mode. I would like to print the subreport (in its own section) in landscape and the rest of the report in portait. Is there a function or formula that would do this?