Showing posts with label chart. Show all posts
Showing posts with label chart. 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!
> >
>
>

ReportViewer Export PDF (Huge size) Workaround

If you have a chart or image in your reportviewer and you want to export file in PDF format, you will have an unusable big size pdf file.

Here is a work around fromsnapApps:(1/19/2007)

"snapApps createda solution for this problem. It involves disabling the export featurefrom the reportViewer toolbar and rendering the PDF through a custombutton. That's the easy part. Then you just use our PDFCompress libraryto compress the image streams contained within the PDF. You candownload PDFCompress athttp://www.snapapps.com/Components.aspx."

Hope this helps someone.

Hi,

I found a possible solution for this:

Download Orcas 2 Beta (I used the Virtual PC image, but the regular installation should work)

Look for:

Microsoft.ReportViewer.Common.dll

Microsoft.ReportViewer.WebForms.dll

Microsoft.ReportViewer.ProcessingObjectModel.dll

Note that the ProcessingObjectModel is in the global assembly cache. The way I was able to copy it was by going to the command line and doing adir Microsoft.ReportViewer.ProcessingObjectModel.dll /sin the root of the c drive. Then I found the location of the file, changed directory and copied the file to a previously created directory.

Make sure that the files that you pick are version 9.0.0.0!

Copy all those files and add the references in your VS2005 project. It seems that the ReportViewer version 9.0.0.0 which is in Orca is compatible with .NET 2.0.

Next, replace all references to 8.0.0.0 in any page that uses the report viewer with 9.0.0.0. Also, the web.config file has a reference to report viewer, make sure you substitute 8.0.0.0 for 9.0.0.0.

I have tested this method and it works. Make sure that the bin directory of your deployed application has the three files above.

Wednesday, March 21, 2012

Reports with OLAP Cubes

Hi

I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem?

It would help if you could provide more details of what exactly does not work.


Maybe the data values are coming across as strings rather than numeric values? Try to convert the datatype for the datapoint expressions. E.g. =Sum(CDbl(Fields!Measure.Value))

-- Robert

|||

Hi,

I have a OLAP report with a table. I need to display a chart on click of particular cell in the table wihtin the same report. How to pass the parameter from the table to the chart and display it in the same report? Pls help me in solving this

Reports with OLAP Cubes

Hi

I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem?

It would help if you could provide more details of what exactly does not work.


Maybe the data values are coming across as strings rather than numeric values? Try to convert the datatype for the datapoint expressions. E.g. =Sum(CDbl(Fields!Measure.Value))

-- Robert

|||

Hi,

I have a OLAP report with a table. I need to display a chart on click of particular cell in the table wihtin the same report. How to pass the parameter from the table to the chart and display it in the same report? Pls help me in solving this

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 views

Hi
We are using SQL reporting services as the reports engine on our projects.
Some reports come with a table view and a chart view. User wants to see
(print) the table report first by default. The chart report is optional.
The original approach is to have a link (button) on the first report; user
can click on it to see the chart report. However, since two trips will be
made to the data source, user might see different data because of the delay.
Is there a way to avoid that? We want two reports to have the same data.
Does SQL reporting service provide "Views"? So users can retrieve the
report and select different views without going back to the data source?
Thanks in advance!You can't build two different reports on the same query execution but what
you could do is have both the table and the chart in the same report. Set
the visibility propery on each to a parameter that tells which to display.
Have a link on the report that toggles between them.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Huang" <jianh@.avanade.com> wrote in message
news:unjgemapEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi
> We are using SQL reporting services as the reports engine on our projects.
> Some reports come with a table view and a chart view. User wants to see
> (print) the table report first by default. The chart report is optional.
> The original approach is to have a link (button) on the first report; user
> can click on it to see the chart report. However, since two trips will be
> made to the data source, user might see different data because of the
> delay.
> Is there a way to avoid that? We want two reports to have the same data.
> Does SQL reporting service provide "Views"? So users can retrieve the
> report and select different views without going back to the data source?
> Thanks in advance!
>

Monday, February 20, 2012

Reporting Services, pivot function or union on MDX

I have to build a rather simple report with only one chart. The chart has to show a 100% stacked bar chart, with the VBS members as series.

I have 2 measures, subscriber count and total revenue. Now I want 2 bars: a first one showing the vbs stacks on subscriber count and a second one showing the vbs stacks on total revenue.

Because subscriber count and total revenue are measures, I cannot add them to the categorie fields in reporting services.

This means that I have to somehow perform a sort of pivot function on my mdx query, or a kind of union to create a record per measure.

This is the basic mdx query I have now:

SELECT NON EMPTY { [Measures].[Total Net Rev], [Measures].[Subscriber Count] } ON COLUMNS, NON EMPTY { ([Dim Vbs].[Vbs].[Vbs].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@.DimMcoMco, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@.DimTimeTimeHierarchy, CONSTRAINED) ) ON COLUMNS FROM [RaceSegments])) WHERE ( IIF( STRTOSET(@.DimTimeTimeHierarchy, CONSTRAINED).Count = 1, STRTOSET(@.DimTimeTimeHierarchy, CONSTRAINED), [Dim Time].[Time Hierarchy].currentmember ), IIF( STRTOSET(@.DimMcoMco, CONSTRAINED).Count = 1, STRTOSET(@.DimMcoMco, CONSTRAINED), [Dim Mco].[Mco].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Thanks

Joos

Anybody?

I need a 100% stacked chart with 2 bars. One for subscriber count and one for Total Net Revenue. I would like to visualize the distribution of the VBS dimension members within each bar.

To make it easier...this is the mdx query without any parameters:

SELECT NON EMPTY { [Measures].[Total Net Rev], [Measures].[Subscriber Count] } ON COLUMNS, NON EMPTY { ([Dim Vbs].[Vbs].[Vbs].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [RaceSegments] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS