Combining Cross-Tab and charts

Dear all,
I'm a noob to SQL Reporting Services but have plenty of experience with
other MS applications (including excel and access). I was wondering whether
it's possible to combine a cross-tab and a chart within a single report. If
so, how do you do this? I believe the power of a report (often) exists out of
numbers combined with a graphical display.
thanks in advance,
mischaOn Apr 26, 10:22 am, mischa <mis...@.discussions.microsoft.com> wrote:
> Dear all,
> I'm a noob to SQL Reporting Services but have plenty of experience with
> other MS applications (including excel and access). I was wondering whether
> it's possible to combine a cross-tab and a chart within a single report. If
> so, how do you do this? I believe the power of a report (often) exists out of
> numbers combined with a graphical display.
> thanks in advance,
> mischa
If I understand you correctly, you should be able to use a matrix
control and a chart control.
Regards,
Enrique Martinez
Sr. Software Consultant

Combined Chart (One series with Line and One Bar)

Is it possible to create combined charts with the Report Designer Chart?
I want to have one series charted as bar (sales) and the other series as
line (i.e market share).
Want to do it in one chart (not to overlay one chart over the other)
Thanx.Please read this related newsgroup posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c229b25c-b2dc-41ac-923d-decbb253dc6e&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Minas Papageorgiou" <MinasPapageorgiou@.discussions.microsoft.com> wrote in
message news:8AD71606-450E-4E5D-B4DD-12CA9A4A49C5@.microsoft.com...
> Is it possible to create combined charts with the Report Designer Chart?
> I want to have one series charted as bar (sales) and the other series as
> line (i.e market share).
> Want to do it in one chart (not to overlay one chart over the other)
> Thanx.
>

Combine multiple RDL files into one RDL file

Hello,

I need to generate a report, which should display 4 reports. Two tables and some charts. I have all these reports (I mean the .RDL files) individually. I can render the reports separately. But, now the need is to combine these reports in the one RDL file. Is this possible? If yes, how?

Also, I tried to create a stored procedure, which would call all these 4 SP inturn and provide 4 result sets. I thought of have an RDL by calling only this SP which would give 4 result sets. But infortunately, it gave only the first SP's result set. So, I have to combine the 4 RDL files into one to show on the Reporting Console. Can anyone please help me in this? Help would be grately appreciated.

Thanks a lot. Let me know if the question is not clear.

Mannu.

Well let's see.

You would need to create 4 datasets, one for each of the original reports. You can do this on the data tab by clicking the dataset drop down and Add new dataset.

Then, copy and paste each of the individual layouts into this "super" report.

On each of the tables and charts, go to the properties for the table or chart and select the appropriate dataset as the "dataset name" that you created.

|||

Yes GregSQL gives you right approach for the problem but there is a catch.

If you create 4 datasets using same SP that will still give you the first resultset. To overcome this issue I believe you have to pass an extra parameter say ReportType with datatype as Char. Give a condition in SP to return the Dataset you want to return for that perticular ReportType.

IN StoredProcedure:

IF @.ReportType = 'A'

BEGIN

YOUR DATASET

END

IF @.ReportType = 'B'

BEGIN

YOUR DATASET

END

Comming to report , click on each Dataset and go to Parameters section and give the ReportType value for each dataresult.'A' for First Dataset, 'B' for Second Datset.

I think this will complete the whole scenario...

Hope this helps

Combination charts issues

I have created a chart to chart a combinational chart including a
stacked column and the continous line charts.
But the problem is this combinational chart nowhere looks like the
Excel combinational chart for the same data as in the reporting
services report. Not sure if this is a problem in the RS charting
engine.
How do I create a stacked column and a continous like chart.
Thanks
KarenHi Karen
So far, I didn't find anything where you can mix charttypes. The only thing
is, you can define a Series to be drawn as a line. You can set that in the
properties of a value on the second tab there's a checkbox for that.
HTH
Luzia
<karenmiddleol@.yahoo.com> schrieb im Newsbeitrag
news:1131399473.731448.325340@.g49g2000cwa.googlegroups.com...
>I have created a chart to chart a combinational chart including a
> stacked column and the continous line charts.
> But the problem is this combinational chart nowhere looks like the
> Excel combinational chart for the same data as in the reporting
> services report. Not sure if this is a problem in the RS charting
> engine.
> How do I create a stacked column and a continous like chart.
> Thanks
> Karen
>|||Hi Luzia
I even dropped setting a combination chart of line and stacked column
instead I set multiple series all line graphs. The charts generated are
nowhere comparable to what I get in Excel not sure what is wrong.
I am frustrated.
Thanks
Karen

Colors in Charts

Hi Ng,
I was wondering if there is a way to change the colors of the bars in a
chart. Or the colors of the pieces in a cake chart?
Thank in Advance
G. SchmelzerYou can control this from Chart properties dialog -> Data tab -> Values ->
Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
button -> Fill tab.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Georg Schmelzer" <asdf@.adsf.de> wrote in message
news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Hi Ng,
> I was wondering if there is a way to change the colors of the bars in a
> chart. Or the colors of the pieces in a cake chart?
> Thank in Advance
> G. Schmelzer
>|||Note: this will require SP1 installed on clients (report designer) and
report server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> You can control this from Chart properties dialog -> Data tab -> Values ->
> Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
> button -> Fill tab.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > Hi Ng,
> >
> > I was wondering if there is a way to change the colors of the bars in a
> > chart. Or the colors of the pieces in a cake chart?
> >
> > Thank in Advance
> >
> > G. Schmelzer
> >
> >
>|||Thank You.
The specified color on the "fill tab" is used for all chart items (f.e. all
bars, cake pieces, etc...). Let's say I want to change the color of bar1 to
red, bar2 to green and bar3 to pink. I would be like a user designed
"palette". But I found no information wether or how I can do this. Any Idea?
Thanks in advance
G. Schmelzer
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> Note: this will require SP1 installed on clients (report designer) and
> report server.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > You can control this from Chart properties dialog -> Data tab ->
Values ->
> > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series Style...
> > button -> Fill tab.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > Hi Ng,
> > >
> > > I was wondering if there is a way to change the colors of the bars in
a
> > > chart. Or the colors of the pieces in a cake chart?
> > >
> > > Thank in Advance
> > >
> > > G. Schmelzer
> > >
> > >
> >
> >
>|||Write an expression for Fill Color. You could use Choose() function:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Georg Schmelzer" <asdf@.adsf.de> wrote in message
news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Thank You.
>
> The specified color on the "fill tab" is used for all chart items (f.e.
all
> bars, cake pieces, etc...). Let's say I want to change the color of bar1
to
> red, bar2 to green and bar3 to pink. I would be like a user designed
> "palette". But I found no information wether or how I can do this. Any
Idea?
> Thanks in advance
> G. Schmelzer
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > Note: this will require SP1 installed on clients (report designer) and
> > report server.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
message
> > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > You can control this from Chart properties dialog -> Data tab ->
> Values ->
> > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
Style...
> > > button -> Fill tab.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > Hi Ng,
> > > >
> > > > I was wondering if there is a way to change the colors of the bars
in
> a
> > > > chart. Or the colors of the pieces in a cake chart?
> > > >
> > > > Thank in Advance
> > > >
> > > > G. Schmelzer
> > > >
> > > >
> > >
> > >
> >
> >
>|||It worked out fine.
Thanks a lot to you guys!!!
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> schrieb im
Newsbeitrag news:%23GTGGNoeEHA.2396@.TK2MSFTNGP11.phx.gbl...
> Write an expression for Fill Color. You could use Choose() function:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > Thank You.
> >
> >
> > The specified color on the "fill tab" is used for all chart items (f.e.
> all
> > bars, cake pieces, etc...). Let's say I want to change the color of bar1
> to
> > red, bar2 to green and bar3 to pink. I would be like a user designed
> > "palette". But I found no information wether or how I can do this. Any
> Idea?
> >
> > Thanks in advance
> >
> > G. Schmelzer
> >
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> > Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > Note: this will require SP1 installed on clients (report designer) and
> > > report server.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
> message
> > > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > > You can control this from Chart properties dialog -> Data tab ->
> > Values ->
> > > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
> Style...
> > > > button -> Fill tab.
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi Ng,
> > > > >
> > > > > I was wondering if there is a way to change the colors of the bars
> in
> > a
> > > > > chart. Or the colors of the pieces in a cake chart?
> > > > >
> > > > > Thank in Advance
> > > > >
> > > > > G. Schmelzer
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi Ng,
I was wondering if there is a way to change the orientation of headings on
X-axis of a chart from horizontal to vertical?
Please reply on this site or at the foll: email id : sp_kamath@.hotmail.com
Thank in Advance
SPK|||In RS 2000 the orientation of x-axis labels is determined automatically
based on the amount of space available. If labels cannot be drawn
horizontally in one line, and also not in two lines, they will be rotated
by -90 degrees.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SanjayK" <SanjayK@.discussions.microsoft.com> wrote in message
news:F876F44C-CEA6-4D90-9A73-A9C6721A563D@.microsoft.com...
> Hi Ng,
> I was wondering if there is a way to change the orientation of headings
on
> X-axis of a chart from horizontal to vertical?
> Please reply on this site or at the foll: email id : sp_kamath@.hotmail.com
> Thank in Advance
> SPK
>|||Hi Ng,
I was wondering if there is a way to display headings on Z axis of graph
since I am not getting any headings on this axis.
Please reply to this post or mail me at sp_kamath@.hotmail.com
Thank in Advance
Sanjay K|||Headings on the Z-axis are not available. You may want to look into using
the legend to provide a description for the series along the Z-axis.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SanjayK" <SanjayK@.discussions.microsoft.com> wrote in message
news:596FB267-23AE-4D98-A399-B5C76AF50000@.microsoft.com...
> Hi Ng,
> I was wondering if there is a way to display headings on Z axis of graph
> since I am not getting any headings on this axis.
> Please reply to this post or mail me at sp_kamath@.hotmail.com
> Thank in Advance
> Sanjay K
>|||Hi,
Even i want different bars to have customized colors but i am unable to set
it. Ravi has asked to use choose function.But i am unable to use it. please
let me know how to use it. You can mail me at kiran_nandedkar@.rediffmail.com
or reply at same post
Thanks in advance
Kiran
"Georg Schmelzer" wrote:
> It worked out fine.
> Thanks a lot to you guys!!!
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> schrieb im
> Newsbeitrag news:%23GTGGNoeEHA.2396@.TK2MSFTNGP11.phx.gbl...
> > Write an expression for Fill Color. You could use Choose() function:
> >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctchoose.asp.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > news:%239AdRUheEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > Thank You.
> > >
> > >
> > > The specified color on the "fill tab" is used for all chart items (f.e.
> > all
> > > bars, cake pieces, etc...). Let's say I want to change the color of bar1
> > to
> > > red, bar2 to green and bar3 to pink. I would be like a user designed
> > > "palette". But I found no information wether or how I can do this. Any
> > Idea?
> > >
> > > Thanks in advance
> > >
> > > G. Schmelzer
> > >
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
> > > Newsbeitrag news:eqd%23A6KeEHA.592@.TK2MSFTNGP11.phx.gbl...
> > > > Note: this will require SP1 installed on clients (report designer) and
> > > > report server.
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
> > message
> > > > news:%23%23UP63JeEHA.1692@.tk2msftngp13.phx.gbl...
> > > > > You can control this from Chart properties dialog -> Data tab ->
> > > Values ->
> > > > > Edit... -> Edit Chart Value dialog -> Appearance tab -> Series
> > Style...
> > > > > button -> Fill tab.
> > > > >
> > > > > --
> > > > > Ravi Mumulla (Microsoft)
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > > "Georg Schmelzer" <asdf@.adsf.de> wrote in message
> > > > > news:e9XCdDGeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > > > Hi Ng,
> > > > > >
> > > > > > I was wondering if there is a way to change the colors of the bars
> > in
> > > a
> > > > > > chart. Or the colors of the pieces in a cake chart?
> > > > > >
> > > > > > Thank in Advance
> > > > > >
> > > > > > G. Schmelzer
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Color of pens in Line chart ?

Hi,
how can I change the line color in line charts ?
RitchieTry:
Chart Properties > Tab Data > Edit Value > Tab Appearance
"Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
news:898D80BA-E315-4A1E-9D39-2463CBDCE482@.microsoft.com...
> Hi,
> how can I change the line color in line charts ?
> Ritchie|||Hi Mónica,
does this menue item also exists on a .NET 2003 Version ?
I do not saw any configured of the color for each pen ?
Ritchie
"Mónica" wrote:
> Try:
> Chart Properties > Tab Data > Edit Value > Tab Appearance
>
>
> "Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
> news:898D80BA-E315-4A1E-9D39-2463CBDCE482@.microsoft.com...
> > Hi,
> >
> > how can I change the line color in line charts ?
> >
> > Ritchie
>
>|||Ummm, I don´t know. I´m using .NET 2005.
I´m sorry I can´t help you :-(
"Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
news:04F4DEFE-A23D-420F-A30F-4EAB93C52307@.microsoft.com...
> Hi Mónica,
> does this menue item also exists on a .NET 2003 Version ?
> I do not saw any configured of the color for each pen ?
> Ritchie
> "Mónica" wrote:
>> Try:
>> Chart Properties > Tab Data > Edit Value > Tab Appearance
>>
>>
>> "Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
>> news:898D80BA-E315-4A1E-9D39-2463CBDCE482@.microsoft.com...
>> > Hi,
>> >
>> > how can I change the line color in line charts ?
>> >
>> > Ritchie
>>|||Thanks for your help anyway..
Ritchie
"Mónica" wrote:
> Ummm, I don´t know. I´m using .NET 2005.
> I´m sorry I can´t help you :-(
>
> "Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
> news:04F4DEFE-A23D-420F-A30F-4EAB93C52307@.microsoft.com...
> > Hi Mónica,
> >
> > does this menue item also exists on a .NET 2003 Version ?
> >
> > I do not saw any configured of the color for each pen ?
> >
> > Ritchie
> >
> > "Mónica" wrote:
> >
> >> Try:
> >>
> >> Chart Properties > Tab Data > Edit Value > Tab Appearance
> >>
> >>
> >>
> >>
> >> "Ritchie" <Ritchie@.discussions.microsoft.com> escribió en el mensaje
> >> news:898D80BA-E315-4A1E-9D39-2463CBDCE482@.microsoft.com...
> >> > Hi,
> >> >
> >> > how can I change the line color in line charts ?
> >> >
> >> > Ritchie
> >>
> >>
> >>
>
>

color combinations

Where can I find some good looking examples of reports and charts that
showcase good looking design practices (my efforts leave a lot to be
desired:). I can find lots of examples for FrontPage and PowerPoint,
anything out there for SSRS?
TIA
deanHi Dean,
I'll preface this by saying that following comments are just my arrogant
opinion... good report design is something of an art (combining business
analysis chops, database handiness, and an eye for the aesthetic).
I would recommend sticking with a monochromatic color palette in two tones
and using gainsboro, silver, and the other grays to augment. My personal
favorite is the steelblue/lightsteelblue combination, but whatever
complements your companyâ's logo is best.
I would stick with black text â' except where you want to conditionally show
something good (green), possibly problematic (orange) or bad (red). Then use
the color sparingly (on a sinle field instead of the whole line). Use
palegoldenrod to highlight entire lines instead of yellow which is really
bright.
Iâ'm fond of dimgray for line borders instead of blackâ?¦ I just think it looks
more modern and softer on the eyes.
All of that said, those same themes you looked at for powerpoint can be
replicated if you like one in particular. Sorry I donâ't know any sites to
take a look at samplesâ?¦ Good luck!
One site to take a look at is:
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx. It shows how to do some pretty cool tricks.
Cheers,
Kathy
"Dean" wrote:
> Where can I find some good looking examples of reports and charts that
> showcase good looking design practices (my efforts leave a lot to be
> desired:). I can find lots of examples for FrontPage and PowerPoint,
> anything out there for SSRS?
> TIA
> dean
>
>|||Some of the samples provided by MS is a good starter for you. You can see
some best practises from microsoft site itself. There is a PDF document which
gives you the best practises.
Amarnath
"Dean" wrote:
> Where can I find some good looking examples of reports and charts that
> showcase good looking design practices (my efforts leave a lot to be
> desired:). I can find lots of examples for FrontPage and PowerPoint,
> anything out there for SSRS?
> TIA
> dean
>
>