From the course: SQL Server: Reporting Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Add a time chart

Add a time chart - SQL Server Tutorial

From the course: SQL Server: Reporting Services

Start my 1-month free trial

Add a time chart

“

- [Speaker] I want to add one more element to the mobile report. And that's to add a chart of sales over time. To do this, I'll need to create a new data set to pull the information out of the SQL server database. I'll go ahead and save the progress That I made on the report so far. And then close it down. That will return me to the portal. Then I'll go to the new menu and choose dataset. I want to use the shared data source connection to the Wide World Importer's database. But because we've moved it into a new folder on the report server, this link isn't going to work. When I press the create button, I get an error message. So instead, I need to go to browse for other data sources and then find it in the new location. Once I find it in the data slash data sources folder, I'll say open, we'll select that one, and say create. Then we can query the data out of the database. The data that I need is in the sales schema and in a table called customer transactions. I need the transaction…

Contents