Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yosteevo

    Sum of a Formula and Sum of Records Sorted by a Group Sort

    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
  2. yosteevo

    Sum of a Formula and Sum of Records Sorted by a Group Sort

    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...
  3. yosteevo

    Get page numbers on page break pages in Crystal Reports

    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...
  4. yosteevo

    Get page numbers on page break pages in Crystal Reports

    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
  5. yosteevo

    Get page numbers on page break pages in Crystal Reports

    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
  6. yosteevo

    Get page numbers on page break pages in Crystal Reports

    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
  7. yosteevo

    crosstab auto row height & suppress grand total fields

    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...
  8. yosteevo

    crosstab auto row height & suppress grand total fields

    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...
  9. yosteevo

    Page Formatting for Crosstabs

    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...
  10. yosteevo

    Page Formatting for Crosstabs

    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...
  11. yosteevo

    Multiple Subreports and Performance Issues

    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...
  12. yosteevo

    Multiple Subreports and Performance Issues

    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 &...
  13. yosteevo

    StoreVar and FetchVar Functions in CR 2008

    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
  14. yosteevo

    StoreVar and FetchVar Functions in CR 2008

    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...
  15. yosteevo

    How to Build a Crystal Report using an Excel OLE Object as a template vs using a Cross-Tab

    Thanks hilfy, I just added my MS Excel Template Designer idea to the SAP site. Stephen
  16. yosteevo

    How to Build a Crystal Report using an Excel OLE Object as a template vs using a Cross-Tab

    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...
  17. yosteevo

    How to Build a Crystal Report using an Excel OLE Object as a template vs using a Cross-Tab

    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...
  18. yosteevo

    Reporting images in Crystal Reports 2008

    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...
  19. yosteevo

    Reporting images in Crystal Reports 2008

    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

Part and Inventory Search

Back
Top