Search results for query: *

All, I have about 20 columns in my report . When export to excel it displays 12 columns in one one row but other 8 columns are in row 2. What could be causing this? I have all 19 columns in gp_1 and 1 column in gp_2. gp_1 has underlay following sections checked in. One column that is in...

Hi All, I have a report which has 5 phases. 1,2,3,4,5. Each project has a phase. Project has costs in multiple phases For ex: Data for costs in phase 5 project is Phase Department $$ 3 HR 500 5 Accounts 100 5 Admin 200 2 Accounts 300 1...

Hi All, Is there a way to get data from 2 subreports and add them as a column in main report ? Here is what my data looks like: Subreport 1 Formula 1, Formula 2 Subreport 2 Formula 3, Formula 4 I have these 2 subreports in main report where Subreport 1 displays Formula 1 in a column in...

Hi All, My report is grouped by project ID. There is also a field for Category - values as S,0,1,2,3,4,5,6,7 A project can have multiple values for category for ex: S, 0, 2, 5. If I display Category in group footer it displays only one value 0. Pls suggest me a formula to display all the...

Hi All, I have data for a project as below: Start of the month(date) Monthly Usage(data in seconds) 03/01/2011 2000 04/01/2011 1000 05/01/2011 3000 and so on 10/01/2011 2000 11/01/2011 3000 I...

Hi All, I have a field Class, Data as A, B, C, D And a project can have any one class or multiple. Class is not a Boolean, its just a string value. Now if my project has Class A How do I display as Yes and if it does not have Class A then NO This is how I tried, but it gave opposite results...

Hi All, I need to build a formula for past and future costs based on year. Here is my data: For Past Cost Start Date 100 04/01/2010 200 04/01/2011 300 04/01/2012 Future Costs Cost Start Date 400 04/01/2010 500 04/01/2011 600 04/01/2012 I need to build a...

Hi All, I have data in a field {fruit}, data as: Apple Apple Apple Orange Orange Grape I need to display unique values like Apple Orange Grape Please suggest how to do this? {fruit} is placed in Group footer . All the other fields are summaries and placed in group header section . Group...

Hi All, I need to set a formula for dates. I have stage field as 0,1,2,3 . and each stage has a date. A project can have each stage multiple times. For Ex Project A has stage 0 Date 01/01/01 Project A has stage 0 Date 01/01/02 Project A has stage 1 Date 01/01/03 and so on. I need to write a...

Hi All, I have a report with date columns. If a finish date is 10/10/10 12:00AM in report it displays as 10/11/10 That is one day is added since the time is 12:00 AM Do I need to write a formula so that date displays as 10/10/10 only in reports? Thanks

Hi All, I have report which is 70 columns and set on a D size sheet. Now When I export it to pdf , its columns cut across and displays the columns in 4 pages. Is there a way to view all 7 columns in one page? Thanks

Hi All, I have 5 subreports. My main report has 7 parameters and these 5 subreports are inserted in the main report. An ex of one of my main report params is : (If ({?Project} = '' or {?Project} = '0') Then 1=1 Else{Query1.Project Id} = {?Project}) Need a suggestion on how do I link all the 5...

Hi All, Need help with building the formula for background colorization. Using CR XI I have 2 dates columns. 1 is End Date displayed as MM/dd/yyyy (date-time though) 2 is TGT Year displayed as YYYY (date-time though) Now i want to write a formula for coloring End Date per the below...

Hi All, CMS suddenly stopped running , what could be the cause. BO XI server installed on UNix box , but running reports from client tools. (Crystal). CMS was running fine but suddenly stopped and started giving an error. There is no CMS running at port 6400. Have restarted BO Services, but...

Hi All, I have a formula to display current Year in Header. @Year = (year(currentdate)) but this displays as 2,011.00 How do I display it as 2011 Thanks

Hi All, Using CRXI I have a report with 4 group footers. All th egroup footers are summaries and they are displayed in different background colors. I have inserted a Box for each group (each group has 10 columns) so one box for all those 10 columns in each group and gave the reqd background...

Hi All, I have a cross tab report, here is how the rows , columns, summaries are displayed. Rows 10 Summaries 10 Formulae (each summary is a SUM) Column 1 Formula (This is for year and forms 2 sections, one for all the 10 summary columns for 1 year and the other section is all the 10 summary...

Hi All, Have a question on formula based on parameter values. I have a parameter on region and report displays costs of projects in that particular region. For ex if region = 1 then report displays costs for all projects in region 1. Region Values= 1,2,3,...10 ?region= (If ({?region} = '' or...

Hi All, I have a cross tab report with about 15 fields as rows and 1 summary. This summary displays sum of costs. I had 2 formulae field in Columns: 1 for Year and the other is actually formulated in a way that it makes 4 columns. So basically I have Year1C1, Year1C2, Year1C3,Year1C4 and then...

Hi All, I have a cross tab report with about 15 Rows, 10 columns and 2 summaries as in cross tab expert. How do i get to display the headers of those 15 rows so that they are in line with the 10 column headers. Right now i can see thew headers for columns but not rows. Ver CR XI Thanks