Calling Webservice: span

Showing posts with label span. Show all posts

Sunday, March 11, 2012

Can fields span TableGroups independantly of columns

Hi,

I'm trying to add a heading to my report using Table and TableGroups. But I don't want my group headings to line up with the detail rows. This seems like a common requirement in my mind but I can't figure out how to do it.

See made up example of a report below:

Person Name Address <-Report header

Area: A12 3BC, Newtown, Someplace <-TableGroup header

Mr Some Body 1 The Street <-Detail rows

Mrs Anne Other 2 The Street

Area: B23 4CD, Oldtown, Someplace <-TableGroup header

Mr Ran Dom 3 The Avenue <-Detail rows

So the TableGroup displays Area which is grouped by Post code, city etc.

The detail rows displays individual people and their street address.

NOTE: The Area fields do not line up with the Person fields in fact they overlap how can I do this in SSRS?

Thanks in advance for your help,

Mike G

I've found out how to do this now...

You need to have a single column in the table that spans the whole width of the report, (as opposed to having one column in the table control for each field)

Then add rectangle controls to each of the cells (Report header, table group headers and details etc.)

Then you can add textbox controls onto the rectangle controls and put them where you like within the cell.

It's a shame you have to do it this way because you loose the nice feature that lines up the details columns with the labels you've added in the report heading.

Hope that all makes sense, it's difficult to explain graphical layout issues in text!

-MIke G

|||

have you tried the list control?

Can fields span TableGroups independantly of columns

Hi,

See made up example of a report below:

Person Name Address <-Report header

Area: A12 3BC, Newtown, Someplace <-TableGroup header

Mr Some Body 1 The Street <-Detail rows

Mrs Anne Other 2 The Street

Area: B23 4CD, Oldtown, Someplace <-TableGroup header

Mr Ran Dom 3 The Avenue <-Detail rows

So the TableGroup displays Area which is grouped by Post code, city etc.

The detail rows displays individual people and their street address.

NOTE: The Area fields do not line up with the Person fields in fact they overlap how can I do this in SSRS?

Thanks in advance for your help,

Mike G

I've found out how to do this now...

You need to have a single column in the table that spans the whole width of the report, (as opposed to having one column in the table control for each field)

Then add rectangle controls to each of the cells (Report header, table group headers and details etc.)

Then you can add textbox controls onto the rectangle controls and put them where you like within the cell.

It's a shame you have to do it this way because you loose the nice feature that lines up the details columns with the labels you've added in the report heading.

Hope that all makes sense, it's difficult to explain graphical layout issues in text!

-MIke G

|||

have you tried the list control?

Can fields span TableGroups independantly of columns

Hi,

See made up example of a report below:

Person Name Address <-Report header

Area: A12 3BC, Newtown, Someplace <-TableGroup header

Mr Some Body 1 The Street <-Detail rows

Mrs Anne Other 2 The Street

Area: B23 4CD, Oldtown, Someplace <-TableGroup header

Mr Ran Dom 3 The Avenue <-Detail rows

So the TableGroup displays Area which is grouped by Post code, city etc.

The detail rows displays individual people and their street address.

NOTE: The Area fields do not line up with the Person fields in fact they overlap how can I do this in SSRS?

Thanks in advance for your help,

Mike G

I've found out how to do this now...

You need to have a single column in the table that spans the whole width of the report, (as opposed to having one column in the table control for each field)

Then add rectangle controls to each of the cells (Report header, table group headers and details etc.)

Then you can add textbox controls onto the rectangle controls and put them where you like within the cell.

It's a shame you have to do it this way because you loose the nice feature that lines up the details columns with the labels you've added in the report heading.

Hope that all makes sense, it's difficult to explain graphical layout issues in text!

-MIke G

|||have you tried the list control?

Saturday, February 25, 2012

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

I have really had enough of Dell's PERC/3 DC controllers.
Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
Secondly they are just very slow even on a plain stripe.
We paid top dollar for these a couple of years ago but they are really
holding our SQL Server back. We have 24 15k U320 disks and three controllers
and wanted the best, safest solution.
ie Raid 10.
Any controller recommendations?
Thanks
PaulWe used such controlled, moved to EMC/Dell CX300.
"Paul Cahill" wrote:
> I have really had enough of Dell's PERC/3 DC controllers.
> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
> Secondly they are just very slow even on a plain stripe.
> We paid top dollar for these a couple of years ago but they are really
> holding our SQL Server back. We have 24 15k U320 disks and three controllers
> and wanted the best, safest solution.
> ie Raid 10.
> Any controller recommendations?
> Thanks
> Paul
>
>|||I'd love to go down this route but it's not a financial option to ditch the
24 scsi drives (and the powervaults).
At this point replacing the Perc3/DCs is the only possibility.
Paul
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
> We used such controlled, moved to EMC/Dell CX300.
> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>|||Dell has the Perc4's out. They are all based on the Adaptec controller.
With 24 drives, unless you use Fiber, you won't get much faster performance.
SCSI is rather slow over copper.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Cahill" <noname@.anon.com> wrote in message
news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'd love to go down this route but it's not a financial option to ditch
> the 24 scsi drives (and the powervaults).
> At this point replacing the Perc3/DCs is the only possibility.
> Paul
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>|||When we bought the Perc3/dcs we thought 3 dual channel controllers would be
OK. We didn't realise they cannot do true raid 10.
Many of our disks are not being hit as the raid 10 arrays are span of
mirrors not a stripe. I built most of the arrays as a set of four and one
set of six.
eg the log file is on a raid 10 set of 4 18Gb 15k drives but only two lights
flash because the log is smaller than 18gb. If it was a stripe of mirrors
all four lights would flash.
Any idea if the perc4 does true raid 10.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23HgnHJ1cFHA.612@.TK2MSFTNGP12.phx.gbl...
> Dell has the Perc4's out. They are all based on the Adaptec controller.
> With 24 drives, unless you use Fiber, you won't get much faster
> performance. SCSI is rather slow over copper.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Cahill" <noname@.anon.com> wrote in message
> news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
>> I'd love to go down this route but it's not a financial option to ditch
>> the 24 scsi drives (and the powervaults).
>> At this point replacing the Perc3/DCs is the only possibility.
>> Paul
>> "andsm" <andsm@.discussions.microsoft.com> wrote in message
>> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>>
>

Sunday, March 11, 2012

Can fields span TableGroups independantly of columns

Can fields span TableGroups independantly of columns

Can fields span TableGroups independantly of columns

Saturday, February 25, 2012

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

Calling Webservice

Blog Archive

About Me