Crystal designer features I can't find in SSRS

Coming from a Crystal background, I was assessing SSRS 2005 and ran into
two things I know will generate a lot of pushback from my coworkers. In
Crystal you can place group heading fields anywhere you want in a group
band, where as grouping appears to be accomplished in SSRS by consuming
an entire table column. I suppose I could fake it by making the detail
of the main report contain my grouping data and render the detail with a
sub-report, but that's overkill for such a common formatting feat.
Example (note the horizontal positioning of the group field):
Crystal lets us do this:
Group1
Detail1 Detail2 Detail3 Detail4
SSRS tables require me to group like this:
Group1
Detail1 Detail2 Detail3 Detail4
I would be thrilled if I'm just overlooking something obvious and you
can place a group heading anywhere you want.
Also, we recreate paper forms in some reports (invoices, POs, etc.) and
positioning of drawn lines and text is *much* easier when you zoom in
with the designer to 200%. I didn't see how to do this in SSRS
designer, what am I missing?
RobYou can always drag a field to be displayed on the group heading. infact
Group heading can be merged as well. So your way of empty column is avoided.
On the designer there is no Zooming but on the output you can zoom. So
basically WYSIWYG format on the designer.
Amarnath
"Rob Gamble" wrote:
> Coming from a Crystal background, I was assessing SSRS 2005 and ran into
> two things I know will generate a lot of pushback from my coworkers. In
> Crystal you can place group heading fields anywhere you want in a group
> band, where as grouping appears to be accomplished in SSRS by consuming
> an entire table column. I suppose I could fake it by making the detail
> of the main report contain my grouping data and render the detail with a
> sub-report, but that's overkill for such a common formatting feat.
> Example (note the horizontal positioning of the group field):
> Crystal lets us do this:
> Group1
> Detail1 Detail2 Detail3 Detail4
>
> SSRS tables require me to group like this:
> Group1
> Detail1 Detail2 Detail3 Detail4
>
> I would be thrilled if I'm just overlooking something obvious and you
> can place a group heading anywhere you want.
> Also, we recreate paper forms in some reports (invoices, POs, etc.) and
> positioning of drawn lines and text is *much* easier when you zoom in
> with the designer to 200%. I didn't see how to do this in SSRS
> designer, what am I missing?
>
> Rob
>

CROSSTAB QUERY FROM ACCESS TO SQL

Hello,
I'm quite basically new to working with SQL databases, coming from a
Microsoft Access background. As we've got the SQL server sitting here,
I've been asked to get the MS Access db's moved across onto it. I've
had no problem with the tables, but as the majority of the reporting
comes from cross tab queries I'm having trouble getting started with
the design of a cross tab/pivot view. I've tried all the examples the
search on groups provided but I'm having a hard time making it work for
me.
I'm reporting off one table tblMONTHCOSTS, the data at the moment is
displayed as
txtMOBILE NO txtBILLMONTH curCALLCOST
078******** 200501 15.25
077******* 200501 12.54
078******** 200502 9.54
077******* 200502 10.55
And so on...... For 12 months, for 39 mobile phones.
What I want it to do is display like this :
txtMOBILE NO 200501 200502 200503......
078******** 15.25 9.54
077******* 12.54 10.55
Does anyone have any advice on how this can be done? I know I'm
pretty new to this so if you could even just point me in the direction
of a good book I would be very grateful.
ThanksRefer this
http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx
Madhivanan