Is it possible to have charting in SQL Server REporting services, where when
a mouse points to a point on the graph, it displays the value of the point?Sorry, this is not supported. The closest you can get is to either use data
point labels which are always visible, or use drillthrough actions on chart
datapoints.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TerminatorIII" <TerminatorIII@.discussions.microsoft.com> wrote in message
news:6015BBDE-C7F5-4A04-8F3D-F65B417F932C@.microsoft.com...
> Is it possible to have charting in SQL Server REporting services, where
> when
> a mouse points to a point on the graph, it displays the value of the
> point?
Showing posts with label charting. Show all posts
Showing posts with label charting. Show all posts
Saturday, February 25, 2012
Charts
I have a Custom Dundas Charting library that I utilize normally. I'm having
troubles getting my chart object (and tried to return and image) to render
within my reports. I'm confident I have the custom assemblie referenced. I
don't want to use the chart field from the toolbox, I want to set it to what
my assemblie returns. Anyway to get around this? I'm aware of the custom
data extensions, although, I wanted to just have my existing assemblie which
returns charts do it instead. so all my reports that need graphs can just
reference the assemblie and graph that is needed. Anyway to accomplish this?
I'm getting data type reference errors etc.
ClintPlease try this:
* Add an image to your report
* Set the image type to Database
* Set the image mimetype to e.g. image/png
* For the image value use an expression like
=MyCustomAssembly.GenerateChart()
Note: your custom assembly call has to return the image as byte[].
Here is a code snippet which should convert the Dundas chart output into a
byte array:
public static byte[] GenerateChart()
{
// chart rendering code
...
// save chart image to byte[]
System.IO.MemoryStream renderedImage = new MemoryStream();
dundasChart.ImageType = ChartImageType.Png;
dundasChart.Save(renderedImage);
renderedImage.Position = 0;
return renderedImage.ToArray();
}
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> I have a Custom Dundas Charting library that I utilize normally. I'm
having
> troubles getting my chart object (and tried to return and image) to render
> within my reports. I'm confident I have the custom assemblie referenced.
I
> don't want to use the chart field from the toolbox, I want to set it to
what
> my assemblie returns. Anyway to get around this? I'm aware of the custom
> data extensions, although, I wanted to just have my existing assemblie
which
> returns charts do it instead. so all my reports that need graphs can just
> reference the assemblie and graph that is needed. Anyway to accomplish
this?
> I'm getting data type reference errors etc.
> Clint
>|||Thanks Robert. Created a public function in the library to return a byte
stream.
"Robert Bruckner [MSFT]" wrote:
> Please try this:
> * Add an image to your report
> * Set the image type to Database
> * Set the image mimetype to e.g. image/png
> * For the image value use an expression like
> =MyCustomAssembly.GenerateChart()
> Note: your custom assembly call has to return the image as byte[].
> Here is a code snippet which should convert the Dundas chart output into a
> byte array:
> public static byte[] GenerateChart()
> {
> // chart rendering code
> ...
> // save chart image to byte[]
> System.IO.MemoryStream renderedImage = new MemoryStream();
> dundasChart.ImageType = ChartImageType.Png;
> dundasChart.Save(renderedImage);
> renderedImage.Position = 0;
> return renderedImage.ToArray();
> }
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
> news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> > I have a Custom Dundas Charting library that I utilize normally. I'm
> having
> > troubles getting my chart object (and tried to return and image) to render
> > within my reports. I'm confident I have the custom assemblie referenced.
> I
> > don't want to use the chart field from the toolbox, I want to set it to
> what
> > my assemblie returns. Anyway to get around this? I'm aware of the custom
> > data extensions, although, I wanted to just have my existing assemblie
> which
> > returns charts do it instead. so all my reports that need graphs can just
> > reference the assemblie and graph that is needed. Anyway to accomplish
> this?
> > I'm getting data type reference errors etc.
> >
> > Clint
> >
> >
>
>
troubles getting my chart object (and tried to return and image) to render
within my reports. I'm confident I have the custom assemblie referenced. I
don't want to use the chart field from the toolbox, I want to set it to what
my assemblie returns. Anyway to get around this? I'm aware of the custom
data extensions, although, I wanted to just have my existing assemblie which
returns charts do it instead. so all my reports that need graphs can just
reference the assemblie and graph that is needed. Anyway to accomplish this?
I'm getting data type reference errors etc.
ClintPlease try this:
* Add an image to your report
* Set the image type to Database
* Set the image mimetype to e.g. image/png
* For the image value use an expression like
=MyCustomAssembly.GenerateChart()
Note: your custom assembly call has to return the image as byte[].
Here is a code snippet which should convert the Dundas chart output into a
byte array:
public static byte[] GenerateChart()
{
// chart rendering code
...
// save chart image to byte[]
System.IO.MemoryStream renderedImage = new MemoryStream();
dundasChart.ImageType = ChartImageType.Png;
dundasChart.Save(renderedImage);
renderedImage.Position = 0;
return renderedImage.ToArray();
}
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> I have a Custom Dundas Charting library that I utilize normally. I'm
having
> troubles getting my chart object (and tried to return and image) to render
> within my reports. I'm confident I have the custom assemblie referenced.
I
> don't want to use the chart field from the toolbox, I want to set it to
what
> my assemblie returns. Anyway to get around this? I'm aware of the custom
> data extensions, although, I wanted to just have my existing assemblie
which
> returns charts do it instead. so all my reports that need graphs can just
> reference the assemblie and graph that is needed. Anyway to accomplish
this?
> I'm getting data type reference errors etc.
> Clint
>|||Thanks Robert. Created a public function in the library to return a byte
stream.
"Robert Bruckner [MSFT]" wrote:
> Please try this:
> * Add an image to your report
> * Set the image type to Database
> * Set the image mimetype to e.g. image/png
> * For the image value use an expression like
> =MyCustomAssembly.GenerateChart()
> Note: your custom assembly call has to return the image as byte[].
> Here is a code snippet which should convert the Dundas chart output into a
> byte array:
> public static byte[] GenerateChart()
> {
> // chart rendering code
> ...
> // save chart image to byte[]
> System.IO.MemoryStream renderedImage = new MemoryStream();
> dundasChart.ImageType = ChartImageType.Png;
> dundasChart.Save(renderedImage);
> renderedImage.Position = 0;
> return renderedImage.ToArray();
> }
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
> news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> > I have a Custom Dundas Charting library that I utilize normally. I'm
> having
> > troubles getting my chart object (and tried to return and image) to render
> > within my reports. I'm confident I have the custom assemblie referenced.
> I
> > don't want to use the chart field from the toolbox, I want to set it to
> what
> > my assemblie returns. Anyway to get around this? I'm aware of the custom
> > data extensions, although, I wanted to just have my existing assemblie
> which
> > returns charts do it instead. so all my reports that need graphs can just
> > reference the assemblie and graph that is needed. Anyway to accomplish
> this?
> > I'm getting data type reference errors etc.
> >
> > Clint
> >
> >
>
>
Charting...
I'll be quick and too the point...
1: I have a stacked area chart.
2: Percentages are the values being marked.
Issue:
I need to make the 100 mark (text and line) on the y-axis to be red.
I've tried writing an expression to get at the current "label" for the
mark. I keep getting the following error:
<<
The border color expression for the chart 'Sample' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_Sample.EH_ValueAxis'.
>>
Here's what I have: '=iif(me.Value,"Black", "Red")'
I've also tried .Text and .Label.
Any help would be appreciated.I gave you incomplete code. Here is what I currently have.
Here's what I have: '=iif(me.Value <> "100","Black", "Red")'|||Sorry, the color of the axis is not an expression.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>I gave you incomplete code. Here is what I currently have.
> Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>|||Brian Welcker [MS] wrote:
> Sorry, the color of the axis is not an expression.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stu" <stumiller@.unforgettable.com> wrote in message
> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
> >I gave you incomplete code. Here is what I currently have.
> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
> >
Brian,
Thanks for responding...
So, just to make sure I understand what your saying... there is no way
to get the "value" or "text" of an axis and change the style of that
axis based upon that value?
The reason I "ask" it again this way is that I am able to change the
color of the line and text with this statement:
'=iif(InScope("100"),"Black", "Red")'
Ofcourse, "100" is not within the scope of the data and all the lines
turn "Red" but the point being, I can change the style in the
expression. I'm just asking is there a way to determine what axis your
on.
Thanks|||Yes, lines are data so you can set their color to an expression. Axis values
aren't data so expressions don't really make any sense (we can't iterate
through all possible values). We would have to add an 'Axis value color'
property to the data point.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104349698.883859.301160@.c13g2000cwb.googlegroups.com...
> Brian Welcker [MS] wrote:
>> Sorry, the color of the axis is not an expression.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Stu" <stumiller@.unforgettable.com> wrote in message
>> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>> >I gave you incomplete code. Here is what I currently have.
>> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>> >
> Brian,
> Thanks for responding...
> So, just to make sure I understand what your saying... there is no way
> to get the "value" or "text" of an axis and change the style of that
> axis based upon that value?
> The reason I "ask" it again this way is that I am able to change the
> color of the line and text with this statement:
> '=iif(InScope("100"),"Black", "Red")'
> Ofcourse, "100" is not within the scope of the data and all the lines
> turn "Red" but the point being, I can change the style in the
> expression. I'm just asking is there a way to determine what axis your
> on.
> Thanks
>
1: I have a stacked area chart.
2: Percentages are the values being marked.
Issue:
I need to make the 100 mark (text and line) on the y-axis to be red.
I've tried writing an expression to get at the current "label" for the
mark. I keep getting the following error:
<<
The border color expression for the chart 'Sample' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_Sample.EH_ValueAxis'.
>>
Here's what I have: '=iif(me.Value,"Black", "Red")'
I've also tried .Text and .Label.
Any help would be appreciated.I gave you incomplete code. Here is what I currently have.
Here's what I have: '=iif(me.Value <> "100","Black", "Red")'|||Sorry, the color of the axis is not an expression.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>I gave you incomplete code. Here is what I currently have.
> Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>|||Brian Welcker [MS] wrote:
> Sorry, the color of the axis is not an expression.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stu" <stumiller@.unforgettable.com> wrote in message
> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
> >I gave you incomplete code. Here is what I currently have.
> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
> >
Brian,
Thanks for responding...
So, just to make sure I understand what your saying... there is no way
to get the "value" or "text" of an axis and change the style of that
axis based upon that value?
The reason I "ask" it again this way is that I am able to change the
color of the line and text with this statement:
'=iif(InScope("100"),"Black", "Red")'
Ofcourse, "100" is not within the scope of the data and all the lines
turn "Red" but the point being, I can change the style in the
expression. I'm just asking is there a way to determine what axis your
on.
Thanks|||Yes, lines are data so you can set their color to an expression. Axis values
aren't data so expressions don't really make any sense (we can't iterate
through all possible values). We would have to add an 'Axis value color'
property to the data point.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104349698.883859.301160@.c13g2000cwb.googlegroups.com...
> Brian Welcker [MS] wrote:
>> Sorry, the color of the axis is not an expression.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Stu" <stumiller@.unforgettable.com> wrote in message
>> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>> >I gave you incomplete code. Here is what I currently have.
>> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>> >
> Brian,
> Thanks for responding...
> So, just to make sure I understand what your saying... there is no way
> to get the "value" or "text" of an axis and change the style of that
> axis based upon that value?
> The reason I "ask" it again this way is that I am able to change the
> color of the line and text with this statement:
> '=iif(InScope("100"),"Black", "Red")'
> Ofcourse, "100" is not within the scope of the data and all the lines
> turn "Red" but the point being, I can change the style in the
> expression. I'm just asking is there a way to determine what axis your
> on.
> Thanks
>
Charting Trouble
Well, this is what is happening.
I am getting my data from a stored procedure, and for this particular chart
am need to use 4 different data fields, 'AverageFillRate',
'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond
to the averagefillrate, so for example, between 2004 and 2006 I will have 3
fill rates, but the averagefillratetarget is constant among all years.
This is the way the legend appears now:
-- 2004 Average Fill Rate
-- 2004 Average Fill Rate Target
-- 2005 Average Fill Rate
-- 2005 Average Fill Rate Target
-- 2006 Average Fill Rate
-- 2006 Average Fill Rate Target
I need it to be:
-- Average Fill Rate Target
-- 2004 Average Fill Rate
-- 2005 Average Fill Rate
-- 2006 Average Fill Rate
..... etc
Since the target is constant among all years, it does not need to correspond
to any year field, and should be a straight line across the chart. Then I
should have another three different lines on the chart corresponding to the
years selected. But I have 6 lines, because I am getting a target line for
each year as well, this is a mess.
Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
dropped into the data field area, 'Months' dropped into the category field
area and 'Years' dropped into the series field area of the chart.
Any suggestions, and does this help any?
ThanksPlease check my response on your other thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=1ca451e6-5cc2-43fc-9fd9-bb51e1a3967d&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:5B978BF7-4D62-4D5C-9355-163AB6F7FCF3@.microsoft.com...
> Well, this is what is happening.
> I am getting my data from a stored procedure, and for this particular
chart
> am need to use 4 different data fields, 'AverageFillRate',
> 'AverageFillRateTarget', 'Years', and 'Months'. The years need to
correspond
> to the averagefillrate, so for example, between 2004 and 2006 I will have
3
> fill rates, but the averagefillratetarget is constant among all years.
> This is the way the legend appears now:
> -- 2004 Average Fill Rate
> -- 2004 Average Fill Rate Target
> -- 2005 Average Fill Rate
> -- 2005 Average Fill Rate Target
> -- 2006 Average Fill Rate
> -- 2006 Average Fill Rate Target
>
> I need it to be:
> -- Average Fill Rate Target
> -- 2004 Average Fill Rate
> -- 2005 Average Fill Rate
> -- 2006 Average Fill Rate
> ..... etc
>
> Since the target is constant among all years, it does not need to
correspond
> to any year field, and should be a straight line across the chart. Then I
> should have another three different lines on the chart corresponding to
the
> years selected. But I have 6 lines, because I am getting a target line for
> each year as well, this is a mess.
> Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
> dropped into the data field area, 'Months' dropped into the category field
> area and 'Years' dropped into the series field area of the chart.
> Any suggestions, and does this help any?
> Thanks
I am getting my data from a stored procedure, and for this particular chart
am need to use 4 different data fields, 'AverageFillRate',
'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond
to the averagefillrate, so for example, between 2004 and 2006 I will have 3
fill rates, but the averagefillratetarget is constant among all years.
This is the way the legend appears now:
-- 2004 Average Fill Rate
-- 2004 Average Fill Rate Target
-- 2005 Average Fill Rate
-- 2005 Average Fill Rate Target
-- 2006 Average Fill Rate
-- 2006 Average Fill Rate Target
I need it to be:
-- Average Fill Rate Target
-- 2004 Average Fill Rate
-- 2005 Average Fill Rate
-- 2006 Average Fill Rate
..... etc
Since the target is constant among all years, it does not need to correspond
to any year field, and should be a straight line across the chart. Then I
should have another three different lines on the chart corresponding to the
years selected. But I have 6 lines, because I am getting a target line for
each year as well, this is a mess.
Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
dropped into the data field area, 'Months' dropped into the category field
area and 'Years' dropped into the series field area of the chart.
Any suggestions, and does this help any?
ThanksPlease check my response on your other thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=1ca451e6-5cc2-43fc-9fd9-bb51e1a3967d&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:5B978BF7-4D62-4D5C-9355-163AB6F7FCF3@.microsoft.com...
> Well, this is what is happening.
> I am getting my data from a stored procedure, and for this particular
chart
> am need to use 4 different data fields, 'AverageFillRate',
> 'AverageFillRateTarget', 'Years', and 'Months'. The years need to
correspond
> to the averagefillrate, so for example, between 2004 and 2006 I will have
3
> fill rates, but the averagefillratetarget is constant among all years.
> This is the way the legend appears now:
> -- 2004 Average Fill Rate
> -- 2004 Average Fill Rate Target
> -- 2005 Average Fill Rate
> -- 2005 Average Fill Rate Target
> -- 2006 Average Fill Rate
> -- 2006 Average Fill Rate Target
>
> I need it to be:
> -- Average Fill Rate Target
> -- 2004 Average Fill Rate
> -- 2005 Average Fill Rate
> -- 2006 Average Fill Rate
> ..... etc
>
> Since the target is constant among all years, it does not need to
correspond
> to any year field, and should be a straight line across the chart. Then I
> should have another three different lines on the chart corresponding to
the
> years selected. But I have 6 lines, because I am getting a target line for
> each year as well, this is a mess.
> Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
> dropped into the data field area, 'Months' dropped into the category field
> area and 'Years' dropped into the series field area of the chart.
> Any suggestions, and does this help any?
> Thanks
Charting table detail and sum
I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
One alternative way is to add a second chart which just shows the total number of employees.
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
Charting table detail and sum
I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
One alternative way is to add a second chart which just shows the total number of employees.
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
Charting simple value over time chart problems.
I am using Visual Studio Academic version 2002.
I have a simple table with dates and values that correspond to those dates and I would like to chart it using crystal reports. I have created a new report and pulled in the 2 columns from the table.
Now I am lost. When ever I try to do a chart it only gives me the option to continue if I select the "show value and select a field". Thats fine and dandy but when I select a field under any chart type or any chart option it always says "Count of <fieldname>" which is totally wrong.
I only want
for each x value show a y value. (basically like a stock ticker)
This is incredibly frustrating since this is the simplest graph type I can imagine and it just completely is not user friendly for it. Any help would be hugely appreciated.
Thank you.Btw, I downloaded the latest version of crystal reports and it does the same thing.
So obviously I just have no clue how to do this type of chart.
The "do not summarize" button is PERMA disabled, so no matter what field I select in the "Show Values" area, they are always Counted instead rather than just showing the value.
I am puting the date field in the "on Change of" column.
and the corresponding value in the "Show value(s)" column, but again in the show value(s) column it always Counts them rather than just displaying the value.
I tried inverting the selection with putting the value field in the "on change of" and the date field in the "show values" column with erradic results.
Can this type of simple graph even be created in crystal??|||Well now I know what the problem is. Called the company and they said that only the advanced developer version of crystal reports gives the functionality to not summarize the selected values with VS.net.
This is also the same case with the downloadable evaluation versions of their software.
Personally that makes me so annoyed I just won't recommend the product as our reporting solution. If I cannot even show my boss a working example of what types of charting and reports we will be getting with the product, there is no way I am going to even try to sell it to them because the software hasn't even sold me.|||After thinking about this, I came to the conclusion that the sales lady I spoke with must have been smoking crack.
I called Crystal again, went through an hour hugabaloo to get to a tech support guy to finally get the real answer.
The "don't summarize field" works with formulas. So that if you want to create a simple x, y graph, you must create a formula to show the value of the y field.
Don't worry you are not really creating a formula and changing the value at all, it is just the stupid interface they have for their 3rd party charting tool. So, you just have to jump through their hoops to get your work done. It is not intuative at all, but it works and luckily it is simple to do.
So
Task 1: create your report,
Task 2: before you add a chart to it, click on the solution explorer and select formula fields. Right click and select -> New
Task 3: Select the field you want to display as the y value from the database connection explorer and double click on it. This will move something like { <field name> } into the textbox at the bottom of the formula form. Leave it like that. Save and close the formula dialog box.
Task 4: Add a chart to your report.
-In the data fields (you should see your new formula field in the data field there with what ever name you named it when you saved it), select your x value (field) in the top list box that has the drop down that says "On Change of".
-Then select the formula field for the bottom list box that says "show value(s)". The don't summarize button now becomes upchecked if you needed it to be, and your chart should display something near correctly at this point.
There you go.|||I've got exactly the same problem. I tried your solution but that doesn't work.. the don't summarize button is still disabled.
I'm using Visual Studio .Net 2003
Do you have any idea why the charts' not working?|||for wwater:
Make sure that you select an item in the Show Values list box, otherwise the "Don't Summarize Values" option will be greyed out. Took me a while to cotton on to how that area works - not very untuitively, as it happens!
And of course "Don't Summarize Values" won't be enabled if the field you have selected is a "Sum of Group xxxx" type field, because you can't un-sum a summing operation.....:-))
Dave|||When I select the formula field (Y) in the Show Value's list box, the "Don't Summarize Values" option is still disabled..
The chart gives always a Y value of 1 for each X value, that is totaly wrong according to the table..|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave
hey can u help me fix my project in vb.net...please lemme know if u can help ...i would b very thankful if u could help me...please reply soon...
thanks
shruti.|||I found out why charts didn't work. I did not found a direct solution, but i did found a way to work around the problem.
Instead of making a Blank Report, choose the Report Expert and insert the Chart. Then the chart works..
wil.
I have a simple table with dates and values that correspond to those dates and I would like to chart it using crystal reports. I have created a new report and pulled in the 2 columns from the table.
Now I am lost. When ever I try to do a chart it only gives me the option to continue if I select the "show value and select a field". Thats fine and dandy but when I select a field under any chart type or any chart option it always says "Count of <fieldname>" which is totally wrong.
I only want
for each x value show a y value. (basically like a stock ticker)
This is incredibly frustrating since this is the simplest graph type I can imagine and it just completely is not user friendly for it. Any help would be hugely appreciated.
Thank you.Btw, I downloaded the latest version of crystal reports and it does the same thing.
So obviously I just have no clue how to do this type of chart.
The "do not summarize" button is PERMA disabled, so no matter what field I select in the "Show Values" area, they are always Counted instead rather than just showing the value.
I am puting the date field in the "on Change of" column.
and the corresponding value in the "Show value(s)" column, but again in the show value(s) column it always Counts them rather than just displaying the value.
I tried inverting the selection with putting the value field in the "on change of" and the date field in the "show values" column with erradic results.
Can this type of simple graph even be created in crystal??|||Well now I know what the problem is. Called the company and they said that only the advanced developer version of crystal reports gives the functionality to not summarize the selected values with VS.net.
This is also the same case with the downloadable evaluation versions of their software.
Personally that makes me so annoyed I just won't recommend the product as our reporting solution. If I cannot even show my boss a working example of what types of charting and reports we will be getting with the product, there is no way I am going to even try to sell it to them because the software hasn't even sold me.|||After thinking about this, I came to the conclusion that the sales lady I spoke with must have been smoking crack.
I called Crystal again, went through an hour hugabaloo to get to a tech support guy to finally get the real answer.
The "don't summarize field" works with formulas. So that if you want to create a simple x, y graph, you must create a formula to show the value of the y field.
Don't worry you are not really creating a formula and changing the value at all, it is just the stupid interface they have for their 3rd party charting tool. So, you just have to jump through their hoops to get your work done. It is not intuative at all, but it works and luckily it is simple to do.
So
Task 1: create your report,
Task 2: before you add a chart to it, click on the solution explorer and select formula fields. Right click and select -> New
Task 3: Select the field you want to display as the y value from the database connection explorer and double click on it. This will move something like { <field name> } into the textbox at the bottom of the formula form. Leave it like that. Save and close the formula dialog box.
Task 4: Add a chart to your report.
-In the data fields (you should see your new formula field in the data field there with what ever name you named it when you saved it), select your x value (field) in the top list box that has the drop down that says "On Change of".
-Then select the formula field for the bottom list box that says "show value(s)". The don't summarize button now becomes upchecked if you needed it to be, and your chart should display something near correctly at this point.
There you go.|||I've got exactly the same problem. I tried your solution but that doesn't work.. the don't summarize button is still disabled.
I'm using Visual Studio .Net 2003
Do you have any idea why the charts' not working?|||for wwater:
Make sure that you select an item in the Show Values list box, otherwise the "Don't Summarize Values" option will be greyed out. Took me a while to cotton on to how that area works - not very untuitively, as it happens!
And of course "Don't Summarize Values" won't be enabled if the field you have selected is a "Sum of Group xxxx" type field, because you can't un-sum a summing operation.....:-))
Dave|||When I select the formula field (Y) in the Show Value's list box, the "Don't Summarize Values" option is still disabled..
The chart gives always a Y value of 1 for each X value, that is totaly wrong according to the table..|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave
hey can u help me fix my project in vb.net...please lemme know if u can help ...i would b very thankful if u could help me...please reply soon...
thanks
shruti.|||I found out why charts didn't work. I did not found a direct solution, but i did found a way to work around the problem.
Instead of making a Blank Report, choose the Report Expert and insert the Chart. Then the chart works..
wil.
Charting question
I have a report where each page presents some data in tabular form, the
bottom row (numerically) representing a histogram; i.e., % of values falling
into the "bucket" corresponding to that column. Below this row I'd like to
have a bar chart that graphically displays this histogram with each bar
aligned with the column above. Although I've figured out how to constuct
the chart object there doesn't seem to be any way to actually get things to
line up properly.
The portion of the last row containing the data consists of 7 cells. There
are a couple of padding columns so the first data item is in column 3. What
I tried was to insert a row below (actually a footer row), then merge the 7
cells below the data along with the left adjacent pad cell. I included the
extra cell to allow space for the y axis labels.
So, I can get the chart to appear, but due to the formatting of the chart;
i.e., white space, things don't line up properly. I'm trying to duplicate
(as much as possible) a Crystal generated report in order to determine the
feasibility of using Reporting Services instead. I'm afraid this might be a
deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
Thanks in advance for any help.
BillSo, anybody got any ideas on this one? I'd hoped to get some help before
this scrolls off the edge of the earth...
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eDoS$jukEHA.1936@.TK2MSFTNGP12.phx.gbl...
>I have a report where each page presents some data in tabular form, the
> bottom row (numerically) representing a histogram; i.e., % of values
> falling
> into the "bucket" corresponding to that column. Below this row I'd like to
> have a bar chart that graphically displays this histogram with each bar
> aligned with the column above. Although I've figured out how to constuct
> the chart object there doesn't seem to be any way to actually get things
> to
> line up properly.
> The portion of the last row containing the data consists of 7 cells.
> There
> are a couple of padding columns so the first data item is in column 3.
> What
> I tried was to insert a row below (actually a footer row), then merge the
> 7
> cells below the data along with the left adjacent pad cell. I included the
> extra cell to allow space for the y axis labels.
> So, I can get the chart to appear, but due to the formatting of the chart;
> i.e., white space, things don't line up properly. I'm trying to duplicate
> (as much as possible) a Crystal generated report in order to determine the
> feasibility of using Reporting Services instead. I'm afraid this might be
> a
> deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
> Thanks in advance for any help.
> Bill
>
bottom row (numerically) representing a histogram; i.e., % of values falling
into the "bucket" corresponding to that column. Below this row I'd like to
have a bar chart that graphically displays this histogram with each bar
aligned with the column above. Although I've figured out how to constuct
the chart object there doesn't seem to be any way to actually get things to
line up properly.
The portion of the last row containing the data consists of 7 cells. There
are a couple of padding columns so the first data item is in column 3. What
I tried was to insert a row below (actually a footer row), then merge the 7
cells below the data along with the left adjacent pad cell. I included the
extra cell to allow space for the y axis labels.
So, I can get the chart to appear, but due to the formatting of the chart;
i.e., white space, things don't line up properly. I'm trying to duplicate
(as much as possible) a Crystal generated report in order to determine the
feasibility of using Reporting Services instead. I'm afraid this might be a
deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
Thanks in advance for any help.
BillSo, anybody got any ideas on this one? I'd hoped to get some help before
this scrolls off the edge of the earth...
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eDoS$jukEHA.1936@.TK2MSFTNGP12.phx.gbl...
>I have a report where each page presents some data in tabular form, the
> bottom row (numerically) representing a histogram; i.e., % of values
> falling
> into the "bucket" corresponding to that column. Below this row I'd like to
> have a bar chart that graphically displays this histogram with each bar
> aligned with the column above. Although I've figured out how to constuct
> the chart object there doesn't seem to be any way to actually get things
> to
> line up properly.
> The portion of the last row containing the data consists of 7 cells.
> There
> are a couple of padding columns so the first data item is in column 3.
> What
> I tried was to insert a row below (actually a footer row), then merge the
> 7
> cells below the data along with the left adjacent pad cell. I included the
> extra cell to allow space for the y axis labels.
> So, I can get the chart to appear, but due to the formatting of the chart;
> i.e., white space, things don't line up properly. I'm trying to duplicate
> (as much as possible) a Crystal generated report in order to determine the
> feasibility of using Reporting Services instead. I'm afraid this might be
> a
> deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
> Thanks in advance for any help.
> Bill
>
Charting problem
Hi all. I have plotted a chart based on the data obtained. However, is there a way to limit the number of bars to be displayed in the chart?
Lets say, I have data from Jan to Dec, i needed all the data because i need the accumulated figures from each month.
But, I do not wish to display in the bar chart for data from Jan to Dec.
There are section in the detail for hiding some data, but I dont know about chart.
Any comments are appreciated!Well, give us an example - what period do you wish to chart on, if it's not Jan-Dec??|||Lets say the data needed is from Jan to Dec, because I need to calculate the running total for the accumulated figures for other processing purposes.
Then for the chart, I would like to plot the data from Sept to Dec only. Is it possible?
The date field is used as a criteria for grouping.
Lets say, I have data from Jan to Dec, i needed all the data because i need the accumulated figures from each month.
But, I do not wish to display in the bar chart for data from Jan to Dec.
There are section in the detail for hiding some data, but I dont know about chart.
Any comments are appreciated!Well, give us an example - what period do you wish to chart on, if it's not Jan-Dec??|||Lets say the data needed is from Jan to Dec, because I need to calculate the running total for the accumulated figures for other processing purposes.
Then for the chart, I would like to plot the data from Sept to Dec only. Is it possible?
The date field is used as a criteria for grouping.
Charting Issue
1st... sorry about the duplicate post. Was posted under the wrong account.
I have run into a very strange situation and have been unable to locate
the cause of the problem. Running SQL Reporting Services 2000 and
pulling data from an Oracle db for this specific report.
The report is very simple. A bar chart with 2 data sets. One
represented as bars, the other represented as a line. Below the chart
is a table with the text representation of the data being used for the
chart.
On the chart, the data is displayed using the same y-axis scale.
For some reason when I run a report for a specific set of criteria I
get the correct data in the table, but the graph is messed up. The
2nd data point for my line has a value of 39.30 but the line on the
chart draws up to the 120 mark. The strange thing is that the marker
icon shows the value of 39.30.
My data looks something like this:
Bar Line
39.30 39.30
0 39.30
56.50 43.90
17.50 41.40
All of the points on the line show the correct value and are in the
right position except for the 2nd point. It shows the correct value
at the point, but the line shoots up to the 120 mark on the y-axis.
I have tried this running it both on the server and also in DebugLocal
mode on my development system.
I need to get this resolved ASAP for the executive management team.
Any help would be greatly appreciated.
Thanks!Mike
If you see the Value expression for line chart it must
SUM(Fields!ColumnName.Value).
I beleive becuase of the data some where it is summing the value.
--
Thanks & Rate the Postings.
-Ravi-
"Mike H." wrote:
> 1st... sorry about the duplicate post. Was posted under the wrong account.
> I have run into a very strange situation and have been unable to locate
> the cause of the problem. Running SQL Reporting Services 2000 and
> pulling data from an Oracle db for this specific report.
> The report is very simple. A bar chart with 2 data sets. One
> represented as bars, the other represented as a line. Below the chart
> is a table with the text representation of the data being used for the
> chart.
>
> On the chart, the data is displayed using the same y-axis scale.
>
> For some reason when I run a report for a specific set of criteria I
> get the correct data in the table, but the graph is messed up. The
> 2nd data point for my line has a value of 39.30 but the line on the
> chart draws up to the 120 mark. The strange thing is that the marker
> icon shows the value of 39.30.
>
> My data looks something like this:
>
> Bar Line
> 39.30 39.30
> 0 39.30
> 56.50 43.90
> 17.50 41.40
>
> All of the points on the line show the correct value and are in the
> right position except for the 2nd point. It shows the correct value
> at the point, but the line shoots up to the 120 mark on the y-axis.
>
> I have tried this running it both on the server and also in DebugLocal
> mode on my development system.
>
> I need to get this resolved ASAP for the executive management team.
> Any help would be greatly appreciated.
>
> Thanks!|||Thank you!
I have no idea why there was a SUM function in there. Everything looks
right now.
Thanks again!
"Ravi" wrote:
> Mike
> If you see the Value expression for line chart it must
> SUM(Fields!ColumnName.Value).
> I beleive becuase of the data some where it is summing the value.
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "Mike H." wrote:
> > 1st... sorry about the duplicate post. Was posted under the wrong account.
> >
> > I have run into a very strange situation and have been unable to locate
> > the cause of the problem. Running SQL Reporting Services 2000 and
> > pulling data from an Oracle db for this specific report.
> >
> > The report is very simple. A bar chart with 2 data sets. One
> > represented as bars, the other represented as a line. Below the chart
> > is a table with the text representation of the data being used for the
> > chart.
> >
> >
> > On the chart, the data is displayed using the same y-axis scale.
> >
> >
> > For some reason when I run a report for a specific set of criteria I
> > get the correct data in the table, but the graph is messed up. The
> > 2nd data point for my line has a value of 39.30 but the line on the
> > chart draws up to the 120 mark. The strange thing is that the marker
> > icon shows the value of 39.30.
> >
> >
> > My data looks something like this:
> >
> >
> > Bar Line
> > 39.30 39.30
> > 0 39.30
> > 56.50 43.90
> > 17.50 41.40
> >
> >
> > All of the points on the line show the correct value and are in the
> > right position except for the 2nd point. It shows the correct value
> > at the point, but the line shoots up to the 120 mark on the y-axis.
> >
> >
> > I have tried this running it both on the server and also in DebugLocal
> > mode on my development system.
> >
> >
> > I need to get this resolved ASAP for the executive management team.
> > Any help would be greatly appreciated.
> >
> >
> > Thanks!
I have run into a very strange situation and have been unable to locate
the cause of the problem. Running SQL Reporting Services 2000 and
pulling data from an Oracle db for this specific report.
The report is very simple. A bar chart with 2 data sets. One
represented as bars, the other represented as a line. Below the chart
is a table with the text representation of the data being used for the
chart.
On the chart, the data is displayed using the same y-axis scale.
For some reason when I run a report for a specific set of criteria I
get the correct data in the table, but the graph is messed up. The
2nd data point for my line has a value of 39.30 but the line on the
chart draws up to the 120 mark. The strange thing is that the marker
icon shows the value of 39.30.
My data looks something like this:
Bar Line
39.30 39.30
0 39.30
56.50 43.90
17.50 41.40
All of the points on the line show the correct value and are in the
right position except for the 2nd point. It shows the correct value
at the point, but the line shoots up to the 120 mark on the y-axis.
I have tried this running it both on the server and also in DebugLocal
mode on my development system.
I need to get this resolved ASAP for the executive management team.
Any help would be greatly appreciated.
Thanks!Mike
If you see the Value expression for line chart it must
SUM(Fields!ColumnName.Value).
I beleive becuase of the data some where it is summing the value.
--
Thanks & Rate the Postings.
-Ravi-
"Mike H." wrote:
> 1st... sorry about the duplicate post. Was posted under the wrong account.
> I have run into a very strange situation and have been unable to locate
> the cause of the problem. Running SQL Reporting Services 2000 and
> pulling data from an Oracle db for this specific report.
> The report is very simple. A bar chart with 2 data sets. One
> represented as bars, the other represented as a line. Below the chart
> is a table with the text representation of the data being used for the
> chart.
>
> On the chart, the data is displayed using the same y-axis scale.
>
> For some reason when I run a report for a specific set of criteria I
> get the correct data in the table, but the graph is messed up. The
> 2nd data point for my line has a value of 39.30 but the line on the
> chart draws up to the 120 mark. The strange thing is that the marker
> icon shows the value of 39.30.
>
> My data looks something like this:
>
> Bar Line
> 39.30 39.30
> 0 39.30
> 56.50 43.90
> 17.50 41.40
>
> All of the points on the line show the correct value and are in the
> right position except for the 2nd point. It shows the correct value
> at the point, but the line shoots up to the 120 mark on the y-axis.
>
> I have tried this running it both on the server and also in DebugLocal
> mode on my development system.
>
> I need to get this resolved ASAP for the executive management team.
> Any help would be greatly appreciated.
>
> Thanks!|||Thank you!
I have no idea why there was a SUM function in there. Everything looks
right now.
Thanks again!
"Ravi" wrote:
> Mike
> If you see the Value expression for line chart it must
> SUM(Fields!ColumnName.Value).
> I beleive becuase of the data some where it is summing the value.
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "Mike H." wrote:
> > 1st... sorry about the duplicate post. Was posted under the wrong account.
> >
> > I have run into a very strange situation and have been unable to locate
> > the cause of the problem. Running SQL Reporting Services 2000 and
> > pulling data from an Oracle db for this specific report.
> >
> > The report is very simple. A bar chart with 2 data sets. One
> > represented as bars, the other represented as a line. Below the chart
> > is a table with the text representation of the data being used for the
> > chart.
> >
> >
> > On the chart, the data is displayed using the same y-axis scale.
> >
> >
> > For some reason when I run a report for a specific set of criteria I
> > get the correct data in the table, but the graph is messed up. The
> > 2nd data point for my line has a value of 39.30 but the line on the
> > chart draws up to the 120 mark. The strange thing is that the marker
> > icon shows the value of 39.30.
> >
> >
> > My data looks something like this:
> >
> >
> > Bar Line
> > 39.30 39.30
> > 0 39.30
> > 56.50 43.90
> > 17.50 41.40
> >
> >
> > All of the points on the line show the correct value and are in the
> > right position except for the 2nd point. It shows the correct value
> > at the point, but the line shoots up to the 120 mark on the y-axis.
> >
> >
> > I have tried this running it both on the server and also in DebugLocal
> > mode on my development system.
> >
> >
> > I need to get this resolved ASAP for the executive management team.
> > Any help would be greatly appreciated.
> >
> >
> > Thanks!
Charting from two datasets
I have a chart that is displaying data from two datasets. Dataset #1 returns
a set of "all rows". Dataset #2 returns rows that are a subset of the
Dataset #1 with two status values - let's say "True" and "False". I wish to
display a stacked column chart with three segments - "True", "False" and
"Unknown", where unknown is the count of items from Dataset #1 that are not
represented in Dataset #2. How do I do this? What I have tried is a Series
group keyed to the status value from Dataset #2 (i.e. True, False). My data
value is labeled "Known" and is the count from Dataset #2. But when I add a
2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
effectively multiplies the series to 4 values instead of the desired 3. In
other words, I want the chart to show series values of "Known True", "Known
False" and "Unknown", instead of "Known True", "Known False", "Unknown True",
"Unknown False".You would need to join the data in your query first. Create one chart from
two datasets is not supported.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
>I have a chart that is displaying data from two datasets. Dataset #1
>returns
> a set of "all rows". Dataset #2 returns rows that are a subset of the
> Dataset #1 with two status values - let's say "True" and "False". I wish
> to
> display a stacked column chart with three segments - "True", "False" and
> "Unknown", where unknown is the count of items from Dataset #1 that are
> not
> represented in Dataset #2. How do I do this? What I have tried is a
> Series
> group keyed to the status value from Dataset #2 (i.e. True, False). My
> data
> value is labeled "Known" and is the count from Dataset #2. But when I add
> a
> 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> effectively multiplies the series to 4 values instead of the desired 3.
> In
> other words, I want the chart to show series values of "Known True",
> "Known
> False" and "Unknown", instead of "Known True", "Known False", "Unknown
> True",
> "Unknown False".|||Thanks Robert. It is my understanding though that supporting an aggregate
from a 2nd dataset within a single data region IS supported, it does seem to
be working, just not giving me the series organization I want. Joining is
not an option as Dataset #1 is provided by an extension DLL and Dataset #2 is
SQL.
"Robert Bruckner [MSFT]" wrote:
> You would need to join the data in your query first. Create one chart from
> two datasets is not supported.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
> news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
> >I have a chart that is displaying data from two datasets. Dataset #1
> >returns
> > a set of "all rows". Dataset #2 returns rows that are a subset of the
> > Dataset #1 with two status values - let's say "True" and "False". I wish
> > to
> > display a stacked column chart with three segments - "True", "False" and
> > "Unknown", where unknown is the count of items from Dataset #1 that are
> > not
> > represented in Dataset #2. How do I do this? What I have tried is a
> > Series
> > group keyed to the status value from Dataset #2 (i.e. True, False). My
> > data
> > value is labeled "Known" and is the count from Dataset #2. But when I add
> > a
> > 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> > effectively multiplies the series to 4 values instead of the desired 3.
> > In
> > other words, I want the chart to show series values of "Known True",
> > "Known
> > False" and "Unknown", instead of "Known True", "Known False", "Unknown
> > True",
> > "Unknown False".
>
>
a set of "all rows". Dataset #2 returns rows that are a subset of the
Dataset #1 with two status values - let's say "True" and "False". I wish to
display a stacked column chart with three segments - "True", "False" and
"Unknown", where unknown is the count of items from Dataset #1 that are not
represented in Dataset #2. How do I do this? What I have tried is a Series
group keyed to the status value from Dataset #2 (i.e. True, False). My data
value is labeled "Known" and is the count from Dataset #2. But when I add a
2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
effectively multiplies the series to 4 values instead of the desired 3. In
other words, I want the chart to show series values of "Known True", "Known
False" and "Unknown", instead of "Known True", "Known False", "Unknown True",
"Unknown False".You would need to join the data in your query first. Create one chart from
two datasets is not supported.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
>I have a chart that is displaying data from two datasets. Dataset #1
>returns
> a set of "all rows". Dataset #2 returns rows that are a subset of the
> Dataset #1 with two status values - let's say "True" and "False". I wish
> to
> display a stacked column chart with three segments - "True", "False" and
> "Unknown", where unknown is the count of items from Dataset #1 that are
> not
> represented in Dataset #2. How do I do this? What I have tried is a
> Series
> group keyed to the status value from Dataset #2 (i.e. True, False). My
> data
> value is labeled "Known" and is the count from Dataset #2. But when I add
> a
> 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> effectively multiplies the series to 4 values instead of the desired 3.
> In
> other words, I want the chart to show series values of "Known True",
> "Known
> False" and "Unknown", instead of "Known True", "Known False", "Unknown
> True",
> "Unknown False".|||Thanks Robert. It is my understanding though that supporting an aggregate
from a 2nd dataset within a single data region IS supported, it does seem to
be working, just not giving me the series organization I want. Joining is
not an option as Dataset #1 is provided by an extension DLL and Dataset #2 is
SQL.
"Robert Bruckner [MSFT]" wrote:
> You would need to join the data in your query first. Create one chart from
> two datasets is not supported.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
> news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
> >I have a chart that is displaying data from two datasets. Dataset #1
> >returns
> > a set of "all rows". Dataset #2 returns rows that are a subset of the
> > Dataset #1 with two status values - let's say "True" and "False". I wish
> > to
> > display a stacked column chart with three segments - "True", "False" and
> > "Unknown", where unknown is the count of items from Dataset #1 that are
> > not
> > represented in Dataset #2. How do I do this? What I have tried is a
> > Series
> > group keyed to the status value from Dataset #2 (i.e. True, False). My
> > data
> > value is labeled "Known" and is the count from Dataset #2. But when I add
> > a
> > 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> > effectively multiplies the series to 4 values instead of the desired 3.
> > In
> > other words, I want the chart to show series values of "Known True",
> > "Known
> > False" and "Unknown", instead of "Known True", "Known False", "Unknown
> > True",
> > "Unknown False".
>
>
Charting and the Document Map
Hi,
I have a report which contains 3 different charts. What I need to do is have
all 3 of the chart names in the Document and only 1 chart showing at a time.
The users can then click on a different chart name in the Document Map to
view a different chart.
Is this possible and any suggestions?
ThanksThe document map cannot be used to dynamically "show/hide" report items. It
can only be used to navigate through the report.
If the report only contains charts, you could add page breaks between the
charts and therefore have 3 pages and clicking in the document map would
just navigate the pages of the report. Not sure if that would work in your
situation.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:0C181E97-D056-495C-829D-94D78E73FFB6@.microsoft.com...
> Hi,
> I have a report which contains 3 different charts. What I need to do is
> have
> all 3 of the chart names in the Document and only 1 chart showing at a
> time.
> The users can then click on a different chart name in the Document Map to
> view a different chart.
> Is this possible and any suggestions?
> Thanks
I have a report which contains 3 different charts. What I need to do is have
all 3 of the chart names in the Document and only 1 chart showing at a time.
The users can then click on a different chart name in the Document Map to
view a different chart.
Is this possible and any suggestions?
ThanksThe document map cannot be used to dynamically "show/hide" report items. It
can only be used to navigate through the report.
If the report only contains charts, you could add page breaks between the
charts and therefore have 3 pages and clicking in the document map would
just navigate the pages of the report. Not sure if that would work in your
situation.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:0C181E97-D056-495C-829D-94D78E73FFB6@.microsoft.com...
> Hi,
> I have a report which contains 3 different charts. What I need to do is
> have
> all 3 of the chart names in the Document and only 1 chart showing at a
> time.
> The users can then click on a different chart name in the Document Map to
> view a different chart.
> Is this possible and any suggestions?
> Thanks
Subscribe to:
Posts (Atom)