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 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!!
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |