multiplue UI Report Tables using exact same dataset ?

Is there an easier way to manage the table UI element on the report. For
example in my report I have a table for the header info and the data, the
data uses maybe 10 columns and we could be perhapps adding more columns
(fields) to it in the future. The header uses 4 columns. It's a pain
because everytime I add a column to the main report details I have to go up
and fix the header and merge the appropriate cells to get it back to 4 cells
in the header. Is there not a way to use multiple table elements but they
both use the same dataset,. When I say same dataset, I dont mean a copy of
the same dataset, I want it to use the same dataset without the query
running twice for each table.
You guys know what I mean?
Possible ?Sorry, I'm not sure what you mean!
Is the table header a seperate table from the 'data' table?
Are they using the same dataset or not?
If the header and data are in fact seperate tables, then why are you
doing it like that, you seem to be making extra work for yourself!
If two tables use the same dataset the query would only be run once.
Chris
D Witherspoon wrote:
> Is there an easier way to manage the table UI element on the report.
> For example in my report I have a table for the header info and the
> data, the data uses maybe 10 columns and we could be perhapps adding
> more columns (fields) to it in the future. The header uses 4
> columns. It's a pain because everytime I add a column to the main
> report details I have to go up and fix the header and merge the
> appropriate cells to get it back to 4 cells in the header. Is there
> not a way to use multiple table elements but they both use the same
> dataset,. When I say same dataset, I dont mean a copy of the same
> dataset, I want it to use the same dataset without the query running
> twice for each table.
> You guys know what I mean?
> Possible ?

Multiple ToggleItems?

Hello:
I have a table, with a group that inserts group headers and details, each
header expands or collapses its details, but I'll also like the users to be
able to expand all the data with a single click.
Is it possible to have an element toggled by two different ways?
Any Ideas?
Thanks,
Daniel Bello UrizarriOn Mar 7, 10:32 am, "Daniel Bello" <dburiza...@.yahoo.es> wrote:
> Hello:
> I have a table, with a group that inserts group headers and details, each
> header expands or collapses its details, but I'll also like the users to be
> able to expand all the data with a single click.
> Is it possible to have an element toggled by two different ways?
> Any Ideas?
> Thanks,
> Daniel Bello Urizarri
You should have several options to accomplish this, if I'm
understanding you correctly. You should be able to set the whole table
to be toggled; as well as, setting a row, column or individual cells
to be toggled by one control (i.e., textbox). That said, you cannot
toggle visibility on a single cell more than one way: unless it's a
part of a larger group (mainly a row or column). Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Multiple table or matrix under one grouping

Is it possible to have multiple tables or matrixes under one header grouping. I'm having a case where two tables need to be under one grouping (like "Sports vehicle) and under that "sports vehicle" I have two very different tables and on it goes for each grouping (next one like "Off road vehicle), etc.

Is there anyway to do this. I can make this work with one table using the table grouping.

Any suggestions or ideas?

Thanks.

Enkht,

Yes, It possible to have a Matrix Group = "Sports Vehicles" and the have type of "Off road", "Soup Up", "Etc" - It believe you can achieve your results my making Sport Vehicles your Group rows and "Type of" your Group Columns.

Ham

Multiple Sections in a Report

Hi
I was wondering, I previously worked with Crystal Reports and in this
offered the functionality of Multiple Sections, in the Report Header/Footer,
Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
cannot seem to work out how to do this in SSRS, whilst building reports?
--
Kind regards
Ricky
(SS2005/SSRS2005)On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> Hi
> I was wondering, I previously worked with Crystal Reports and in this
> offered the functionality of Multiple Sections, in the Report Header/Footer,
> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> cannot seem to work out how to do this in SSRS, whilst building reports?
> --
> Kind regards
> Ricky
> (SS2005/SSRS2005)
As far as I know, in SSRS, you can only create a single header and
single footer (via the Layout view -> Report drop-down -> Page Header/
Page Footer). If you are using table/matrix controls, you are able to
use multiple group headers and footers; and using a table/matrix
control, you can have multiple detail rows. While this is not exactly
the same as in CR, it should get you by. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
Shame that this is the case, do you not think this is somewhat restricting,
I thought that MS would have been able to implement something like this
quite easily...
Perhaps SS2008, may bring some enhancements?
Kind regards
Ricky
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
>> Hi
>> I was wondering, I previously worked with Crystal Reports and in this
>> offered the functionality of Multiple Sections, in the Report
>> Header/Footer,
>> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
>> cannot seem to work out how to do this in SSRS, whilst building reports?
>> --
>> Kind regards
>> Ricky
>> (SS2005/SSRS2005)
>
> As far as I know, in SSRS, you can only create a single header and
> single footer (via the Layout view -> Report drop-down -> Page Header/
> Page Footer). If you are using table/matrix controls, you are able to
> use multiple group headers and footers; and using a table/matrix
> control, you can have multiple detail rows. While this is not exactly
> the same as in CR, it should get you by. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 24, 8:00 am, "Ricky" <r...@.msn.com> wrote:
> Hi Enrique
> Shame that this is the case, do you not think this is somewhat restricting,
> I thought that MS would have been able to implement something like this
> quite easily...
> Perhaps SS2008, may bring some enhancements?
> Kind regards
> Ricky
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> > On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> >> Hi
> >> I was wondering, I previously worked with Crystal Reports and in this
> >> offered the functionality of Multiple Sections, in the Report
> >> Header/Footer,
> >> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> >> cannot seem to work out how to do this in SSRS, whilst building reports?
> >> --
> >> Kind regards
> >> Ricky
> >> (SS2005/SSRS2005)
> > As far as I know, in SSRS, you can only create a single header and
> > single footer (via the Layout view -> Report drop-down -> Page Header/
> > Page Footer). If you are using table/matrix controls, you are able to
> > use multiple group headers and footers; and using a table/matrix
> > control, you can have multiple detail rows. While this is not exactly
> > the same as in CR, it should get you by. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I checked out the SQL Server 2008 White Papers and I haven't seen
mention of it so far; of course, it is still in Beta 1 at this point
so you never know.
Regards,
Enrique Martinez
Sr. Software Consultant
`

Multiple Row Headers/Detail?

Can't seem to figure out how to create a staggered, multi-row header and
details like below.
Header Last Name First Name
DOB City
Detail Doe John
1/1/80 San Francisco
Is this possible?
Thanks.Never mind ;) Right-clicking the icons on the left let you add/delete rows.
"Don Miller" <nospam@.nospam.com> wrote in message
news:ekoiAIAEIHA.536@.TK2MSFTNGP06.phx.gbl...
> Can't seem to figure out how to create a staggered, multi-row header and
> details like below.
> Header Last Name First Name
> DOB City
> Detail Doe John
> 1/1/80 San Francisco
> Is this possible?
> Thanks.
>