Change Column Size

[mrdaytrade]

I made a report that includes the date. I would like to make the column wider to show the time too. In Sql it seems like the column size is set for 8 characters, it's grayed out in the column property settings so I can not change it. Is there a way to do this?

I know the time is displayed along side the date when I view the column in the table view, but not showing in report view on the web page.

Thanks

[Hemoco]

Change the query to :

SELECT DISTINCT
TOP (10) PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Username, dbo.tblOperatingsystem.Description,
dbo.tblComputers.Lastseen as newdate
FROM dbo.tblComputers INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
ORDER BY dbo.tblComputers.Lastseen DESC

[mrdaytrade]

Actualy this is the report I created. When I go to the web console and click on the report it does not display the whole date and time as seen within the dbo.tblComputers.Lastseen field, just the date. The web console view gives the column name of "date". I can't seem to change that.

SELECT DISTINCT
TOP (10) PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Username, dbo.tblOperatingsystem.Description,
dbo.tblComputers.Lastseen
FROM dbo.tblComputers INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
ORDER BY dbo.tblComputers.Lastseen DESC

[Hemoco]

If you don't change the name of the column its automatically shortened.
Just change the name of the column to something else like "newdate".