Search results for query: *

Hi. I feel like I've asked a similar question before, but here goes. I am on version 9. I am trying to group my report by the @Percent Variance formula and the formula is not available as a group. I am trying to group it because I actually want to sort by it, and I can't because I have another...

Hi. I have v9. I have a name field that is laid out as "FirstName LastName". I do not have two different fields for the first and last name. They are in the same field. Is there a way to create a formula that only displays the LastName? The LastName will always be after the space. Thanks! Sky

Hi. I am on version 9. Can I write a formula to put a red line through records that meet certain criteria? I only want the line to be red. I want the text to be black. I know I can make both the text and line red or both black by doing a font formula for strikeout. And I know I can put a red...

Hi. I have Crystal Reports Designer version 9. It seems, lately, when I select a field on my report, right click and select Highlighting Expert, my Crystal app locks up. I have to ctrl-alt-delete - end task to get it to close. Any thoughts or experience with this? This seems to be the only...

Hi there. I am using Crystal version 9.2 and I am trying to put a yellow background on a particluar field of data and then suppress the backround if the data meets certain criteria. The field is a datetime field. I want to supress the backround if the datetime field is +/- 30 days from the...

Did I just mess up the "Group/Sort on Formula Field Containing Sums" thread by posting the SQL Query? I don't see the section to respond to the posting any longer? If so, this is a continuation of the thread. Lbass, did you get the SQL Query that I posted? Skystar

Hi. Complex situation here (for me anyway). :) I have a report of project names and costs for each project, broken out by expense total and capital total, then project total. I need to sort the report by project total high to low. Here is why it is so complex: The records are summed at a group...

Hi. Not sure how to explain this, but here goes. I have a report that has 2 groups: Group 1 - Result 1 Group 2 - Result 1 Record 1 Record 2 Record 3 Group 2 - Result 1 Summary Group 2 - Result 2 Record 1 Record 2 Group 2 - Result 2 Summary Group 1 - Result 1...

Hello there. I am on version 9.2. I am attempting to create a single pie chart in my report footer using the chart expert. In my data tab, I have selected Advanced Layout - once per report - Footer. Then, I can select the "on change of" field, but cannot select the formula field that I desire...

Hello there. I am on crystal version 9. I have created a report that includes a pie chart in the report footer. I upload the .rpt to my application server in order to view through a report viewer application, but for some reason I am unable to see charts when I view the report. The report footer...

Hello. I am on Crystal v 9.2. I having an issue with a selection formula which is a bit hard to describe. First, here is my formula right now: {s_work.extract_id} = {?ExtractID} and {st_work_7.structure_name} = "$Plan" and {st_work_7.depth} = 7 and {s_work.structure_name} = "$Plan" and not...

Hello. I am on v 9 and have created the following formula: If {st_wbs99.description} = "Extra Small" then 50000 Else If {st_wbs99.description} = "Small" then 100000 Else If {st_wbs99.description} = "Medium" then 250000 Else If {st_wbs99.description} =...

Hello. I am on CR 9. I have a report which contains 8 subreports, all in the details section, printing one after another. All 8 subreports contain various long text fields from the database I am working with. On one record, the subreport data that is displaying has more data than in the...

Hello all. I am a beginner working with SQL views. An old colleague of mine created a view that I am using in a crystal report (crystal 9, sql 2000). All of a sudden, since going to a new version of the application we are pulling data from, the report is not giving me all of the info I need...

Hello. I am new to Microsoft Project. I am entering tasks with durations in my project file, and then linking the tasks finish to start. The start and finish dates are mostly coming out okay when after linking the tasks, but I notice that one of the tasks that I have as 4 week duration starts...

Hi there. I am using Crystal version 9. I have added the Special Field called Page N or M to my Page Header. When I generate the data in Crystal, I see the proper info. However, when I place the report on my web server and generate the data, on page 1, I only see "Page 1". On Page 2, I see...

Hello. I am using Crystal 9 with SQL Server/DB. I have a report that is displaying the Report Header section on the first page and the Report Footer at the bottom. There is no other data on the first page, leaving a bunch of blank space. It appears that the Report Header takes up most of...