Showing posts with label fairly. Show all posts
Showing posts with label fairly. Show all posts

Tuesday, March 20, 2012

Converted report loses border around report body

We have a (fairly large) number of reports that were created in RS 2000. We are trying to convert them to RS 2005.

All of these reports have a border around the report body. When I view the converted report in Visual Studio 2005, the border around the report body can be seen, but, when the report is rendered on the 2005 report server, the border around the report body disappears.

I've tried adding lines around the edges of the report body, but sometimes the right side line doesn't show up when the report is rendered, either.

I've seen questions about this on a few other sites, but no one seems to have an answer or workaround.

How do I get the border around the body of the converted reports (or lines around the body of converted reports) to reappear without having to completely rewrite over 50 reports?!?!?!?

Hi, I have the same problem.
Do you have solve it?
Thanks|||No one has a solution yet.

Friday, February 10, 2012

Convert date to quarter

I'm fairly new to crystal, and I have a crosstab that list columns by a date field, and groups the date by quarter. In the header of each column, crystal displays "1/2007 ..... 4/2007...... 7/2007..... etc (its displaying the first month of the quarter). I want to convert that header from the month/year to 1Q07......2Q07.....3Q07...etc, or something similar that identifies the quarter and year. Any ideas? I cant find a function and can't come up with forumula to do this. Im sure this is an easy question for most :)Create 2 formulas: the 1st one for the quarter and the second one to get your desired result:

1. @.Quarter

if month({table.date})<=3 then '1' else
if month({table.date})>=4 and month({table.date})<=6 then '2' else
if month({table.date})>=7 and month({table.date})<=9 then '3'
else '4'

// it's not necessary to place it in the report area
----
2. @.nQYY

{@.Quarter}+'Q'+right((totext(year({table.date}),0)),2)

Use this formula in your crosstab to list the columns by it, I mean instead of your {table.date} field.