.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

RE:SSRS charts

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
Hi currently i am displaying data from the database in a gridview.Now i want to pass the gridview columns as parameters to rdlc file to get smoothline charts on the fly.dynamically i hav date coulmnand some x,y,z.... coulmns coming in the grid everytime.so now i want to bind the date coulmn of a grid to X-axis default and y-axis as a dropdown of rest of the columns from grid.so that wen the user selects a column from the ddl a grapg is genegated on the fly.If there is a chance of having multiple y-axis with diff colors is gud iguess.I hav achieved untill displying data in grid.can any 1 help me how to proceed next..pls.....i would be greatful.....thnks!!!!!!!! 


View Complete Post


More Related Resource Links

Charts and graphics with SSRS?

  
Can you do charts and advanced graphics with ssrs?

SSRS charts not displaying in dashboard, But only matrix controls

  

Hi
  We are facing a strange problem. We have developed a dashboard using Sharepoint 2007, Custom report viewer and
SSRS 2008. Due to unknown reason the custom report viewer was not able to show reports from reporting service
through default authentication. I mean with the credential of the logged-in user in sharepoint site. So we
hard coded one of the credential detais in the webpart so that we are able to see the reports through
sharepoint dashboard.

Now the problem is

1. if the user whose credentials are hard coded on the custom web part logs in to any machine.
         a. He opens the sharepoint site with his credentials. he can see everything fine, means reports with table control and reports with charts.

         b. He signs out of the site and some other user signed in to the site. he can see everything fine, means reports with table control and reports with charts.


2. The user whose credentials are hard coded signs out of the machine itself. And some other user logs in to the machine.
  a. He opens the sharepoint site with his credentials. he can see reports with table control, but he cannot see reports with charts.

     &nbs

SSRS charts not displaying in dashboard, But only matrix controls

  

Hi
  We are facing a strange problem. We have developed a dashboard using Sharepoint 2007, Custom report viewer and
SSRS 2008. Due to unknown reason the custom report viewer was not able to show reports from reporting service
through default authentication. I mean with the credential of the logged-in user in sharepoint site. So we
hard coded one of the credential detais in the webpart so that we are able to see the reports through
sharepoint dashboard.

Please find the image at

http://binabdu-fayaz.blogspot.com/2010/09/ssrs-charts-not-displaying-in-dashboard_24.html

Now the problem is

1. if the user whose credentials are hard coded on the custom web part logs in to any machine.
         a. He opens the sharepoint site with his credentials. he can see everything fine, means reports with table control and reports with charts.

         b. He signs out of the site and some other user signed in to the site. he can see everything fine, means reports with table control and reports with charts.


2. The user whose credentials are hard coded signs out of the machine itself. And some other user logs in to the machine.

SSRS -Charts border issue

  
I have five charts in one rdl file in SSRS reports and while exporting to word the border of the charts is coming incomplete.please advice.

SSRS 2008 R2 Charts Not Rendering Correctly (Clipped)

  
When I add charts and gauges to my reports they are always clipped. The bottom and right hand portions don't appear on the report. It appears they are being rendered too large. No matter how big I make the chart, gauge, report it gets clipped. However, if I export to PDF or Excel the full chart (didn't try the gauge) does appear. I have reproduced this IE8 and Firefox. I am running everything on a Windows 7 machine.

Ssrs Bar charts

  

I have bar chart it shows month names on x-axis and  frequency in percentage an application  is used on y-axis . It now shows each month seperately  meaning aug 13% sep 4% oct 8% I would like it to show aug 13% sep 17% oct 25% meaning cumulative addition on x- axis for the months. can you please help me.

Thanks


Adding Checkbox in Legends of SSRS Charts

  

All

I want to use an interactive legend which allows to enable/disable series by clicking a checkbox, Can any one help me out how to add an Check box in Legend .

Thanks

 


where can i download from SSRS?

  

Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?

 

Thanks in advance

Suresh


MDX Query parameter from SSRS

  

Hello,
I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )

 

 


How to change text in columns in SSRS?

  

I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.


Extreme UI: Line Charts with Data Templates

  

Charles Petzold continues his investigation into robust XAML coding made possible by Windows Presentation Foundation, this time tackling the complicated process of creating line charts.

Charles Petzold

MSDN Magazine January 2010


ASP.NET: Create Snazzy Web Charts and Graphics On the Fly with the .NET Framework

  

Knowledge workers can understand data more effectively when raw numbers are presented in a graphical format. This is especially true when displaying database information on a Web page, where a simple chart can make the difference between a dry presentation and a vivid data source. In the past, creating dynamic, data-based charts on the fly in ASP required purchasing a third-party, image-generating COM component. Now with ASP.NET, developers can access the .NET Framework's drawing classes directly with C# to create dynamic images and charts.

Scott Mitchell

MSDN Magazine February 2002


Is Conditional Subscription possible in SSRS 2005?

  

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???

 


SSRS 2005 "Mixed" Authentication Mode

  

I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?


SSRS 2008 R2 and sharepoint 2007 report builder problems

  

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu


SQL 2008 servers and MOSS 2007 with SSRS

  

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend