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...
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...
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
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...
Thanks...I figured it out. Well...process of elimination. I recreated two subreports and the report worked. They were simple subreports with only one selection criteria and section filters. I'm not sure what happened. But it works now!
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...
I also use Query Builder for this process. You can save your excel file without column headers as a .slk file. Then open the Oracle table in Query Builder with only the columns you want populated (in the same order as the spreadsheet). Then turn on the data editor, select edit, insert rows...
Thanks,
We looked at the slide. I had already tried the format painter with no luck. We checked the format placeholder and found that the second box (even though it was copied and pasted from the original) was a shape box. We copied and pasted again and now the problem is solved.
Thanks for...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.