SQL Server Performance Forum – Threads Archive

Generate multiple line series in a single page

I 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
where
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
An extension:
Instead of displaying all terms, i can restrict to a set of terms using like ‘%’+term+’%’

---

Case closed! Its straight forward!!

---

]]>