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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

sql 2005 chart report

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

Hi i am using sqls 2005,i have creted a Bar chart

MY x axis contained report name and Y axis contain number of user who have access those reports

i am getting proper data at X axis but at Y axis i am getting data in ackward range ie 5 ,84 ,163,251,321

but these are the number of user who have aceess the report ,i want them to come in this patter..5,10,15,20,25...etc
or 10.20,30,40..etc in any of the above 2 patter..what should i do to achieve this in sql  2005 bar char reports 

View Complete Post

More Related Resource Links

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

crystal report -visual studio 2008 dual axis chart (bar & line)


dear all, 

i use crystal report integrated with  vs.2008, and i want to make chart with dual axis (bar & line).

i have used bar chart and input the data with 2 values..

then in chart options > template, i activated the dual axis..

my question is, how i can change the 2nd value with line chart not bar chart??

i'd tried to find the right settings in "chart options" but still can't find the solution.

for information in "chart options" there are 4 sub menu : template, general,titles,grid..

i read in a tutorial there's more sub menu called "series" in crystal report (stand alone version)..

is it possible doing it in Crystal Report VS. 2008?

please,, i need your advice and solution..

Thanx before..


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Converting Crystal Report 2005 to 2008 - Please Tell Me I'm Stupid :)


Hello peeps,

  I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues.  The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues.  The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file.  I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.

  Is this normal?  Is there an easy conversion method that I'm simply overlooking?  Am I screwed?  Who invented liquid soap, and why?

Answers to any of these questions would be greatly appreciated...

Adding a Chart to a Local Report


Dear All

I have created a report as a local report which looks like this:

I'm trying to add a chart to this report and I'd like it to display something like this (so sorry for the crude drawing):

It seems like it should be quite straight forward but I've tried dragging the fields into the chart all different ways and can't make it happen. I'm using Visual Studio 2010 and here's what my list of fields from the dataset look like:


I thought ObservationYear would be the series and all the other fields would be the data but this doesn't work. It produces a chart like this which wasn't what I was hoping for:

Please could you help me understand what it is I'm doing wrong? I'm very grateful for any help/advice you might be able to provide.

Kind regards








Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

How to generate pdf from 2005 rdl report files from command prompt?

Hi All, I have a scenario like this, i have 10 rdl reports, which needs to run on a job basis with out any user interaction. Tell me is there any way to generate the pdf from command prompt using existing 2005 rdl files. Your help is more appreaciated!! Thanks, Sarvesh M  Sarvesh

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

SSRS 2005 Drillthrough chart Passing Wrong parameter value

Hi I have a drillthrough report that in Report A I have a week of data, showing Sunday through Saturday on the X-axis. When a data point is clicked on this chart, it shpuld pass the date of the weekday for that data point to Report B. But sometimes, it passes the prior weekday date, eg click on the Monday date data point, but Sunday's date is passed to the next report. Has anyone observed this type of behavior? I should mention that it is intermittent.   Thanks all.   Bobrpress

SSRS 2005 conditional count in chart

Hi, I have a column chart in which I want to display the % of Invoiced Sales in 24 hours and % of Not Invoiced Sales in 24 hours. The data should be categorized by date, so for each date I can see the % of invoiced and not invoiced sales within 24 hours. My dataset contains: sales id, sales status (only invoiced are permitted and I took care of that in my query), date and I have the nbDays which is bound to a function that determinate if the sale is invoiced in 24h. So if the nbDays < 3 it's in 24h otherwise it's not. I want my chart to display for each date two column: 1- for invoiced in 24, 2- not invoiced in 24 h. So, I drag the date fields to Category fields area and sales id twice to Data fields area. The idea is to use one for invoiced in 24h and the other is for the other case.   So, I want to know how can I write a conditional expression to get this requirement done and make the data fields sales id displays data according to my condition: I tried this but it didn't work: =count(iif(fields!nbDays.value <3, 1,0))  and also the: =iif(fields!nbDays.value <3, count(fileds!salesid.value),0)   any suggestions will be welcomed and appreciated...

creation of Chart in report ssrs 2008

HI All, I have to create report based on the chart in ssrs 2008 in which i have to use different bar for different coulmn,Kindly suggest how to start the same.   Shraddha

Trouble to connect report on SSAS 2005

Hello! I have deployed my first report (ssrs2008) using a ssas (2005) cube as data source but I can't get it to work. I setup the credentials to use Windows Authentication in the SSAS data source and when I open the report from the rs server it renders fine, however when I try it from a workstation I get the error below: The SSRS instance is not on the same server as SSAS. Any Clue? Thanks! Cannot create a connection to data source 'TestCube'. The connection either timed out or was lost. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host

2008 Report not working on 2005 report server


Hello, I have been researching this issue and it seems if I have created a report using 2008, I cannot upload it to a 2005 report server.

I just wanted to check and see if I have any other options than to re-create the report using 2005? Would copy/paste of the XML from 2008 to 2005 work?

Thanks! Linda


SSRS 2005 Report with 7 subreports


I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.

RegionID  CustID orderID  OBID     State      City       Name
69            1230    4565      75855    NY         NYC       Sam

Now i need to pass these values in subreports's query as parameter
something like
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.

Any suggestions would be very helpful.

Thank you,

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