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: *

  • Users: sto837
  • Content: Threads
  • Order by date
  1. sto837

    Group Date

    Hi all, I would like to know if this is doable: Date parameter: Begin Date Date parameter: End Date If begin date is 2/1/2013 and end date is 2/5/2013, I would like the report to group the following: group header: 2/1/2013 record 1 record 2 group header: 2/2/2013 record 1 record 2 ...
  2. sto837

    Do not suppress the last group footer on each group

    Hi experts, I would like to not suppress the last group footer 2b on each group so it can act like a group footer 1 when I do a manual sum. Now Group footer 2a (group by name) Group footer 2b Group footer 2a Group footer 2b Group footer 2a Group footer 2b Become July Group footer 2a Group...
  3. sto837

    Convert total days into year and months

    Hi, Is there a formula where I can convert total days into year and months? For example, the total days are 2176, and it is approx 5 years and 10 months. Thanks
  4. sto837

    Supress embedded subreports

    Hi, I have a report which linked with 7 subreports. Basically, group header 1a has all the subreports embedded and the data from the sub-reports are passed to the formulas I created on group footer 1a. The subreports itself are suppressed, but not the group header because if I suppress the...
  5. sto837

    Sort values from subreport

    Hi, Can a master report be sorted from the number value that is passed from a subreport? OR if I have a multi-instance table and I have grouped by unique ID. I've created a runningtotal to totalup the value within the unique ID and I need to use that number to subtract from another value...
  6. sto837

    Page Number Summary Page

    Hi, If I have a master report with page number on each detail and I would like to create a summary directory page for that report. How can I pass the page number from master to my subreport? Thank you.
  7. sto837

    Cross Tab

    Hi, I am using Crystal 10. Is there a way where I can keep group together from running a Cross Tab? I do not want a group to split between pages in a cross tab. Thanks!
  8. sto837

    Link 2 different data types tables

    Hi, Does anyone know how to link tables with 2 different data types? One is a string and the other is an integer. I got some information online that I can link in formula editor and change the data type through SQL. I never done it before so I have no idea where to go about this. Can anyone...
  9. sto837

    Pulling data from subreport and use it in my selection criteria

    Hi, Does anyone know if I could use the data from subreport in my selection criteria on my main report? The reason I need to create subreport is because there is no direct linking. I need to create few formulas in my main report in order to link a different table and pull in the appropriate...
  10. sto837

    Cross Tab

    Hi, Is there anyway to create the following Cross Tab report ItemA ItemB ItemC SubTotal(ItemB+C) Total Total% Jan 1 2 3 5 6 5/6=83% Feb 2 3 4 7 9 7/9=78% Thanks
  11. sto837

    Run Excel from Crystal Report

    I have a problem when I run Crystal report from an excel file where the field from excel would become blank if the value of the field is not at the top. For example, an excel would contain 20,000 records and if the first value of the excel field is at the bottom, then when crystal report runs...

Part and Inventory Search

Back
Top