Search results for query: *

I can't get my subreports detail to print (export to excel) on the same line as my container report's detail. It displays correctly when I run it in Crystal but when I export it to Excel, the sub report detail prints on separate rows.

I created a subreport for a couple fields that I inserted on my main report's detail. When I export the report to excel, the subreport prints on its own row instead of in the columns with other details - how can I get the subreport columns to stay and appear as columns with the main report?

I have SQL statements that I want to run using Crystal 2008 reports but once I view 'Show SQL Query' under Database Expert, there is no way to cut and paste my SQL statement into the report. Is this possible?

Need to do a data dump of a table that has over 100 fields and want them displayed in a single row within Crystal XI. How do I set my landscape to do this?

I'm trying to create a parameter that will allow the user to enter part of last name to do a search using a Crystal Report XI. How can I do this?

We have a db that has memo fields in it that are in html format and we'd like to be able to display the memo field content without the html tags - can this be done in Crystal XI?

How do I capture first effective date of Job Title and current Organization while in that Job Title? Data Rows = Start Date Job Title Organization 01/2009 Consultant-AP Org 5 01/2008 Consultant-XX Org 5 11/2007 Consultant-XX Org 5 6/2007...

Can someone tell me what's wrong with this formula? if isnull ({INDIVID.AET_CORPTITLE}) then {AET_INDSPT.SPT} else if isnull ({AET_INDSPT.SPT}) then {@titlenocode} else {INDIVID.AET_CORPTITLE} I want to show ee's corporate title if they have one, if not show me their succession title if they...

Using Crystal XI, current database has data with multiple years, including future. How do I create a select records formula to only capture data in current year plus data from previous 2 years? year(currentdate) - 2

I have a db with data in it by year and I'd like to create a Crystal Report that gives me data based on current year plus last 3 years - how do I do this? My data date fields = YYYY I'm using Crystal XI Release 2 Thanks in advance.

Using Crystal Report XI, can I create a pipe delimited file?

Can someone explain shared variables to me like I'm a 4 year old? :) I have some banding formulas in my main report that I'd like to share in my sub report, i.e. age bandings, tenure bandings. I am using Crystal XI. How do I eliminate the need to redo these formulas in the subreport? Thanks.

I'm using Crystal XI and creating a detail list of employees with demographic detail as well as multi-job information over years. I want to be able to show summaries around race and gender so I created running totals, distinctcount ID. I want to display these summaries above the detail. I am...

Using Crystal XI, I have a succession plan report that is grouped as follows: Group by: Manager ID, Plan, Readiness Detail: EEID, Age, Tenure How do I get my report to distinct count EEID in order to get an overall average age, tenure for all EEs, regardless of Plan or Readiness?

Can you tell me how to get year over year data comparisons to appear on a chart? formula field for average age formula field for average tenure year (i.e. 2006, 2007) Incumbent Successor Result in a bar chart should show: First Bar shows Avg Age of Successor population for 2006 Second Bar...

I am working with Crystal XI. I have formula fields set up to give me the percentage of a field on my report. Total Positions = 10 Total Positions w/Talent = 6 Total Positons w/Talent in 2 yrs = 10 Total Positions w/ER only = 0 I created formula fields to get percentages. <TPs> /...

Using Crystal XI, how do I colapse rows of detail into one row of detail from a heirarchy table? MgrID Level EEID 12345 0 45555 23456 1 45555 34567 2 45555 Thanks for any assistance you can provide.

What formula do I use to get the minimum effective date of a job in a subreport created to capture job history? This job history report pulls all rows regardless if a change in job occurred (a new row is created if the dept reorged, etc). Fields: EffDate, Job Title, Department, Organization...

Using Crystal 11, I'm creating a age field if employee is an incumbent in a position. if (field) = "incumbent" then 1 else 0 if (incumbent) = 1 then (age) else 0 in the report footer, I wanted to add summaries for average age by category. using example above, how do I get it not to count 0's...

I'm trying to create a pie chart based on a formula field grouping but the 'group option' button on the chart expert is greyed out. Only the 'advanced option' button is active. My report contains agebands that I've summarized. ageband formula = if ({@age}) <30 then "Age <30" else if ({@age})...