Welcome, Guest

Crystal Labels - Field Positioning Question
(1 viewing) (1) Guest

TOPIC: Crystal Labels - Field Positioning Question

Crystal Labels - Field Positioning Question 18 Jun 2006 13:43 #8470

  • RobertWild
  • OFFLINE
  • Platinum Boarder
  • Posts: 371
  • Karma: 0
Thanks - all,

Whilst I understand the logic of Doug's formulas, I don't know where in Crustal to put it, however I have embedded the fields in a text box.

Doug - where do you actually put such a formula? I can see al the 'X2' buttons in the field options, however which ones can hold this formula? I assume not the first one, as that formula options seems to control suppression?

cheers

Rob
Rob Wild
Database & Research Officer
Flinders University
http://www.flinders.edu.au/
My location

I thought what I'd do was I'd pretend I was one of those deaf mutes...

Crystal Labels - Field Positioning Question 19 Jun 2006 03:37 #8477

  • DrewAllen
  • OFFLINE
  • Platinum Boarder
  • Posts: 1379
  • Karma: 1
RobertWild wrote:
Whilst I understand the logic of Doug's formulas, I don't know where in Crustal to put it, however I have embedded the fields in a text box.


In Crystal if you open up Insert > Field Object... you will get the Field Explorer window. Right below Database Fields is Formula Fields. You would need to create a new formula and then you could insert Doug's formula there. Once the formula is created it behaves pretty much like a database field except that there may be some limits on summarizing formula fields.

Drew
J. Drew Allen

Crystal Reports and SQL Server Consultant




It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.

Crystal Labels - Field Positioning Question 19 Jun 2006 05:46 #8484

  • Doug Creek
  • OFFLINE
  • Platinum Boarder
  • Posts: 756
  • Karma: 0
RobertWild wrote:
Doug - where do you actually put such a formula? I can see al the 'X2' buttons in the field options, however which ones can hold this formula? I assume not the first one, as that formula options seems to control suppression?


Doug wrote:

Rob, do you have access to CR 9 or CR XI? I want to build a report to show you how to do this, but since we use office 2003 and I can't find a format 8.5 will read (I'd forgotten how much 8.5 sucks), I need to build it 9 or XI for you...


So I cheated and just built it CR 9. If you can't open it, sorry

Doug
~~~~~~~~~~~~~~~~~~~
Doug Creek
Systems and Reports Administrator
University of Alaska Foundation
This e-mail address is being protected from spambots. You need JavaScript enabled to view it ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it )

Crystal Labels - Field Positioning Question 19 Jun 2006 13:04 #8513

  • RobertWild
  • OFFLINE
  • Platinum Boarder
  • Posts: 371
  • Karma: 0
Unfortunately not - I'm only on the "free" copy of 8.5, and yes, I am finding odd problems with it.

cheers & many thanks

Rob
Rob Wild
Database & Research Officer
Flinders University
http://www.flinders.edu.au/
My location

I thought what I'd do was I'd pretend I was one of those deaf mutes...

Crystal Labels - Field Positioning Question 19 Jun 2006 18:05 #8516

  • RobertWild
  • OFFLINE
  • Platinum Boarder
  • Posts: 371
  • Karma: 0
Still on the same user issue, can anyone advise on how to force CR to perform a sum operation on a text field?

One of the fields in the label is a small numeric value containing the number of copies of a newsletter that will appear on the label. The field that we are using to control this number is the Address Attributes Comments Field, nominally a text field.

When I attempt to force CR to undertake a sum function on the field, it comes back with an error indicating that it cannot 'sum' a non numeric or currency field.

How can I force CR to see this field as a numeric field so it can sum it's values?

many thanks in advance,

Rob
Rob Wild
Database & Research Officer
Flinders University
http://www.flinders.edu.au/
My location

I thought what I'd do was I'd pretend I was one of those deaf mutes...

Crystal Labels - Field Positioning Question 20 Jun 2006 03:52 #8520

  • DrewAllen
  • OFFLINE
  • Platinum Boarder
  • Posts: 1379
  • Karma: 1
RobertWild wrote:
Still on the same user issue, can anyone advise on how to force CR to perform a sum operation on a text field?


You'll have to create a formula to convert the text field to a numeric. The formula is CDbl().

Drew
J. Drew Allen

Crystal Reports and SQL Server Consultant




It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.

Time to create page: 3.01 seconds