Direction of Chart Axis Labels

Sometimes the chart axis labels are vertical.
Sometimes the chart axis labels are horizontal.
How can I control this?
Thank you in advance.
JerryDid you see this related thread?
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3f2c6661-5754-4d85-bd41-bf5fdc97a5db&sloc=en-us
In RS 2000, the orientation is determined automatically based on the
available space. Providing additional manual and automatic label modes is
under consideration for a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410120839.b124e0@.posting.google.com...
> Sometimes the chart axis labels are vertical.
> Sometimes the chart axis labels are horizontal.
> How can I control this?
> Thank you in advance.
> Jerry

Differential Backup via Maintenance wizard

(If this is not the correct forum please point me in the right direction)

I am trying to schedule a Daliy differential backup using the Maintenance Wizard. This works fine for me, however I do not see where I can actualy speficy the file name I want to use for the differential backup

I notice that SQL 2005 will add the date and time for example MyDatabase_backup_200703191330. I would like to use a different name, for example MyDatabase_DiffBackup_DateTime. How can I specify this, I am not able to modify the T-SQL that is generated. is there a way to do this? Modify the T-SQL

Do I need to specify "backup databases across one or more files option" if so where do i specify the file name.

Should I create the job manually and execute to a T-SQL statement where I can specify the file name?

Thanks

-javahar

Create a Job and write T-SQL Code for Differential Backup will be great and less problem

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.|||I also have an issue with a similar setup. The report works well in VS 05, after deplying the document map displays a short list of entries, I'm unable to navigate to the bottom of the document map listing and I cannot "type ahead" as in VS environment.

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.

Different behavior between VS and IE in rendering reports with fixed headers and a document map

I apologize in advance if this is something already addressed elsewhere (if so - please point me in that direction).

I have created a really simple report that allows 'drill-down' at the group level. To this report I also selected the 'Repeat header rows on each page' and 'Header should remain visible while scrolling' features and all worked as expected after deploying.

I then added a Document Map referencing the group level and that too worked within the VS environment. VS displayed a page that contained the requested group in plain view and I could 'drill down' as expected.

But when I deployed the report and subsequently pulled it up in IE I noticed a slightly different behavior in that when selecting an entry from the document map, the start of that group got hidden behind the fixed header such that what was visible was perhaps 1 or 2 group records down. I had to scroll up to see the start of the group I had selected from the document map and then drill down from there.

Removing both the "Repeat header..." and "Header should remain ...." allows me to select a group from the document map (which is always at the top) - but in doing so I lose the fixed header feature.

Does anyone have any ideas what I am doing wrong?

Bob

I am experiencing this same problem as well. I would also like to know if there is a fix or workaround to this.|||I also have an issue with a similar setup. The report works well in VS 05, after deplying the document map displays a short list of entries, I'm unable to navigate to the bottom of the document map listing and I cannot "type ahead" as in VS environment.

Differences between 2005, 2000, and Express - documentation, whitepapers?

Can anyone point me in the direction of some NON-sales documentation on the differences between these product? I am sure, especially with Express, there are considerable functionality and architecture differences.

I've looked in BOL, and I've done searches online.

All i seem to get is sales related stuff.

I'm curious about the architecture of SQL 2005, SQL express. In 2000, there was some fairly detailed documentaiton on this subject, but 2005 BOL seems REALLY diffucult to find things.

I may just need to try different keywords...

Here is a good page for 2005: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||

Hello all, two questions that perhaps are related:

Is it a bad idea to use sqlexpress for systemtests if prod-environment is sql2005? I am using stored procs against tables, simple techniques. No fancy stuff like external functions, webservices or similar .

I have to use standard security with a sqluser but I get authorisation failure. Do I need to set sqlexpress to allow mixed mode? How do I do that?

Thanks in advance!

/Rasmus

|||

yacrumb2,

Yes, you can use SQL Express for testing; you wouldn't be able to test SQL Agent Jobs and some of the other more 'advanced' functionality. But for simple stored procedure testing, there should be no problem. However, I would recommend that your test environment closely 'match' the production environment. (Or that you use the Developer's Edition -which cost only about $50 US, and is the same as Enterprise Edition)

Any version can use SQL Authentication, just set for 'Mixed Mode' on the security tab of the Server Properties window in SSMS (or SSMSE). If you are having problems, you may wish to post the error message and how you are trying to connect so we can help you.