Matrix Rendering Problem?

Hello,
I have a matrix rendering problem that drives me crazy. Can't figure out
what it is for a couple of days. The problem is illlustrated below - note
that starting from "Min Value" all matrix rows are shifted down. "Max Time"
row shows minimum values, "Max Value" row shows time of maximum values, and
maximum values are displayed in the extra row that does not exist at all. The
strange thing is that this only happens when report is rendered as HTML via
url access. It works just fine in the Report Designer (both Preview and Debug
Local), and it renders correctly if exported to a different format such as
PDF or IMAGE. If anyone knows how to fix this, please advise. Thanks in
advance.
M T
W
Depth Vel Quant Depth Vel Quant Depth
Vel Quant
Total 0.255 0.239
0.232
Avg 2.85 1.88 0.255 2.79 1.83 0.239 2.74
1.82 0.232
Min Time 5:30 4:30 4:30 3:00 5:15 5:15 5:15 2:45
2:45
Min Value
Max Time 1.66 0.50 0.033 1.66 0.51 0.032 1.63 0.49
0.033
Max Value 17:00 20:15 20:15 9:45 9:45 9:45 8:30 7:30
9:15
3.77 2.53 0.449 3.77 2.23 0.410 3.65
2.32 0.384
--
Regards,
Alex Korygin.Sorry for the formatting. Hopefully this one will show better.
M T W
Depth Vel Quant Depth Vel Quant Depth Vel Quant
Total 0.255 0.239 0.232
Avg 2.85 1.88 0.255 2.79 1.83 0.239 2.74 1.82 0.232
Min Time 5:30 4:30 4:30 3:00 5:15 5:15 5:15 2:45 2:45
Min Value
Max Time 1.66 0.50 0.033 1.66 0.51 0.032 1.63 0.49 0.033
Max Value 17:00 20:15 20:15 9:45 9:45 9:45 8:30 7:30 9:15
3.77 2.53 0.449 3.77 2.23 0.410 3.65 2.32 0.384
"Alex Korygin" wrote:
> Hello,
> I have a matrix rendering problem that drives me crazy. Can't figure out
> what it is for a couple of days. The problem is illlustrated below - note
> that starting from "Min Value" all matrix rows are shifted down. "Max Time"
> row shows minimum values, "Max Value" row shows time of maximum values, and
> maximum values are displayed in the extra row that does not exist at all. The
> strange thing is that this only happens when report is rendered as HTML via
> url access. It works just fine in the Report Designer (both Preview and Debug
> Local), and it renders correctly if exported to a different format such as
> PDF or IMAGE. If anyone knows how to fix this, please advise. Thanks in
> advance.
> M T
> W
> Depth Vel Quant Depth Vel Quant Depth
> Vel Quant
> Total 0.255 0.239
> 0.232
> Avg 2.85 1.88 0.255 2.79 1.83 0.239 2.74
> 1.82 0.232
> Min Time 5:30 4:30 4:30 3:00 5:15 5:15 5:15 2:45
> 2:45
> Min Value
> Max Time 1.66 0.50 0.033 1.66 0.51 0.032 1.63 0.49
> 0.033
> Max Value 17:00 20:15 20:15 9:45 9:45 9:45 8:30 7:30
> 9:15
> 3.77 2.53 0.449 3.77 2.23 0.410 3.65
> 2.32 0.384
>
> --
> Regards,
> Alex Korygin.

Master.dbf restore problems.

Over the weekend we did a hardware upgrade to our DB
server and some drives did change. We have setup most of
the DB back again, but the security is still in the
master.mdf file. If we restore this file back we will
loose everything that is working now. anyone know how to
export the security tables without blowing everything away
again.
ThanksAlex,
That is a situation where it really pays to test first<g>. Here are some
links that may be of interest:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
Andrew J. Kelly
SQL Server MVP
"Alex" <alex.chadwick@.cma.ca> wrote in message
news:032a01c33f37$3aa37d50$a101280a@.phx.gbl...
> Over the weekend we did a hardware upgrade to our DB
> server and some drives did change. We have setup most of
> the DB back again, but the security is still in the
> master.mdf file. If we restore this file back we will
> loose everything that is working now. anyone know how to
> export the security tables without blowing everything away
> again.
> Thanks