Matrix 'Total' formatting

Hey All,
Maybe I have been looking in the wrong places for the last 2 hours but
can someone tell me how to add a borderstyle property to the 'subtotal'
row on a matrix. I can get it to work for the 'total' textbox itself
but not the entire row. I have even looked in the XML (which I never
miss with) and still cannot find anything. Please! Please! Someone help
me! This is for a client. Even if it cannot be done, let me know!!!!
Thanks in advance a billion times over,
KerrieJust click once on the row field then go to view and click properties
window. You can change the borderstyle there to solid. You can do that on
any column or row or just one field.
"Kerrie" <ksorrell@.cincom.com> wrote in message
news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||Ben,
I have tried that and for some reason it will only do it for the Total
testbox, not the whole row. It is driving me nuts. I am not sure where
to go from here.
Thanks for your help though, it is greatly appreciated!
Thanks, Kerrie
Ben Watts wrote:
> Just click once on the row field then go to view and click properties
> window. You can change the borderstyle there to solid. You can do that on
> any column or row or just one field.
> "Kerrie" <ksorrell@.cincom.com> wrote in message
> news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >|||You need to right-click on the little green triangle at the top right-hand
corner of the total textbox to get to the properties of the actual total.
HTH,
magendo_man
"Kerrie" wrote:
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||YOU ARE THE GREATEST!!!!!!
THANK YOU! THANK YOU!
It worked!!!!!!
Thanks, Kerrie
magendo_man wrote:
> You need to right-click on the little green triangle at the top right-hand
> corner of the total textbox to get to the properties of the actual total.
> HTH,
> magendo_man
> "Kerrie" wrote:
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >
> >

matrix showing wrong totals

Going bonkers here. I have a matrix that displays total referrals by month
for the year. Two months, Feb and April are off by 1 when I view the matrix,
but other months show correct amt. when just doing a simple query with same
criteria, the dataset is correct. I've looked at the data countless times
but cannot deterine where the issue is. Possible matrix problem? anyone seem
results llike this?
HELP!more food for thought. I changed the query a bit. rather than selecting all
companies who referred to us, I selected just one. Results were accurate with
just one referrer. I'm still perplexed though...
"Brian L" wrote:
> Going bonkers here. I have a matrix that displays total referrals by month
> for the year. Two months, Feb and April are off by 1 when I view the matrix,
> but other months show correct amt. when just doing a simple query with same
> criteria, the dataset is correct. I've looked at the data countless times
> but cannot deterine where the issue is. Possible matrix problem? anyone seem
> results llike this?
> HELP!|||are you using olap or relational?
sounds like a standard olap situation where you need to write some
crazy-ass MDX statement
-Aaron
Brian L wrote:
> more food for thought. I changed the query a bit. rather than selecting all
> companies who referred to us, I selected just one. Results were accurate with
> just one referrer. I'm still perplexed though...
> "Brian L" wrote:
> > Going bonkers here. I have a matrix that displays total referrals by month
> > for the year. Two months, Feb and April are off by 1 when I view the matrix,
> > but other months show correct amt. when just doing a simple query with same
> > criteria, the dataset is correct. I've looked at the data countless times
> > but cannot deterine where the issue is. Possible matrix problem? anyone seem
> > results llike this?
> >
> > HELP!

Matrix report, date: 1900-01-01 wrong!! Suppose to be empty, how?

Hi

I am making a report in Visual Studio. I’m making a matrix report. I have made a UNION of 2 tables. One of them has a field called Date and the other one does not. But to make a UNION of these 2 tables so that the results are printed in a Matrix I have to have the same fields’ aliases at least. So what I did is that in the second table is:

SELECT ‘ ‘ AS ‘Date’

Right?

Now, in the report the first table gives me the dates in a format:

=Format(Fields!Estimated_Close_Date.Value, "yyyy-MM-dd")

But, the second table is it doesn’t have a date in that field when I run the report it gives me:

