Search results for query: *

I have a field {sortdate} that is actually a date but is formatted in the database as a string. So the text coming into Crystal (8.5)looks like "M/D/YYYY", including the slashes. The Date formula needs the string to be "YYYY,MM,DD" to work, right? The only way I can think of to convert this back...

You are awesome...I can't believe I never noticed that before. How could I have missed that? Thank you!

Anybody know where I can find/buy a list of formatting syntax? lbass helped me out today with "crLeftAligned" & "crCenteredHorizontally". And I know about some of the font formatting, eg. crbold, critalic, crred, crblue, etc. I like to write conditional formulae to format fields, but I can't...

works great. THANKS!

What is the crystal syntax I would use if I wanted to conditionally apply horizontal alignment to a particular field (ie. right-click, format field, horizontal alignment under common) if {field1} = true then *want to left align here else *want to center align here

In Crystal 8.5, how can I write a formula to insert a paragraph mark/return between two strings. I am doing FIELD1 + FIELD2 and I want it to print as "FIELD1 might say something FIELD2 continues here" versus "FIELD1 might say something FIELD2 continues here" I have Can...

good point...will do that in the future. Not sure I understand what I should do after adding CHARTCOSIG into the main report. Main report has CHARTING with (1) an equal join to PRACTITIONER via PractID and (2) an equal join to CHARTCOSIG via ChartID. The subreport has CHARTCOSIG equal...

REMill, Unfortunately, the report is a little more complicated than what I had described. It's really an audit report to see if the note was cosigned by someone from the correct area (eg. 1st floor vs 2nd floor, Physical vs. Occupational Therapy, etc.). I had to use a subreport (I think)...

Thanks for the suggestions, but I've already got all of those things going on already. The subreport isn't creating my blank lines (since everything in it is suppressed), it's the fact that in the main report, the subreport is taking up space in the GH. So no matter how small I shrink the GH...

I am using a subreport (in group header 2) to generate a shared var that conditionally suppresses the details in the main report. I don't want to see the data in the subreport. But if I suppress GH2, I don't get any data from the shared var. My workaround was to suppress everything within the...

I'm using CR8 and I'm formatting a formula field...it works great. THANKS. scott

I want to use the Format Editor to write a conditional formula to change the Font...ie. if {field}=true, then Arial (Western), else Times New Roman (Western). How do I do this? I can write formulae to change Font Style/Color, but I can't figure out how to change the actual font.

Thanks...works great. Now the problem I have is that part of my page footer is based on the details section of the group...it's pulling a formula field generated with data in details. So I'd like to suppress that formula field when it's the page footer for the title page and print when it's...

If I have a report that is grouping by floors of a building, how can I print a blank page before each group/floor to separate them. Or better yet, instead of a blank page, make it like a title page, ie. "Data for Floor 1", "Data for Floor 2", etc. I've already got it to do...

Thanks for the tip!!! We're using CR 8.5 and the arrows worked perfectly...I always wondered what those up/down arrows were for.

I have a report with 5 parameters. How can I change the order that the Parameter Values prompts are listed when I go to print preview?