Yes you are right, sorry about it, fake data.

ScottPletcher (2/21/2014)

---

I, too, got different totals; mine add up to 82, the number of sample rows of data.

SELECT

Owner, CAST(YEAR(Quarter) AS char(4)) + 'Q' + CAST(DATENAME(QUARTER, Quarter)...

Sorry if the fake data confused you.

Thank you dwain

Thank you very much for the quick and neat solution

HanShi (2/11/2014)

---

You can use the DATEPART function to get the quarter of a datetime value. Next you need to GROUP BY on the DATEPART part. Below I have generated some...

Please refer to the code to generate sample table/data, thanks.

CREATE TABLE [dbo].[Ticket](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Ref] [varchar](10) NULL,

[CreatedOn] [datetime] NULL,

[State] [varchar](10) NULL

) ON [PRIMARY]

GO

--Open data for each quarter in 2013

insert...

I resolved the issue by re-installed everything, thanks.

Unfortunately still not working!

I've...

This is what I have:

Binary Path: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\ReportingServicesService.exe

Host Name: TISR9C5N5V

Name: SQL Server Reporting Services (MSSQLSERVER)

What should then I use as Server Name? When I open up the...

issue resolved: the path is different than dev machine

Finally I saw the emails with attachment, there is nothing wrong with my code or my configuration on the server, the emails arrived: not in inbox but in Junk....

After checked sent email using:

msdb.dbo.sysmail_sentitems

It turns out the test email is sent, but why it doesn't arrive in my inbox? the attachment is just pure text file. .log is not...

Thanks for all replies, I think I should forget it

I am working on a Dundas Dashboard project, DD allows user to connect to a database using a different domain id as long as the id's password is pre-inputted into...