Viewing 15 posts - 16 through 30 (of 37 total)
To me the greatest benefits are three:
1. Eliminate a hit against the SQL database. This is good for datasets that you can afford to update on a scheduled basis, such...
February 15, 2005 at 8:23 am
OK, one more thing, looking at one of my reports...
Shrink the body width down to the same width as your table. The report size should still be larger; for example,...
February 4, 2005 at 10:29 am
OK, here's another thing to watch out for...
Make sure your table width is only say, 2 inches (for example)...not the entire width of the body, because it is actually the...
February 4, 2005 at 10:09 am
Don't know if it would make a difference, but I have only created this kind of report using a table control, not the list control...have you tried it that way?
February 4, 2005 at 9:48 am
You don't need to do any special calculations. Go to properties for the Body element of report and set the number of colums...that should be all that's required.
Keep in mind snaking...
February 4, 2005 at 7:55 am
I have seen this happen to DTS packages stored in SQL Server if the DTS package was created or modified using the SQL 2000 version of Enterprise Manager and you try to open it...
January 28, 2005 at 7:54 am
I have used the following procedure to successfully test a disaster recovery scenario:
1. Back up the ReportServer database in SQL as you would normally back up any SQL db.
December 30, 2004 at 8:03 am
Try shrinking down the "white space" in the Body element of the report as small as possible. This can be done by clicking-and-dragging, or through the Size (Width, Height) properties of the...
December 14, 2004 at 7:27 am
I have used the following procedure to successfully convert a server and all existing user databases from a Case-Sensitive to a Case-Insensitive collation. Merely running the rebuildm utility will not...
September 15, 2004 at 7:49 am
I have also seen this kind of error pop up in other contexts when the NT account has been locked. You may want to check that as well.
September 14, 2004 at 8:59 am
Read the topic, "Writing Custom Code," and related topics, in the Reporting Services Books Online. You can create a custom assembly for this functionality. You can do this if you have...
August 16, 2004 at 2:18 pm
This would accomplish part (not all) of your goal...but it's free. In Enterprise Manager, open a table in your database in a grid (Open Table -> Return all rows), then click the...
July 1, 2004 at 8:37 am
How about DTS packages, stored procs, views, etc. that were created in 7? Are there any special considerations there?
June 17, 2004 at 7:26 am
Brian and stacenic, I certainly appreciate the info and the link. I will post back here if I encounter any questions.
March 30, 2004 at 12:44 pm
That may be helpful paring down the amount of data in the trace, as I am down to maybe 1 to 5 deadlock events occurring a day on this fairly...
March 30, 2004 at 11:29 am