Generate multiple line series in a single page | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Generate multiple line series in a single pageI have the following table:
log( occuredTime datetime, term varchar(50), termImportance float); data characterstics:
for each occuredTime, we will have certain terms with some importance value
Expectation: I need a single page line based chart report
Between time T1 and T2
Display a separate line series denoting term importance of each term occured during time.
I have to achieve this using SQL reporting services
Instead of displaying all terms, i can restrict to a set of terms using like ‘%’+term+’%’
Case closed! Its straight forward!!