Hi all,
I have done 2 charts.while clicking one chart it is navigating to another chart. it is working in Report Server.
But using this graph in the UI page(putting Iframe and calling reports) it is not navigating to another chart.
Can u guys help me to solve the problem
Thanks in advance.
Hello
Is it possible to navigate by clicking on a graph to another report. If so how?
Thanks
Inder
Is anyone using SQL server to navigate their public web site?
We are concerned about having a database hit every time the user chooses a different page from our navigation bar.
Any advice? Experience with this?
Hello All,
I am viewing the report in Reporting Manager. It has four tabs at the top viz. View, Properties History and Subscription. When I click any one of Properties, History or Subscription and click the View tab again, I loose my dataset that was there before I started clicking the tabs. It prompts for the parameters again.
Is that by design? I find this a nuisance to enter the parameter again and run the report just because I navigated to a different tabs.
Any suggestions to alter this behavior to make the data sticky in the report?
Thanks
Phewa
I have a XML file (download XML File below at URL) stored in a SQL Column of XML type. The column with the XML file is named CurrentPackageXML in a table called dbo.
View 19 Replies View RelatedHi I have a matrix table with
Status as the row heading and month as the column heading. The detail is a count off the records which fall into these statuses and the month columns.
The detail also contains a navigation link to a subreport which returns the records which make up the count.
For example if the detail contains a 7 , when i click on the 7 it returns 7 records with details off these records. The subreport accepts 2 parameters which is passed over from the navigation link, the parameters are - status id and month.
My question is - I have put a total on the matrix for the month columns, when i click on the total value the subreport appears (as the total is treated as part off the details) but it does not return the correct number off records. Im unsure as to why the total would not return all records , but it seems it is not passing the month parameter correctly, it seems to not to know to pass 'all' months which appear on the matrix as it is the 'total'. It seems to get confused and returns records only for a particular month. I thought the matrix would be smart enough to know that when a total has a navigation to return all records.
Can someone please help
thanks
Hi,
I'm having problems navigating from one report to another one if the second report has a multi-valued report parameter. When I navigate to the second report, I don't pass any parameters, but I get an error "parameter is missing a value" for the multi-valued report parameter. I have it setup as allow "multi-value" and "blank value". Any idea what the issue might be?
Thanks.
Hi all ,
i need to have outside label position for my data in 3d pie chart. How can i implement outside labelling?
Thanks
I have created a bar graph but cannot find a way to change the bar's color for different series.
I have a graph which has sales men and their sales between dates
Thanks for your help
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
hi,
I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this.
thanks,
naveen
Hi All,
I'm using DTS in Sql Server 2000 for the first time, and would like to create Ad-Hoc reports with Pie/Charts and graphs. Is this possible in SQL Server/DTS, or would I need something like Cyrstal Reports?
Thanks!
Matt
Hi
I have developed some line charts in reporting services with some parametrs
On the bottom axis is the month and the upper is no. hours.
The problem is that when i select certain parametrs becaus there is no data for that month the line just ends and then starts at a new month.
Does anyone know anyway of telling it to go to zero if there is no data for it so there is a continous line
Thanks
Can you loop through the records of one dataset and create a chart for each record?
View 2 Replies View Related
Hi,
How can we use the line chart in the Sql Server Reporting Services 2005.
Please explain about the each and every properties in chart control.
Thanks In Advance
Shoba
Does anyone here use 3rd party graphs and charts for SSRS 2005?
What do you use? Is there a superior package out there?
Thanks
-JW
I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data.
Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on? My best guess is that this is a memory issue on the server side...
Friends,
I have a requirement in Bar charts using SSRS...Assume that I have 3 Products Quantity and the representation will look like following
A - 10
B- 20
C-15
Though it is easy to develop this as a bar chart...The requirement is that a Product Perfomace should be represented using Images in the chart area...Instead of showing that A has 10 quantitites in a single bar, a general product image should be coming in the place of 10 and same with the case of B and C.. I have used smiley icons here for clarity
The look of the chart should be like following
|
|_________________
|_________________|
|
|________________________________
|________________________________|
|
|______________________
|______________________|
|_________________________________________________
Please let me know if there is a way to customize this bar chart using SSRS Charts...Thanks in Advance
Hi,
I am upgrading all my access reports to reporting services. One of my access reports, contains a chart which is set a a multiple chart (so I can see a chart of data for each day in the data set). Is it possible to do the same using the SQLserver 2005 chart component?....I cannot see an obvious button to press which makes a single chart a multiple one.
If this is not possible in vanilla reporting services, can anyone suggest a thrid party add-in that will rovide the functionality I want? (cheaply lol!)
Cheers,
Kevin.l
I have a pie chart which is been populated from a sproc.
and for a particular fund the values that generate are 78%,20% and 2% respectively.
And when it generates a chart the pie chart is uniformly displayed... Like for eg.. its been broken into 3 parts and there isnt a difference between the 78% and the 2% so ... How can i get the pie chart to be a displayed according to its values..
Any help will be appreciated..
Regards
Karen
Hello,
I am attempting to create a line chart for a report.
Are there any detailed white pages that discuss this particular chart type in detail? So far most of the documentation I have seen fails to cover the extent of the properties available in a chart and the terminology is unfamiliar to me.
What I need to know is how to integrate the chart into an existing table and within a group, plus be able to change the y-band scale to match the particular data being returned by that grouping.
Is this something better suited towards a subreport inserted into the detail band or inserting a rectangle then the chart itself forgoing the use of a subreport?
Any documentation would be appreciated, step by step approaches would be even more helpful.
Thanks.
Hi,
I am creating some earned value reports that display project budget, actual cost to date, projected cost, and earned value. I have all of the data stored by month so I am using the Running Value function to display the data on a graph such that at any given point on the graph, it is showing total dollars as of that date. This works great for a single project or a summation of projects.
I also want the ability to create a batch set of reports for a series of projects, basically they input a list of project numbers, and a new graph is generated for each one. To do this, I created a "batch report" that has a subreport in a table's group with project id being the grouped on field, it passes that project id to the subreport as input.
I get exactly what I want - a new report for each project, but the problem is, running value on the graphs is not working across the projects. It's fine for the first project, but all subsequent projects are getting messed up. For instance, one project with a max budget of 200K is showing with a max budget of 400K, actuals are getting nulled out, etc. It's as if for some reason, the RunningValue isn't getting reset across the subreport....
An example of my value field on one of the lines (not copy and pasted so forgive any syntax errors - I'm not on my development box):
Code Snippet= Iif(MAX(Fields!actual_de.Value + Fields!actual_work.Value) >0, RunningValue(Fields!actual_de.Value + Fields!actual_work.Value, Sum, FakeSeries), Nothing)
(The point of the max is so that the graph stops on months without actuals - that is months that haven't occured yet)
My FakeSeries is just on projectID and is just for the purpose of resetting the Running Value (or so I thought).
Does anyone have any input or advice on how to get this working? Why is RunningValue getting messed up across subreports? If I only give the batch report one project ID, the data is great. (I know it's the running value because if I take out running value and just graph the SUM - all the values are correct). If anyone has an alternate way of doing this sort of batch report I'm all ears as well!
Thanks much!
Jen
I'm having problem with Charts
any good website or books i can read up on
just can't anything good on charts
I need to use 2 pie chart and 1 bar chart but i can't get it to work like i wanted to
I'm not sure what Series and Category is used and how to stack the fields in the Charts
Hi,
Is it possible to fix the max width of the columns ?? Sometime the report only generates 1 or 2 columns and it looks a bit odd as they're stretched to the width of the page.
Also, when we have a large number of culumns, say 20 odd, the legend text get's real squashed up and un readable, are there any tips/tricks so i can have more flexibility over what's displayed ?
thanks
Steve
Hello,
My 3D bar charts don't look as good as they could because the bars are too thick when displayed in 3D (depth-wise). If I have many bars, the bars are very thin on the front, and then go back far too much. Has anyone played with the settings to see how to optimize this? Even with 5% rotations, it is still too thick for my taste and doesn't look like the previews in the designer.
Mike
Hi,
We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.
But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.
Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?
Can I specify the value of n somewhere in the propeties?
I read through many posts regarding pagination but those couldn't help me much.
Please help me in solving this problem.
Any help would be appreciated.
Thanks in advance!
Hi,
Can you please solve my below problem.
I have a data in the report with one column having hyperlink. And below am showing Pie chart with respect to Whole data in the same report. But I want to view for particular value which has to reflect in Chart.
Very Very very Urgent...
Any help would be appreciated.
Thanks
Dinesh
I have two questions regarding in-line bar charts...
First, I put the text as data labels and check 'Auto' for positioning, most of the time the text is written to the right of the bar (which is what I want). However, there is one case that if the space to the right of the bar is not enough for the text, it starts writting on the bar itself.... is there a way I could set it so that the text only appears when there is enough space to the right, so that text never appears on any bars?
Secondly, is there a way I could put hyperlinks on the text?
Thanks again,
Steven
Hi All,
what I want is a custom Legend for the Pie Chart.
I have followed this article and have done what was written under
Custom Chart Color Palettes and Legends
http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4
But still the color of the legend is not uniform.
Basically I am using a stored procedure which returns two values : Circle, Total based on a parameter called Customer.
1. I have pasted the code asked in the Code Section of the report.
2. Have Disabled the 'Show Legend' box in Chart Properties.
3. Have included the following code in the Values->Appearance->Series Styel->Fill
=Code.GetColor(Fields!Circle.Value)
4. In the Category groups ->Group on-> this is my expression =Fields!Circle.Value (Basically I am not sure where
should I include Circle Field. I have tried this both by putting it in Category Groups and Series Groups.)
5. Dragged and dropped new table and have done the following
a.table1->Properties->Groups->Add->General->Group on Expression Fields!Circle.Value
b.Deleted Detail row.
c.Dragged and dropped rectangle in the column value and set the background value to =Code.GetColor(Fields!Circle.Value)
When I run the report for different customers the colors are not remaining constant. I have 17 values for Circles. So included three more colors in the "colorPalette " variable..
After doing all this still I am not able to get the same colors. Could someone tell me where I am going wrong?
Hi,
I am new to reporting services and I am stuck. I have a report I am trying to design, it has startdate and end date as parameters, I als have a non-queried parameter with the values of month,week,user,hour. These parameter values create a drowndown box on the report, What I am trying to figure out is how to display information in a chart depending on which item is selected i.e (month,week,user etc....). The original report is in access and I am converting it to reporting services, I know there is third party software out there but, I really want to use reporting services.
Hi,
With Report Builder, I created a basic chart using the chart Wizard..
I am wondering If I can create some 5 charts on a Single Page(Webpage), like a Mini Dashboard.
Can someone please guide me in this regard ?
Thanks in Advance for your help.
Regards,
Sundar
Hi there!
I have a certain scenario and would like to know if it would be recommendable to try and realize it through RS.
I have a matrix of sales data (countries, regions, categories, total sales, Year-To-Date, changes, etc.) that need to be shown on charts. The charts themselves have a single format (bars). The out put needed is a relatively large number of charts (3000+) that would allow for a great number of comparisons (country to country, region to region, etc.). All these charts share a single layout. What would be varying greatly are the values and the labels attached to the elements on the chart (labels of the bars, title of the chart, legend, footnotes, etc.)
My plan is the follwoing:
- create a .net module that would prepare the data for the chart. This would be done with two tables
- parent table with general information
- child table with the the values for the bars and the labels
- Create a parametrized report in RS that accepts the Id of a report from the parent table
- Call this report for each and every report that can be found in the parent table
I would really appreciate any information of the feasabilitiy of this plan. I have worked a lot with Crystal before, but I don't have it anymore and will be using RS from now on. I haven't really started working with RS as of yet, but would need to know if this is "doable" with RS!
Thank you very much in advance for your replies!
Greetings
NB
hey there
Happy New Year to you all.
in RS 2005
in layout tab
I have four columns in my table
col 1 (group on Company)
col 2 (group on application)
col 3 (count on id no) // total field (count/idno) // max/idno)
col 4 (graph) as I want this to show line by line (visual statement)
I read you need to put that max field in to help with graph. in the Y axis Max field
Unfortunately I either didn't read it properly or I am doing something really wrong.
My graph is not showing correctly - eg one line has 2 in it and is showing more than a line that has 227.
call id is in data of the graph
company name is in series of the graph
can someone explain what I am doing wrong please
thanks
jewel