Showing posts with label home. Show all posts
Showing posts with label home. Show all posts

Tuesday, March 20, 2012

Adding text to RS home page folder.aspx

I would like to be able to add some text to the SQL RS home page (folder.aspx I believe). Is this possible and if so, how? Also, what if I would like to add a graphic (logo) to it as well.

thanks!

Martha

Hi Martha,

Can you please clarify your question? What do you mean by SQL Reporting Service home page.

Sincerely,

Amde

|||What you can do is to tweak the CSS file which is included in Reporting Services to get a company look-a-like.

http://msdn2.microsoft.com/en-us/library/ms345247.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I would like to be able to go to the page that lists the SQL RS reports that can be run and add some text, for example, "Sales data last updated 6/23/06". The page where I would like to see this show up is http://servername/reports/Pages/Folder.aspx

thanks!

Thursday, February 16, 2012

Adding data to columns

Hi

I'm am using SQL Server 2005 Express on my home PC.

To practice some of the SQL skills I learned on a course I was recently on, I am trying to build a mini database which I can run some queries from.

I have created some tables and added columns to these tables. However, I cannot find how to add data to these columns.

I'm sure it's pretty simple but I just can't find it! Can anyone help?

Cheers!

Hi,

use http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

to do this with an administrative console, otherwise, code you own gui to put in the appropiate statements.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

MarkAdams,

If you want to practice SQL "by hand", you can use an insert instruction. For example :

INSERT INTO Members (Id, FirstName)

VALUES (1, 'Mike');

In this example, we have a table Members which contains 2 columns : Id and FirstName). The values to insert must be appear in the exact same order as the columns names listed.

If Id is an identity column used as a primary key, you don't enter any value by hand. So the insert instruction will look like :

INSERT INTO Members (FirstName)

VALUES ('Mike');

The SQL Server 2005 Management Studio Express application is a good tool to learn SQL, because you can use both graphical and script method to execute instructions.

Best regards.