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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by edwindow

  1. edwindow

    Extra pages on Export

    I have extra pages at the end of the document which I can live with. I have two groups that have the New Page after function for example Group 1=Period ending date Group 2=Department The department Group will create extra pages within the main document. Mostly when there is a new period...
  2. edwindow

    Extra pages on Export

    I am having a problem with extra pages displaying within the main report when I export into Microsoft Word. I have two groups in the footer area that have the New Page after group function activated. I think since I have two groups that are using this feature it is causing extra pages within...
  3. edwindow

    Summary problem

    I am trying to do a compliance report that tells me how many people have entered less than 40 hours per week. But I have to calculate hours per period. So the grouping is,from the top, by employee, period, and hours. At the detail level I have hours for each day and I summarize the hours at...
  4. edwindow

    Simple Subreport problem

    That knowledge article helped me. Thank you so much.
  5. edwindow

    supreport linking

    Parameters do now show up on as a selection criteria. I created the date parameter in the subreport; however, there was no link option in the main report.
  6. edwindow

    supreport linking

    Is there a way to link a date parameter used in a main report to a subreport? I want my subreport to collect data for the selected range in the main report. Is there a way to link the parameter in the main report to the subreport?
  7. edwindow

    Simple Subreport problem

    I am using subreports for the first time for one of my reports. What is happening is the subreport is running for only the last record. I have made a transactions report that displays information for each period. The Main report has to date parameters that allows me to select multiple...
  8. edwindow

    can't sum with text in the fomula

    Naith, This is a good idea however it sums the numbers throughout the entire report. I have things broken down by department. I tried to change the condition so that it stoped at the group department level but I got an error that said the group is not a repeating field/function etc. Eddie
  9. edwindow

    can't sum with text in the fomula

    I have to do this approach mainly because of the tables I am using. My overall objective is to get the total number of employees with hours less than 35. Seems simple but based on the way I have to link the tables, I am getting duplicate records. So I tried to make a formula that basically...
  10. edwindow

    can't sum with text in the fomula

    I have a formla that returns a number as a value however I can not sum on the field because within the If/Then statement I have a text field comparison. Example of my code if(({SECURITY_PROFILE.FULLNAME}<>previous({SECURITY_PROFILE.FULLNAME})) and ({TW_V_TRNSTOT.TRANSTOTAL}<35)) then 1 The...
  11. edwindow

    Subreport value within a formula

    Ok thanks. That is a big help.
  12. edwindow

    Subreport value within a formula

    Does anyone know if it is possible to take the value within a subreport and put it within a formula within the master report. I have made a subreport that basically gets the total number of employees. But now I need that total to make a calculation within my main report. Is there a way to do...
  13. edwindow

    Multiple Parameter Selection

    I only have one parameter, but it has multiple values. I think I have to know the exact length of the multiple default value array. The parameter is Activity Description and currently it has 4 default values such as 1value, 2value,3value and 4value. I just want to to look for the nubers...
  14. edwindow

    Multiple Parameter Selection

    I hope this is an easy one. I am making a custom parameter for my implementation team. I have one parameter that has 4 preset names such as 1_Name, 2_Name, 3_Name, and 4_Name. What I am doing is looking at the first position, which are the numbers and using them as identifiers for fields in...
  15. edwindow

    Crystal Reports into Front Page

    Does anyone know if it is possible to call the parameter window from Front Page so that input from the user can be entered? After the information is entered the report would then create an HTML file which could then be displayed. I am able to call HTML files with ease. I just want to know if...

Part and Inventory Search

Back
Top