Deserialization Failed: charts

Showing posts with label charts. Show all posts

Friday, March 30, 2012

ReportViewer graphics and charts do not display in aspx page

Hi,
I'm trying to display a basic report in an aspx page using the ReportViewer
component. The report displays but a graphic and simple chart are not
displayed. It seems like it has had good try because link regions in the
graph do actually work, but no visual chart.
Any ideas!Update on below
As I said it seems to be giving the display a good go, and I have managed to
intermitently display the chart graphic (I think by viewing the report in
report manager first), but refresh the page and it disapears again. Follow a
link from the report and then use the back button and it displays again. IE
pants or what!
Only hint is that when the chart is not display the properties say Type: Not
Available, when it is displayed it says Type: PNG Image. I have seen the
.gif displayed once, but don't seem to be able to do it again - same
properties - Type: Not Available.
Seems to be some info about on this type of issue, that is - controls,
security and encoding but nothing definitive.
Any assistance greatly appreciated
Thanks
Laurence
"Laurence" <laurence.pull@.silversands.co.uk> wrote in message
news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm trying to display a basic report in an aspx page using the
> ReportViewer component. The report displays but a graphic and simple chart
> are not displayed. It seems like it has had good try because link regions
> in the graph do actually work, but no visual chart.
> Any ideas!
>|||I am also having the same issue... If I restart IIS( iisreset ) the images
would start diplaying but would disappear after couple of minutes(in most
cases the third refresh would kill the images)
--Sarvan
"Laurence" wrote:
> Update on below
> As I said it seems to be giving the display a good go, and I have managed to
> intermitently display the chart graphic (I think by viewing the report in
> report manager first), but refresh the page and it disapears again. Follow a
> link from the report and then use the back button and it displays again. IE
> pants or what!
> Only hint is that when the chart is not display the properties say Type: Not
> Available, when it is displayed it says Type: PNG Image. I have seen the
> ..gif displayed once, but don't seem to be able to do it again - same
> properties - Type: Not Available.
> Seems to be some info about on this type of issue, that is - controls,
> security and encoding but nothing definitive.
> Any assistance greatly appreciated
> Thanks
> Laurence
> "Laurence" <laurence.pull@.silversands.co.uk> wrote in message
> news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm trying to display a basic report in an aspx page using the
> > ReportViewer component. The report displays but a graphic and simple chart
> > are not displayed. It seems like it has had good try because link regions
> > in the graph do actually work, but no visual chart.
> >
> > Any ideas!
> >
>
>

Monday, March 12, 2012

Reports cannot be exported to csv format

Hi,

We have developed few reports through SQL Server Reporting Service 2005.
All those reports are columnar graphs (BAR charts).
One of the requirement of the project is to have the ability to export the report in different formats.
Since our reports are columnar graphs we are unable to export it to CSV or MHTML format.
Is there are setting in the report, which allows me to display the values, when exported to csv format?
also is there any setting for MHTML format. Some machine open the report in MHTML format and some machine does not.

Any help would be appreciated.

Thanks in advance!

