Create table groups horizontally?

Hello,
I hope this all makes sense. I need something that has the
functionality of both a table and a matrix:
- Table: drilldown into individual records
- Matrix: show one of the groups horizonally
Here's a simplified version of what I need the table/matrix to look
like. Everything, including the Quarters, are in my dataset:
_______________________________________________
QUARTER1 QUARTER2 QUARTER3
DEPARTMENT
+ Cleaner $400 $300 $200
+ Landscaper $300 $400 $300
+ Maintenance $100 $200 $100
+ Painter $200 $100 $400
_______________________________________________
When someone clicks on the + next to each department all of the records
for that department are displayed. Here is a sample of what the data
for the report could look like:
_________________________________
Joe Blow Cleaner $10 Quarter1
Joe Blow Cleaner $5 Quarter2
Jane Doe Painter $7 Quarter2
Jane Doe Painter $9 Quarter3
Josh Ho Painter $15 Quarter2
Josh Ho Painter $7 Quarter3
_________________________________
Is this possible with both dynamic Quarters and Departments? There can
be 0 to 4 quarters and many departments, the Quarters need to be
displayed Horizontally and the departments vertically, the user needs
to be able to drilldown into the individual records.
Thank you,
MichelleHi Michelle,
If I understand correctly - this is possible.
Start off with a matrix - don't use the wizard, add a group - Department -
do not use the default cell provided (delete this one) when you have added
yours - give the cell a label (properties)
Add the next group on this group - on the visibility tab - select hidden and
tick Visibility can be toggled by another report item. In the report item
combo box - select the previous group (this is the label name you gave the
first group) etc - if you close the group before setting the visibility you
won't see the label in the drop down combo - just type it in - works just as
well.
You can do this across as well.
Hope this helps.
Regards
K
<Michelle@.bwalk.com> wrote in message
news:1109267358.435207.233690@.z14g2000cwz.googlegroups.com...
> Hello,
> I hope this all makes sense. I need something that has the
> functionality of both a table and a matrix:
> - Table: drilldown into individual records
> - Matrix: show one of the groups horizonally
> Here's a simplified version of what I need the table/matrix to look
> like. Everything, including the Quarters, are in my dataset:
> _______________________________________________
> QUARTER1 QUARTER2 QUARTER3
> DEPARTMENT
> + Cleaner $400 $300 $200
> + Landscaper $300 $400 $300
> + Maintenance $100 $200 $100
> + Painter $200 $100 $400
> _______________________________________________
>
> When someone clicks on the + next to each department all of the records
> for that department are displayed. Here is a sample of what the data
> for the report could look like:
> _________________________________
> Joe Blow Cleaner $10 Quarter1
> Joe Blow Cleaner $5 Quarter2
> Jane Doe Painter $7 Quarter2
> Jane Doe Painter $9 Quarter3
> Josh Ho Painter $15 Quarter2
> Josh Ho Painter $7 Quarter3
> _________________________________
>
> Is this possible with both dynamic Quarters and Departments? There can
> be 0 to 4 quarters and many departments, the Quarters need to be
> displayed Horizontally and the departments vertically, the user needs
> to be able to drilldown into the individual records.
>
> Thank you,
> Michelle
>|||This is perfect - thank you!|||Do you happen to know if there is a way to hide the enitre columns of
the extra groups until they are made visible? I have it so that the
groups are hidden, but their columns remain so they take up extra
width, even if the groups aren't visible. Does that make sense? There
is no visibility property on the columns themselves, and judging from
some of the other posts on this forum, it may not yet be possible to
dynamically size column widths on a matrix.
Thanks!
Michelle

Create My Own Log (for functionality)

I'm calling stored procedures in a DTS package. The log file only shows that of DTS. In stored procedures I use "Print" to print out error messages the program encouters. I can see the errors when I execute a procedure in Query Analyzer, but they go nowhere when I run a DTS package.

How do I generate a myfunctionality.log with these lines?

Thanks,

LiliHi,

The best way to add Own Log functionality , is to create a log table and use insert statement to log message instead of print. The advantage will be that log will be available for future reference whereas filelog will be over written every time you run package.

best of luck

Create Login like another login...

One bit of functionality I like in Oracle's Enterprise manager, that I
haven't located in SQL Server is the ability to create a new login with all
the same rights, roles etc of an existing user.
I am using SQL Server 2005. I have tried
USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LO
GIN written by GREG LARSEN, but I ge
t
an error when executing it.
==================
Msg 213, Level 16, State 7, Line 2
Insert Error: Column name or number of supplied values does not match table
definition.
==================
Does anyone point me to a way of doing this?
PaulThat's a pretty old script you're using and it's written for SQL Server
2000, calling objects in the master database.
You can update the script using some of the security catalog views instead
of tables in master. For example, fn_my_permissions will tell you what
effective permissions the current user has.
As for the error message below, it looks like you probably had a typo
somewhere when creating or running the sproc. Probably a datatype mismatch.
joe.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CFECA19B-9C34-4D52-B9FC-1FA95817EE78@.microsoft.com...
> One bit of functionality I like in Oracle's Enterprise manager, that I
> haven't located in SQL Server is the ability to create a new login with
> all
> the same rights, roles etc of an existing user.
> I am using SQL Server 2005. I have tried
> USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LO
GIN written by GREG LARSEN, but I
> get
> an error when executing it.
> ==================
> Msg 213, Level 16, State 7, Line 2
> Insert Error: Column name or number of supplied values does not match
> table
> definition.
> ==================
> Does anyone point me to a way of doing this?
> Paul