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!

Recent content by jlkjr

  1. jlkjr

    Favorites bar IE8

    This will put it in favorites but not on the favorites bar. Upon further research the path is %USERPROFILE%\favorites\links for XP.
  2. jlkjr

    Favorites bar IE8

    What would be the best way to script adding favorites to the favorites bar in IE8?
  3. jlkjr

    List groups in rows instead of columns

    I found my mistake. The group footer in the subreport cannot be suppressed.
  4. jlkjr

    List groups in rows instead of columns

    I should know by now that more detail is better than the minimum. I was hoping that a generic situation would give the guidance necessary. I can't seem to make this work. This is already a subreport (for college entrance tests) linked on a different group (student name, group 3 of main report)...
  5. jlkjr

    List groups in rows instead of columns

    Group header two and details are showing. The details do need to stay below the header, but if the group changes I would like it to move right instead of below the first grouping.
  6. jlkjr

    List groups in rows instead of columns

    Using CR 8.5, is it possible to make a group display to the right of the previous group instead of below?
  7. jlkjr

    Subreport pulls null value not in database

    Problem solved. The formula for school name did not match between main report and sub causing the parameter not to match the data.
  8. jlkjr

    Subreport pulls null value not in database

    Both the main report and subreport are blank when it is not working correctly. The detail section of the subreport contains a formula changing the credit earned field from the database to a number. It is suppressed. When it is unsuppressed, I get an error stating that the field is non-numeric...
  9. jlkjr

    Subreport pulls null value not in database

    Order of groups in main report is student, year, school. Record selection formula for main report: {StsGrdsGrds_1.StsGrdsGrds_1_Gradelevel} in ["08", "09", "10", "11", "12"] record selection formula for subreport:{StsSt.StsSt_Studentname} = {?Pm-StsSt.StsSt_Studentname} and...
  10. jlkjr

    Subreport pulls null value not in database

    The subreport does return the expected values when run by itself.
  11. jlkjr

    Subreport pulls null value not in database

    Yes there are several linked tables throughout both main report and the sub.
  12. jlkjr

    Subreport pulls null value not in database

    The subreport is in the group header for the school, which comes after year and student. Not sure I understand the second question. The sub report is linked to all three (student, school and year).
  13. jlkjr

    Subreport pulls null value not in database

    Crystal Reports 8.5 and Access97 Using a subreport on a transcript to calculate the credits received at a particular school for a given school year. Subreport is linked to the students name, academic year and school name. When a particular combination of year and school has only one item...
  14. jlkjr

    sum of formula returns wrong result

    Links all look correct. The option for show SQL query is grayed out.

Part and Inventory Search

Back
Top