A
AbanoubZak
Guest
Hello,
I have a little problem, I need a fill a crystal report from SQL table
what i need exactly is to display the rows that have a specific value
let's say i have a table with columns(ID, Name, Credits, state)
and i need to display only the rows that have State have value"Active" in "State" column
the query is
Select*
from table
WHERE state =@State
and my code to fill the data is
Dim AC as string = "Active"
tableAdapter.fill(Me.DataSet.Temp_A, AC)
So how to fill this specific data in crystal report while my table might have rows with state value is "Nonactive" which not need in my report
Continue reading...
I have a little problem, I need a fill a crystal report from SQL table
what i need exactly is to display the rows that have a specific value
let's say i have a table with columns(ID, Name, Credits, state)
and i need to display only the rows that have State have value"Active" in "State" column
the query is
Select*
from table
WHERE state =@State
and my code to fill the data is
Dim AC as string = "Active"
tableAdapter.fill(Me.DataSet.Temp_A, AC)
So how to fill this specific data in crystal report while my table might have rows with state value is "Nonactive" which not need in my report
Continue reading...