Crystal Report Selection Formula gives me only one row

0
votes

how was the day? I have a Problem related to Crystal Report in VS2010 where I designed my Crystal Report and connected it to Assessment.dbo in my Database and it works fine to display all Records. But I use Selection Formula to display only one Student Record by typing Student ID in Sol.text with this code:

 REPORT_SHEET.CrvReport.Enabled = True
    REPORT_SHEET.CrvReport.ReportSource = "C:\Users\MUSTAPHA YUSUF\documents\visual studio 2010\Projects\SMS\SMS\Student_CrystalReport.rpt"
    REPORT_SHEET.CrvReport.SelectionFormula = "{Assessment.ID}=" + Sol.Text
    REPORT_SHEET.CrvReport.Refresh()
    REPORT_SHEET.CrvReport.RefreshReport()
    REPORT_SHEET.Show()

The Problem is that, the Crystal Report only gives me first row of the Record not all the Records for the written Student ID in Sol.text. Thank you very much for your usual help!

1
vb.netcrystal-reports
May you describe your table schema? – heringer
i have ID, Session, Term, Class, Subjects, 1stCA, 2ndCA, Exam, Total, Position, Grade, Remark in my table – Mustapha Yusuf
in which section in the report are you placing your fields? – Zeina
in details Section @Zeina – Mustapha Yusuf
Can you add the grouping design of your report? – Zeina

1 Answers

0
votes

i have solved the Problem @Zeina, i found that the Problem comes from my Database where i must have int in my schema. so i created another column to assign that int and it works. Thank you very much for your usual Supports!