Search results for query: *

My crystal report (XI) group footer (GF1) will only display/print if it contains a single subordinate record (GF2). When GF1 contains more than one (GF2) subordinate item, my text,and summation items in GF1 will not display/print. But GH1 headers always appear.Is this an incorrect option setting...

LBass, that worked great, thanks alot! The last thing I need to do in this report now is add one last summation (Grand Total)into the report footer (RF), summing the those new GF1 summaries you helped me create.Or, couldn't I accomplish the same thing by summing those smaller subtotals in GF2...

I have a formula in the first group footer below the Details section(GF2) that simply multiplies two other formula fields, both of which are also in GF2 but to the left. Each of those two formula fields being multiplied are essentially "one sum subtracted from another sum" in the details section...

I am using Crystal Reports XI and I am trying to change the datasource in a (copied)new report using "Database Expert" to change the data source from the old sql server view to a new different view in a different database completely but residing on the same server.I also tried using the "Set...

My data points in my line chart are not aligned up in a horizontal sense with my x axis tick marks.They fall in between the tick marks.I have been experimenting with checking/un-checking various check boxes inside different Chart Expert or Chart Options dialog boxes with no progress. Any idea...

LBass, that sample code in your reply would be created under "SQL Expression Field" or "Formula Field" in Crystal? All I have ever done is create formulas and then drag them into report where I wanted them. If I create one long,complex SQL query string and then give it a name and save it.....how...

LBass, that sample code in your reply would be created under "SQL Expression Field" or "Formula Field" in Crystal? All I have ever done is create formulas and then drag them into report where I wanted them. If I create one long,complex SQL query string and then give it a name and save it.....how...

I have created parameters before for record selection. Is it possible to create user-defined parameters from a pick list of different tablenames (static or dynamic)?I have to create a comparative report comparing table values for the same fields every three months. A new table is being created...

For simple aesthetics, how does one right-align displayed summary values "in the same column" when actually one of the summary values lies within a subreport? I have been just dragging the summary box in the subreport left or right and gotten it as close as possible by eye but it is still not...

I find that entire "Insert Subreport" dialog box confusing.But I got lucky.Everything looks the way I want it now that I activated the "select data in subreport based on field" and then chose my grouping formula.All my other reports that contain subreports, the subreports are in the Report...

How do I get group summaries in Crystal subreports to display in the same appropriate group level in the main report? I.E. my new subreport I added is a seperate database I had to link my report to.Now I have two data sources on this one report.This new subreport, the data values are carved in...

Thank you everyone for your help.My report is complete and came out great!I have now been initiated into the world of shared variables.Thanks again.

Can someone please remind me how to add another report footer to the bottom of my report.I know if I add another group, I will have a new group header and group footer but that's not what I want. I want to just add a second report footer at the bottom. Then I will have RFa,RFb.This is all to do...

Lbass, I think I must have setup my report badly because my subreport is embedded inside the main report and the main report is all suppressed except in the Report Footer section.My subreport lies in the Report Footer section of the main as well(line 4 of 5 line report).Embedded see?Now what do...

I have two numbers displayed one directly below the other. But the lower number actually is a subreport summation value. The top number is part of the main report.Is there a way to subtract the lower subreport number from the upper number which is in the main report?No? Currently,I whip out my...

Thanks LB, I left the numbers as two decimal places now in the chart instead of whole numbers.I was able to leave the font size the same and did not have to rotate them either.No more worrying about rounding issues causing the sum of the three different stacks going over "100" percent. Too bad...

Each column of my eight-column stacked barchart has three different colors in it representing three different possible filter-returns on the same field of my database.Summary percentage values based on a formula are displayed within each of these three different colored sections.I have set these...

I have a one-page report (unfortunately). Thus, I cannot use the 'print state'= page 2 to suppress the second and last occurrence of my 'Group Footer#1' and the 8 to 10 text boxes/summaries/various fields contained within 'Group Footer#1'. How do I accomplish hiding this second and last...

Worked great LBass....thank you very much!

I have a main report which contains a un-linked subreport(groups,filters,summarizes same data in a different way).Works good.Now I just added a user-prompt parameter into the main report and incorporated the parameter into a record-selection formula.Tested it, works good.But, I am not sure if...