Hello IdoMillet,
DistinctCount() also does not work. Again this is a formula I am attempting to calculate the sum of and it is a numerical result.
It seems that Crystal Reports does not allow the use of functions to be applied to formula fields within the Formula Editor.
Thanks
Stephen
Subject: Sum of a Formula and Sum of Records Sorted by a Group Sort
I am using Crystal Reports 2008.
1) I have a subreport where I need to calculate the sum of the output of a formula that outputs a numerical result.
2) In this subreport I have a group configured that sorts data by one...
Hello Madawc,
My page numbers are at the bottom center in my Page Footer section.
I did figure out a work around for this issue by using the Horizontal Page Number and text that is suppressed when Horizontal pages are not present.
I have three crosstabs in my report that will only every expand...
Here is a discussion I found from SAP's Community Network:
http://scn.sap.com/message/13911240
I am still trying to make this work correctly for my report.
Stephen
I would like to see (Page # of #) on all the pages of my report. I would also like to see the horizontal page breaks have their own page numbers as well.
Thanks
Stephen
I am running Crystal Reports 2008.
I have a cross-tab in a report that flows over into a page break.
My page orientation is set to landscape.
I would like to have my page break pages numbered as well.
How do I do this?
Thanks
Stephen
Thank you Madawc Williams.
I did get the suppression of the totals fields in my cross-tab to work properly.
I needed to select each row field within the cross-tab expert and manually check the additional checkbox for "Suppress Subtotal" in the (Rows:) section under the Customize Style Tab from...
crosstab auto row height & suppress grand total fields
I am using Crystal Reports 2008.
I have a crosstab configuration that utilizes a database field that produces Long Text results.
These results can be anywhere from 10 – 1000+ character spaces in length.
I would like to figure out a way to...
Thanks Madawc Williams.
What did you mean about this suggestion:
"use SEARCH if you don't already know about them."
I was not clear what you are referring to.
I am looking into wrapping the crosstab.
I have come across some examples of this online. I still did not get it to work yet. I'm...
I am using Crystal Reports 2008.
I have a Crystal Report that contains several crosstabs.
The data is being cut off when the data goes beyond the page formatted size of 8.5" x 11" ( landscape).
I would like the data that is produced from my crosstabs to move to the next page without the format...
Thanks Madawc,
I figured it out.
I simply needed to create single groups in the subreports that shared similar data layouts.
I then moved my cross-tabs, headers, & footers into the group's headers and footers.
This returned the result I was after.
The group filters by a database field that...
I am using Crystal Reports 2008.
I have a report that is configured with multiple subreports that are linked to specific data groups within my database. I have about 100+ subreports within one main report.
This allows my laboratory to utilize one main report for all the various testing &...
Thanks Pete,
I did have the correct syntax.
I just needed to import another copy of my subreport in my main report's header and suppress all the sections within the subreport copy.
Stephen
I am using Crystal Reports 2008.
I need to assign the calculated value of a formula to a Shared Variable that is configured within a subreport that is configured in a main report.
I then want to have the ability to recall the value of my formula calculation contained in my subreport in order...
Thank you hilfy.
This is what I was assuming to be true.
I look forward to the day where there can simply be a plugin for Excel and simply link to your databases from within Excel and then export an Crystal Report File.
And it would also be nice to have Fully-Functional Excel templates...
I would like to know if it is possible to use an Excel OLE Object similar to the way a Cross-Tab is configured within Crystal Reports?
I have many complex tables I need to build and certain rows and columns need to repeat as the data grows to page 2 and page 3 etc.
In the past I created MS...
Hi Kim296,
I do have another question in regards to resizing the images so they fit on one page instead of getting cut and going to the next page.
Currently my (.jpg image files) are being displayed on two pages due to their large size.
Is there a script that would auto-fit the images to...
Thanks Kim296,
Here is what ultimately worked for me:
In the "Graphic Location" formula box, I used the following:
"\\server name\folder name\" & {doc_file.df_filename}
Stephen
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.