No replies yet:(

The only solution we can think about is to develop those many reports in tabular format. (only for CSV format)

Any other solution available?

Thanks!

|||

CSV output should include Chart Data. http://msdn2.microsoft.com/en-us/library/aa178937(SQL.80).aspx

If you are not getting data, make sure to set DataElementOutput to true. Here is a link to how it works for XML.

http://msdn2.microsoft.com/en-us/library/aa179497(SQL.80).aspx

|||

Even I read the first MSDN link where it mentions charts can be rendered to CSV. Thats why I am a bit sure that there may be some setting in the properties, which will show the data values in CSV.

I also tried the setting mentioned in the CSV Device Information Settings and mentioned Encoding value for CSV as ASCII. Restarted SQL Server.

I also set the DataElementOutput property to "Output" but still I am not able to see the expected result.

Please do let me know if there is any solution available.

Thanks!

|||

Chart Data is supposed to be exported to CSV.

Can you attach the report definition so I can take a look and diagnose the problem?

Thanks!

|||

Hi Denis,

Following is the report definition. Hope to find some solution to my problem.

Thanks in advance!

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="ML_OLAP_DS">
<DataSourceReference>ML_OLAP_DS</DataSourceReference>
<rd:DataSourceID>2e071b5e-2d8d-4aab-94ff-edf8900886a2</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="startDate">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[DATE].[Startdate].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="endDate">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[DATE].[Startdate].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>End Date</Prompt>
</ReportParameter>
<ReportParameter Name="users">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[USERS].[WINDOWS LOGON NAME].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Users</Prompt>
</ReportParameter>
<ReportParameter Name="appName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>[APPLICATIONS].[APPLICATION NAME].[All]</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Applications</Prompt>
</ReportParameter>
<ReportParameter Name="chartTitle">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Ten Most Used Applications</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Chart Title</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Chart Name="MostUsedAppChart">
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Subtype>Plain</Subtype>
<Title>
<Caption>=RTRIM( Parameters!chartTitle.Value)</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<NoRows>The current report criteria does not satisfy any records.</NoRows>
<Height>6.125in</Height>
<CategoryAxis>
<Axis>
<Title>
<Caption>Applications</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<PointWidth>0</PointWidth>
<Left>0.125in</Left>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<DataSetName>MostUsedAppDS</DataSetName>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Value1</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<PlotArea>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BackgroundColor>LightGrey</BackgroundColor>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title>
<Caption>Occurences</Caption>
<Style>
<FontFamily>Arial Black</FontFamily>
</Style>
</Title>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Column</Type>
<Width>4.5375in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!APPLICATION_NAME.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label />
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!APPLICATION_INSTANCES_VIEW_Count.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontSize>8pt</FontSize>
</Style>
<Value>=Fields!APPLICATION_INSTANCES_VIEW_Count.Value</Value>
<Visible>true</Visible>
</DataLabel>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</Chart>
</ReportItems>
<Height>7.875in</Height>
</Body>
<rd:ReportID>a7bd15d4-cace-4fe8-b2d3-62bc6fc786a8</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="MostUsedAppDS">
<Query>
<rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>
<CommandText>WITH
MEMBER [DATE].[StartDate].[DateRange] AS
AGGREGATE
( STRTOMEMBER(@.startDate) : STRTOMEMBER(@.endDate), [Measures].CURRENTMEMBER
)
MEMBER [USERS].[WINDOWS LOGON NAME].[UserName] AS
AGGREGATE
( {STRTOSET(@.users)} )
SELECT
NON EMPTY { [Measures].[APPLICATION INSTANCES VIEW Count] } ON COLUMNS,
NON EMPTY TopCount ( Filter ( {[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]}, [Measures].[APPLICATION INSTANCES VIEW Count] >= 0 ) , 10, [Measures].[APPLICATION INSTANCES VIEW Count] ) ON ROWS
FROM
(select STRTOSET(@.appName) on 0 from [ApplicationUsage] )
WHERE
(([USERS].[WINDOWS LOGON NAME].[UserName]),[DATE].[StartDate].[DateRange])</CommandText>
<QueryParameters>
<QueryParameter Name="startDate">
<Value>=Parameters!startDate.Value</Value>
</QueryParameter>
<QueryParameter Name="endDate">
<Value>=Parameters!endDate.Value</Value>
</QueryParameter>
<QueryParameter Name="users">
<Value>=Parameters!users.Value</Value>
</QueryParameter>
<QueryParameter Name="appName">
<Value>=Parameters!appName.Value</Value>
</QueryParameter>
<QueryParameter Name="chartTitle">
<Value>=Parameters!chartTitle.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>ML_OLAP_DS</DataSourceName>
<rd:MdxQuery><QueryDefinition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"><CommandType>MDX</CommandType><Type>Query</Type><QuerySpecification xsi:type="MDXQuerySpecification"><Select><Items><Item><ID xsi:type="Level"><DimensionName>APPLICATIONS</DimensionName><HierarchyName>APPLICATION NAME</HierarchyName><HierarchyUniqueName>[APPLICATIONS].[APPLICATION NAME]</HierarchyUniqueName><LevelName>APPLICATION NAME</LevelName><UniqueName>[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]</UniqueName></ID><ItemCaption>APPLICATION NAME</ItemCaption></Item><Item><ID xsi:type="Measure"><MeasureName>APPLICATION INSTANCES VIEW Count</MeasureName><UniqueName>[Measures].[APPLICATION INSTANCES VIEW Count]</UniqueName></ID><ItemCaption>APPLICATION INSTANCES VIEW Count</ItemCaption><FormattedValue>true</FormattedValue></Item></Items></Select><From>ApplicationUsage</From><Filter><FilterItems /></Filter><Calculations /><Aggregates /><QueryProperties /></QuerySpecification><Query><Statement>WITH
MEMBER [DATE].[StartDate].[DateRange] AS
AGGREGATE
( STRTOMEMBER(@.startDate) : STRTOMEMBER(@.endDate), [Measures].CURRENTMEMBER
)
MEMBER [USERS].[WINDOWS LOGON NAME].[UserName] AS
AGGREGATE
( {STRTOSET(@.users)} )
SELECT
NON EMPTY { [Measures].[APPLICATION INSTANCES VIEW Count] } ON COLUMNS,
NON EMPTY TopCount ( Filter ( {[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]}, [Measures].[APPLICATION INSTANCES VIEW Count] >= 0 ) , 10, [Measures].[APPLICATION INSTANCES VIEW Count] ) ON ROWS
FROM
(select STRTOSET(@.appName) on 0 from [ApplicationUsage] )
WHERE
(([USERS].[WINDOWS LOGON NAME].[UserName]),[DATE].[StartDate].[DateRange])</Statement><ParameterDefinitions><ParameterDefinition><Name>startDate</Name><DefaultValues><DefaultValue>[DATE].[Startdate].[All]</DefaultValue></DefaultValues><Caption>startDate</Caption><HierarchyUniqueName>[DATE].[Startdate]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[DATE].[Startdate].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[DATE].[Startdate].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[DATE].[Startdate].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [DATE].[Startdate].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>endDate</Name><DefaultValues><DefaultValue>[DATE].[Startdate].[All]</DefaultValue></DefaultValues><Caption>endDate</Caption><HierarchyUniqueName>[DATE].[Startdate]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[DATE].[Startdate].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[DATE].[Startdate].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[DATE].[Startdate].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [DATE].[Startdate].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>users</Name><DefaultValues><DefaultValue>[USERS].[WINDOWS LOGON NAME].[All]</DefaultValue></DefaultValues><Caption>users</Caption><HierarchyUniqueName>[USERS].[WINDOWS LOGON NAME]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[USERS].[WINDOWS LOGON NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [USERS].[WINDOWS LOGON NAME].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>appName</Name><DefaultValues><DefaultValue>[APPLICATIONS].[APPLICATION NAME].[All]</DefaultValue></DefaultValues><Caption>appName</Caption><HierarchyUniqueName>[APPLICATIONS].[APPLICATION NAME]</HierarchyUniqueName><ParameterValuesQuery><Statement>WITH MEMBER [Measures].[ParameterCaption] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[APPLICATIONS].[APPLICATION NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [APPLICATIONS].[APPLICATION NAME].ALLMEMBERS ON ROWS FROM [ApplicationUsage]</Statement><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition><ParameterDefinition><Name>chartTitle</Name><DefaultValues><DefaultValue>Ten Most Used Applications</DefaultValue></DefaultValues><Caption>chartTitle</Caption><ParameterValuesQuery><ParameterizedStatement><ReferencedParameters /></ParameterizedStatement></ParameterValuesQuery></ParameterDefinition></ParameterDefinitions></Query></QueryDefinition></rd:MdxQuery>
</Query>
<Fields>
<Field Name="APPLICATION_NAME">
<rd:TypeName>System.String</rd:TypeName>
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[APPLICATIONS].[APPLICATION NAME].[APPLICATION NAME]" /></DataField>
</Field>
<Field Name="APPLICATION_INSTANCES_VIEW_Count">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField><?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[APPLICATION INSTANCES VIEW Count]" /></DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>4.75in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>

|||No luck yet?|||

It appears to be an error in Books Online: CSV renderer does not render chart data, while XML renderer does. Sorry about confusion.

One way you can export chart data is by applying XSL transformation to the XML data output of the report:

http://msdn2.microsoft.com/en-us/library/aa178953(SQL.80).aspx

Reports cannot be exported to csv format

Hi,

Any help would be appreciated.

Thanks in advance!

No replies yet:(

The only solution we can think about is to develop those many reports in tabular format. (only for CSV format)

Any other solution available?

Thanks!

|||

CSV output should include Chart Data. http://msdn2.microsoft.com/en-us/library/aa178937(SQL.80).aspx

If you are not getting data, make sure to set DataElementOutput to true. Here is a link to how it works for XML.

http://msdn2.microsoft.com/en-us/library/aa179497(SQL.80).aspx

|||

Even I read the first MSDN link where it mentions charts can be rendered to CSV. Thats why I am a bit sure that there may be some setting in the properties, which will show the data values in CSV.

I also tried the setting mentioned in the CSV Device Information Settings and mentioned Encoding value for CSV as ASCII. Restarted SQL Server.

I also set the DataElementOutput property to "Output" but still I am not able to see the expected result.

Please do let me know if there is any solution available.

Thanks!

|||

Chart Data is supposed to be exported to CSV.

Can you attach the report definition so I can take a look and diagnose the problem?

Thanks!

|||

Hi Denis,

Following is the report definition. Hope to find some solution to my problem.

Thanks in advance!

|||No luck yet?|||

It appears to be an error in Books Online: CSV renderer does not render chart data, while XML renderer does. Sorry about confusion.

One way you can export chart data is by applying XSL transformation to the XML data output of the report:

http://msdn2.microsoft.com/en-us/library/aa178953(SQL.80).aspx

Friday, March 9, 2012

ReportItems superimposed on Charts

Can other report items be 'superimposed' on charts' I have a chart and want
to annotate it with text or a table, etc. It works fine within
ReportDesigner - by bringing the report item to the front. The preview in
ReportDesigner looks great. However, when the report is deployed, the report
items appear below the chart when viewed with ReportManager or when
SharePoint. I've tried containing the new report items within a rectangle
positioned on the chart, with no luck.Note: rendering formats like HTML do not support overlapping items.
Therefore, the annotation textboxes etc. will get pushed to the right /
bottom.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:08A1BBCA-066B-4E45-9447-5251CAA0D0AF@.microsoft.com...
> Can other report items be 'superimposed' on charts' I have a chart and
> want
> to annotate it with text or a table, etc. It works fine within
> ReportDesigner - by bringing the report item to the front. The preview in
> ReportDesigner looks great. However, when the report is deployed, the
> report
> items appear below the chart when viewed with ReportManager or when
> SharePoint. I've tried containing the new report items within a rectangle
> positioned on the chart, with no luck.

Saturday, February 25, 2012

Reporting Solutions Charts & graphs needed (similar to Dundas)

Hi my group is checking out charts and graphs available for RS.
We've checked out Dundas but I'd like to know what else is out on the
market and what people have used.
If you have any suggetions, please let me know...I know ChartFX recently introduced charting/graphs for SSRS 2005. I've used
their charts for ASP.NET but haven't checked out their SSRS offerings. It
may be worth a look.
Justin
"jason.harris@.gmail.com" wrote:
> Hi my group is checking out charts and graphs available for RS.
> We've checked out Dundas but I'd like to know what else is out on the
> market and what people have used.
> If you have any suggetions, please let me know...
>|||Dundas is a good one but try SSRS charting and graphs. Excellent but with
some restrictions.
Amarnath
"justinsaraceno" wrote:
> I know ChartFX recently introduced charting/graphs for SSRS 2005. I've used
> their charts for ASP.NET but haven't checked out their SSRS offerings. It
> may be worth a look.
> Justin
> "jason.harris@.gmail.com" wrote:
> > Hi my group is checking out charts and graphs available for RS.
> >
> > We've checked out Dundas but I'd like to know what else is out on the
> > market and what people have used.
> >
> > If you have any suggetions, please let me know...
> >
> >|||I've taken a look at these and we're wanting something a little more
robust. I didn't like Dudas' UI. ChartFX looks good so far. If
anyone has any additional suggestions, I'd appreciate it!|||jason.harris@.gmail.com wrote:
> I've taken a look at these and we're wanting something a little more
> robust. I didn't like Dudas' UI. ChartFX looks good so far. If
> anyone has any additional suggestions, I'd appreciate it!
I tried it. The chart fx stuff had a really nice initial presentation.
If I didn't keep using it after the initial I might have bought it.
But then I used it which is why I went with the dundas chart and gauge
too. What happened you ask? Well, the chart fx software crashed my
visual studio to the point I had to take my battery out of my laptop.
I thought it may have been my toshiba so I kept going. There was no
conversion feature in it like the dundas control so I had to redo all
of my charts. There was no using report parameters or data values for
titles and many more basic features that make this seem like a rushed
product. I was really disappointed in the chart fx software.
The dundas control did not have as flashy of initial impression but it
worked and their support is awesome (they are tight with MS and were
able to prove to me my issues were with SSRS and not their control AND
gave me a link to the right service pack). Their software UI may not
have been using smart tag like behavior but the ui was similar to the
chart in reporting services so there was very little learning. The
dundas chart also had a cool code editor that let me get to the api to
customize the chart where the chart fx control did not.
Basically, at this point I would recommend the dundas chart for
reporting services over the chart fx chart without any question. If
you are just looking for a chart that gives a different look then use
chart fx. If you want an upgrade chart that actually gives more
features, use the dundas chart.
Liam

Monday, February 20, 2012

Reporting Services, Charts with time-scale axis

Hi all,
Firstly sorry if this is the wrong place to be posting
this question ... it's the most appropriate newsgroup I
could find.
I'm creating a report using reporting services and I'm
including a graph thats shows number of times something
is accessed per day over time. Data coming from an SQL
Server 2000 database. The dataset will only have data
records in if the item is accessed ... i.e. if it is not
accessed in a particular day then no record is present.
I've therefore made the chart time-scale in the x-axis to
ensure the scaling is correct. I've even included a union
query to a blank set of data for todays date such that the
graph will always extend up to the current date. The
report has a parameter such that a filter can be applied
to the data to show particular sections only (i.e.
accesses by a particular individual) This all works fine
for when there is a relatively large set of records post
filter and the charts look good.
The problem comes when there is only a small amount of
data, say three points, over a large period of time. The
scaling on the x-axis is correct and runs from the first
data items date up until the current date. The problem is
that the width of each column is massive and spans maybe 7
days. It looks to me as though the width of the columns is
calculated according to the number of the points (in this
example 3) and not according to the number of "time-sacle
points" maybe 100. The result is three hugely wide bars
each spanning a weeks worth of dates with the left hand
edge on the date of the actual event.
I could try and introduce zero data into the data set for
each of the intervening dates but didn't want to go to
through the overhead of calculating all this unnecessary
data ... that is after all the point of a time-scale axis.
Would appreciate it is anyone has any experience in this
or ideas I could try.
Thanks in advance (and for reading this far!)
Matt.
Matt,
Just to let you know that there is an RS group: .reportingsvcs. I think you have much better change
to get good help there.
Yesterday I read a post referring to editing the rdl file and pitting in the width there. Check the
archives, search for <PointWidth>.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt Williams" <anonymous@.discussions.microsoft.com> wrote in message
news:064501c49af9$4753e070$a401280a@.phx.gbl...
> Hi all,
> Firstly sorry if this is the wrong place to be posting
> this question ... it's the most appropriate newsgroup I
> could find.
> I'm creating a report using reporting services and I'm
> including a graph thats shows number of times something
> is accessed per day over time. Data coming from an SQL
> Server 2000 database. The dataset will only have data
> records in if the item is accessed ... i.e. if it is not
> accessed in a particular day then no record is present.
> I've therefore made the chart time-scale in the x-axis to
> ensure the scaling is correct. I've even included a union
> query to a blank set of data for todays date such that the
> graph will always extend up to the current date. The
> report has a parameter such that a filter can be applied
> to the data to show particular sections only (i.e.
> accesses by a particular individual) This all works fine
> for when there is a relatively large set of records post
> filter and the charts look good.
> The problem comes when there is only a small amount of
> data, say three points, over a large period of time. The
> scaling on the x-axis is correct and runs from the first
> data items date up until the current date. The problem is
> that the width of each column is massive and spans maybe 7
> days. It looks to me as though the width of the columns is
> calculated according to the number of the points (in this
> example 3) and not according to the number of "time-sacle
> points" maybe 100. The result is three hugely wide bars
> each spanning a weeks worth of dates with the left hand
> edge on the date of the actual event.
> I could try and introduce zero data into the data set for
> each of the intervening dates but didn't want to go to
> through the overhead of calculating all this unnecessary
> data ... that is after all the point of a time-scale axis.
> Would appreciate it is anyone has any experience in this
> or ideas I could try.
> Thanks in advance (and for reading this far!)
> Matt.
|||Thank you very much for your help ... it gives me
somewhere to start ...
Matt.

>--Original Message--
>Matt,
>Just to let you know that there is an RS
group: .reportingsvcs. I think you have much better
change
>to get good help there.
>Yesterday I read a post referring to editing the rdl
file and pitting in the width there. Check the
>archives, search for <PointWidth>.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Matt Williams" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:064501c49af9$4753e070$a401280a@.phx.gbl...
not[vbcol=seagreen]
to[vbcol=seagreen]
union[vbcol=seagreen]
the[vbcol=seagreen]
applied[vbcol=seagreen]
fine[vbcol=seagreen]
post[vbcol=seagreen]
The[vbcol=seagreen]
first[vbcol=seagreen]
is[vbcol=seagreen]
maybe 7[vbcol=seagreen]
columns is[vbcol=seagreen]
this[vbcol=seagreen]
sacle[vbcol=seagreen]
for[vbcol=seagreen]
unnecessary[vbcol=seagreen]
axis.[vbcol=seagreen]
this
>
>.
>

Reporting Services, Charts with time-scale axis

Hi all,
Firstly sorry if this is the wrong place to be posting
this question ... it's the most appropriate newsgroup I
could find.
I'm creating a report using reporting services and I'm
including a graph thats shows number of times something
is accessed per day over time. Data coming from an SQL
Server 2000 database. The dataset will only have data
records in if the item is accessed ... i.e. if it is not
accessed in a particular day then no record is present.
I've therefore made the chart time-scale in the x-axis to
ensure the scaling is correct. I've even included a union
query to a blank set of data for todays date such that the
graph will always extend up to the current date. The
report has a parameter such that a filter can be applied
to the data to show particular sections only (i.e.
accesses by a particular individual) This all works fine
for when there is a relatively large set of records post
filter and the charts look good.
The problem comes when there is only a small amount of
data, say three points, over a large period of time. The
scaling on the x-axis is correct and runs from the first
data items date up until the current date. The problem is
that the width of each column is massive and spans maybe 7
days. It looks to me as though the width of the columns is
calculated according to the number of the points (in this
example 3) and not according to the number of "time-sacle
points" maybe 100. The result is three hugely wide bars
each spanning a weeks worth of dates with the left hand
edge on the date of the actual event.
I could try and introduce zero data into the data set for
each of the intervening dates but didn't want to go to
through the overhead of calculating all this unnecessary
data ... that is after all the point of a time-scale axis.
Would appreciate it is anyone has any experience in this
or ideas I could try.
Thanks in advance (and for reading this far!)
Matt.Matt,
Just to let you know that there is an RS group: .reportingsvcs. I think you have much better change
to get good help there.
Yesterday I read a post referring to editing the rdl file and pitting in the width there. Check the
archives, search for <PointWidth>.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt Williams" <anonymous@.discussions.microsoft.com> wrote in message
news:064501c49af9$4753e070$a401280a@.phx.gbl...
> Hi all,
> Firstly sorry if this is the wrong place to be posting
> this question ... it's the most appropriate newsgroup I
> could find.
> I'm creating a report using reporting services and I'm
> including a graph thats shows number of times something
> is accessed per day over time. Data coming from an SQL
> Server 2000 database. The dataset will only have data
> records in if the item is accessed ... i.e. if it is not
> accessed in a particular day then no record is present.
> I've therefore made the chart time-scale in the x-axis to
> ensure the scaling is correct. I've even included a union
> query to a blank set of data for todays date such that the
> graph will always extend up to the current date. The
> report has a parameter such that a filter can be applied
> to the data to show particular sections only (i.e.
> accesses by a particular individual) This all works fine
> for when there is a relatively large set of records post
> filter and the charts look good.
> The problem comes when there is only a small amount of
> data, say three points, over a large period of time. The
> scaling on the x-axis is correct and runs from the first
> data items date up until the current date. The problem is
> that the width of each column is massive and spans maybe 7
> days. It looks to me as though the width of the columns is
> calculated according to the number of the points (in this
> example 3) and not according to the number of "time-sacle
> points" maybe 100. The result is three hugely wide bars
> each spanning a weeks worth of dates with the left hand
> edge on the date of the actual event.
> I could try and introduce zero data into the data set for
> each of the intervening dates but didn't want to go to
> through the overhead of calculating all this unnecessary
> data ... that is after all the point of a time-scale axis.
> Would appreciate it is anyone has any experience in this
> or ideas I could try.
> Thanks in advance (and for reading this far!)
> Matt.|||Thank you very much for your help ... it gives me
somewhere to start ...
Matt.
>--Original Message--
>Matt,
>Just to let you know that there is an RS
group: .reportingsvcs. I think you have much better
change
>to get good help there.
>Yesterday I read a post referring to editing the rdl
file and pitting in the width there. Check the
>archives, search for <PointWidth>.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Matt Williams" <anonymous@.discussions.microsoft.com>
wrote in message
>news:064501c49af9$4753e070$a401280a@.phx.gbl...
>> Hi all,
>> Firstly sorry if this is the wrong place to be posting
>> this question ... it's the most appropriate newsgroup I
>> could find.
>> I'm creating a report using reporting services and I'm
>> including a graph thats shows number of times something
>> is accessed per day over time. Data coming from an SQL
>> Server 2000 database. The dataset will only have data
>> records in if the item is accessed ... i.e. if it is
not
>> accessed in a particular day then no record is present.
>> I've therefore made the chart time-scale in the x-axis
to
>> ensure the scaling is correct. I've even included a
union
>> query to a blank set of data for todays date such that
the
>> graph will always extend up to the current date. The
>> report has a parameter such that a filter can be
applied
>> to the data to show particular sections only (i.e.
>> accesses by a particular individual) This all works
fine
>> for when there is a relatively large set of records
post
>> filter and the charts look good.
>> The problem comes when there is only a small amount of
>> data, say three points, over a large period of time.
The
>> scaling on the x-axis is correct and runs from the
first
>> data items date up until the current date. The problem
is
>> that the width of each column is massive and spans
maybe 7
>> days. It looks to me as though the width of the
columns is
>> calculated according to the number of the points (in
this
>> example 3) and not according to the number of "time-
sacle
>> points" maybe 100. The result is three hugely wide bars
>> each spanning a weeks worth of dates with the left hand
>> edge on the date of the actual event.
>> I could try and introduce zero data into the data set
for
>> each of the intervening dates but didn't want to go to
>> through the overhead of calculating all this
unnecessary
>> data ... that is after all the point of a time-scale
axis.
>> Would appreciate it is anyone has any experience in
this
>> or ideas I could try.
>> Thanks in advance (and for reading this far!)
>> Matt.
>
>.
>

Friday, March 30, 2012

ReportViewer graphics and charts do not display in aspx page

Monday, March 12, 2012

Reports cannot be exported to csv format

Reports cannot be exported to csv format

Friday, March 9, 2012

ReportItems superimposed on Charts

Saturday, February 25, 2012

Reporting Solutions Charts & graphs needed (similar to Dundas)

Monday, February 20, 2012

Reporting Services, Charts with time-scale axis

Reporting Services, Charts with time-scale axis

Deserialization Failed

Blog Archive

About Me