Recent content by knitwit

I am using Crystal 2008, not XI, sorry.

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

I downloaded Visual Studio 2008 as a trial version. I rapidly found that I needed to decide on .net, C#.... So, you think that asp.net is the way to go? The one good thing about a lack of experience on this product is that I can go with what is the best and there are no legacy products to...

My knowledge is old school (goes back to basic, cobol, fortran...) So, you might as well say I don't have experience. I am comfortable with sql plus (Oracle's flavor of sql). I do want a web based front end. Users in other offices will be using a vpn. It will be an internal application...

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

That worked! Thanks

I confirmed the carriage return by checking the data in the Oracle form. The form is set much wider than the data in it. When I "delete" once at the end of the first line of data in the form, line 2 appends to line 1 and then wraps when it reaches the end of the width of the form. I also...

That didn't make a difference.

Create a section below the detail section. You should now have a section detail a and detail b. Create as many of these extra sections as you have for the fields that you may want to suppress. What I'm suggesting is that you locate each field in a different detail section. Then you can...

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

Check to see if any field is located with an edge extending beyond the page size for your report. I found that this would generate a blank page.

I found a work around - I created a formula of Date (Year ({LEASE.DOC_DATE}),Month ({LEASE.DOC_DATE}) ,Day ({LEASE.DOC_DATE}) ) and this fixed my dates listed in the tree and header. Why did I have to do this? Oracle keeps the date as a date/time field. Would that be the issue? Thanks in...

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