1900-01-01

Something I don’t want.

So, how do I make it understand that the second tables date field is suppose to be empty?

Try something like this:

SELECT myDate AS DATE FROM MyTable

UNION ALL

SELECT CASE WHEN myBlankField = ' ' THEN ' ' ELSE ' ' END FROM OtherTable

And choose a field that is NOT a date for myBlankField. This will put blanks in the result set, but you can always just filter those out later.

|||

Thanks for your quick answer, sounds interesting, but I don't know quite where to put your example. Here's the code I have, maybe you know.

SELECT estimatedclosedate AS 'Date', blablabla...

INTO TempTable1

FROM blablabla join blabla and so on

WHERE blablabla AND blabla AND blabla and so on

SELECT ' ' AS 'Date', blablabla... -- This is the date that is troubling me

INTO TempTable2

FROM blablabla join blabla and so on

WHERE blablabla AND blabla AND blabla and so on

SELECT * FROM TempTable1

UNION

SELECT * FROM TempTable2

The TempTable1 gives me Opportunities from a CRM system, the TempTable2 gives me Ongoing Business in the CRM system. Of course, Opportunities have an estimated close date and Ongoing Business has not … so I just want it to show an empty cell in the matrix report.

So, where exactly could I put your suggestion?

|||

try -- select null as 'Date'., xyz........into temptable

Priyank

|||

Worked perfectly!!! Thanks mate!!!|||

can you please mark it as answer...|||

By the way ... do you know anything about my other thread I have here? About putting a tooltip window thing on one of my filters? One of my filters is done that the user can write what ever he wishes to filter on, either exactly or even with a % ... the thing is that I don't want to write on the Prompt: "Tradelane (STO-LAX, or STO%, or %STO) ... it's just to long ... do you happen to know how?

|||Mark it as answer? DONE!!

master.INFORMATION_SCHEMA.SCHEMATA

Is is just me or does this query produce the wrong results?
SELECT CATALOG_NAME FROM master.INFORMATION_SCHEMA.SCHEMATA
I have a MSDE sp3a installation, and this query does not include my user
database in the resut set.
hi,
Wozza wrote:
> Is is just me or does this query produce the wrong results?
> SELECT CATALOG_NAME FROM master.INFORMATION_SCHEMA.SCHEMATA
> I have a MSDE sp3a installation, and this query does not include my
> user database in the resut set.
yes... it seems to work only when running in the user's database context,
and only for the specifi user's database..
CREATE DATABASE a
CREATE DATABASE b
if run on "b" database context it returns
USE b
SELECT CATALOG_NAME FROM master.INFORMATION_SCHEMA.SCHEMATA
CATALOG_NAME
master
tempdb
model
msdb
b
(5 row(s) affected)
seems to be a problem in the
WHERE
a_cha.type = 1001 -- type is charset
AND a_cha.id = convert(tinyint, DatabasePropertyEx(db.name, 'sqlcharset'))
filter of the view,
select
db.name as CATALOG_NAME
,USER_NAME() as SCHEMA_NAME
,USER_NAME() as SCHEMA_OWNER
,convert(sysname, NULL) as DEFAULT_CHARACTER_SET_CATALOG
,convert(sysname, NULL) as DEFAULT_CHARACTER_SET_SCHEMA
,a_cha.name as DEFAULT_CHARACTER_SET_NAME
FROM
master.dbo.sysdatabases db,
master.dbo.syscharsets a_cha --charset/1001, not sortorder.
WHERE
a_cha.type = 1001 -- type is charset
AND a_cha.id = convert(tinyint, DatabasePropertyEx(db.name, 'sqlcharset'))
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||ok... SQL Server MVP Jasper Smith expanded this reporting it a a "known
issue" of that ANSI view, depending on the autoclose property (default on
MSDE) of the database(s), that causes them to not appear in the
INFORMATION_SCHEMA.SCHEMATA view
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply