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 Mike Lewis 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: jlkjr
  • Order by date
  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.
  15. jlkjr

    sum of formula returns wrong result

    This version does not have a database expert. I am using 8.5.
  16. jlkjr

    sum of formula returns wrong result

    I am not sure how to assess that.
  17. jlkjr

    sum of formula returns wrong result

    Results do not need to be specific to school since the data is only recorded for attendance at our school. The sum returns 66 because there are 66 lines in the details. However, the database has only one record not 66. Select distinct in grayed out. I did notice that the select records...
  18. jlkjr

    sum of formula returns wrong result

    A student can have more than one school within an academic year if he transferred in mid-year or took a summer course at another school. Here is the selection formula for the subreport: {StsSt.StsSt_Studentname} = {?Pm-StsSt.StsSt_Studentname} and {StsGrdsGrds_1.StsGrdsGrds_1_Academicyear} =...
  19. jlkjr

    sum of formula returns wrong result

    group 1 student homeroom group 2 student last name group 3 student full name group 4 academic year group 5 school The subreport is grouped only by student full name The subreport is linked to the main report by student full name and by academic year.

Part and Inventory Search

Back
Top