how can i place a text box on top of a chart.
I placed text box in a chart but while loading the reoport in a asp page the text box comes down to the bottom of the chart.
If anybody knows it,then please help me out.
Hello All,
I have a reporting services report in the form of a chart. I have two datafields on the chart.
I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.
How do I do this ?
Any help would be appreciated..
Thanks!
When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.Is there any other method or product we can use instead of the office writer.
View 2 Replies View RelatedI have a report designed in SSRS 2008 R2.My issue is that the data labels do not stay outside the bars for high values.
View 4 Replies View RelatedI need to create a chart with the following features
1) Bar chart that has data for 3 years (3 series)
2) Line chart that has the same data as per the above points on the bar chart but this is a running total. (3 series)
3) These data points are for the 12 months
4) there should be a secondary axis for the cumulative one
Can I create this using the same data set?
Hi Guys..
i don't know weather is it possible or not..but Can any One tell's me How can i refresh the Chart Values.. acutally what's happening..
i have two Chart in a reprot .. One is Main Category and other one is SubCategory... acutally what i want.. in Main Category chart sum of Quantities of Subcategory values comes in bar or any other format.. and when i click on Main chart any bar it's refresh the other chart and return the result of subcategory under that main category in details...
i don't know is this possible .. acutally i m very new in reproting.. infact that's my first report.. so i want to do this.. if any article or any help anyone can provide me..
Thanks
Hi,
I am not getting Mining Accuracy Chart and Min ing Model Prediction
Plz tel me how to do.And how to use the filter input data used to generate the lift chart and
select predictable mining model columns to show in the lift chart
Hi,
trying to build Orgchart with MS Access
columns: Name (text), Boss (data source, Name), Phone (int)
the question - how to avoid the "loop"?
1. prohibit choice for the current employee to choose himself as a leader
2. prohibit choice for the current employee to choose any subordinate level employee as a leader
VBA is not an option, we are planning to move this table to MS SQL server, so it should be a choice with "SELECT from Name...." with exceptions or any other checks with warning/error message...?
thank you
Anthony
Hi there,
I'd like to ask how to approach a chart layout when I have the following table:
|--------------------------------------------------------||[Client Name] | [March 2008] | [April 2008] | [May 2008]|
| Client 1 | 200 | 100 | 500 |
| Client 2 | 150 | 600 | 300 || Client 3 | 540 | 102 | 256 ||--------------------------------------------------------|
And I would like the table to be like the one below:
It seems to me that I have to do some sort of pivot with my dataset/query before I could use it for the chart. Any ideas would be highly appreciated. I really need help with this. Thanks in advanced!
Regards,
Ver
With 2k5 I am trying to make the "Top N" operator, used in a chart "category," return only N categories. But it almost always returns more than N categories. Can someone explain the nuances of the Top N operator, so I can get past this?
View 6 Replies View RelatedHello there!
I installed and configured SQL Server 2005 reporting services. When I try to connect to it using SQL Server Management Studio, I get the following error:
Client found response content type of "text/html", but expected "text/xml".
What should be done to overcome this?
Does anyone have any idea about this?
Thanks in advance
Hemant
Hi,
In my VB .Net application , when I am trying to fire a SSRS report on my local machine . Its giving the error ".Client found response content type of 'text/html', but expected 'text/xml'."
The request failed with the error message:
--
<html><head><title>Error</title></head><body>The Local Security Authority cannot be contacted
</body></html>
--.
the error is being thrown at the code line...
reportviewer.serverReport.getParameters()
I have reportserver as
https://ReportServerforApplication.abc.com/abc_ReportServer
I have admin rights on my machine but still the problem persists. Am i missing some user group?
Could someone Please help me with this.
Thanks In Advance
Gaurav
Hi, i'm trying to do a full text search on my site to add a weighting score to my results. I have the following database structure:
Documents: - DocumentID (int, PK) - Title (varchar) - Content (text) - CategoryID (int, FK)
Categories: - CategoryID (int, PK) - CategoryName (varchar)
I need to create a full text index which searches the Title, Content and CategoryName fields. I figured since i needed to search the CategoryName field i would create an indexed view. I tried to execute the following query:
CREATE VIEW vw_DocumentsWITH SCHEMABINDING ASSELECT dbo.Documents.DocumentID, dbo.Documents.Title, dbo.Documents.[Content], dbo.Documents.CategoryID, dbo.Categories.CategoryNameFROM dbo.Categories INNER JOIN dbo.Documents ON dbo.Categories.CategoryID = dbo.Documents.CategoryID
GOCREATE UNIQUE CLUSTERED INDEX vw_DocumentsIndexON vw_Documents(DocumentID)
But this gave me the error:
Cannot create index on view 'dbname.dbo.vw_Documents'. It contains text, ntext, image or xml columns.
I tried converting the Content to a varchar(max) within my view but it still didn't like.
Appreciate if someone can tell me how this can be done as surely what i'm trying to do is not ground breaking.
Hello everyone !
I want to perform Full Text Search with SQL Server 2000. My documents (.doc, .xls, .txt, .pdf) are stored in a SQL Server field which is binary (the type of the column is image).
I would like to know, how you can extract pieces of text from the documents.
Example:
I have a ASPX page with codebehind in C# making the search in a table in SQL server that is full text indexed.
I make a search looking for the word "peace", than SQL server will take care about the search and return it to me the rows that match with that. But also I'd like to extract the 50 characters before and after where sql server found the word "peace" to show in the result page.
Does anyone has any idea how to work around it ?
Best regards.
Yannick
I get this error:
The data types text and text are incompatible in the equal to operator.
when trying to execute this query
SELECT id FROM users WHERE username=@userName
Any Ideas?
I have text data files from a third party and they use comma as field delimiters and enclose the text for each column in double-quotes. Not a problem for most of the data files until they start sending files where there is " within the column values. SSIS package fails with the error:
The column delimiter for column "Column 1" was not found.
Any ideas on how to resolve this issue will be greatly appreciated.Thankspcp
Hi,
Im a programmer for an university webportal which uses php and msssql.
When an user creates a new entry and his text is too long the entry is cut short and weird characters appear at the end of the entry.
For example:
http://www.ttz.uni-magdeburg.de/scripts/test-messedb/php/index.php?option=show_presse&funktion=presse_show_mitteilung&id=333
How can I set the text limit to unlimited?
Could it be something else?
Is there a way of splitting an entry to several text fields automatically?
Thanks in advance for any help you can give me,
Chris
Hi,
I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.
Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.
Error message on browser:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.
Any ideas?
Thanks,
-waslam
I have a parameter value as shown below and this is dynamic and can grow
Example : 101-NY, 102-CA, 165-GA
116-NY, 258-NJ, 254-PA, 245-DC, 298-AL
How do I get the values in the below format
NY,CA,GA --- each state to be followed with comma and the next state
NY,NJ,PA,DC,AL --- each state to be followed with comma and the next state
correct query that will fetch only state names and not the numbers.
Hi All,
I like RS for SQL server.
However, I am surprised (and frustrated) how limited the chart capabilities are; perhaps we have been spoiled by Excel...
Anyway, is there any way to change the color of the chart bars programatically.
I can select different schemas (excel, pastel, grayscale, etc) but I need to go a little bit further, is that much to ask?
Oh, by the way, we can't mix chart styles, can't we?
Need to show a chart and a line in the same report...
I appreciate your help on this, hopefully any answers to my questions might also help with other RS users with the same needs,
Thanks,
L
Hey all, I'm in a bit of a problem. I have a set of data on an excel spread sheet and i want that data to make a chart on a user form. I figured out how to get a blank chart on the user form but don't know how to link any data. Anyone think they can help?
View 1 Replies View RelatedHi folks,
I have a Employee Master table named "Employee_Master". This has got the fields like as follows,
Employee_ID
Employee_Name
Reporting_To
Now I need a query that can help me to build up the organisation chart. I have a query that gives me some data......... Its like
select emp.employee_id,emp.employee_name,
mgr.employee_name as reporting_manager
from employee_master emp ,employee_master mgr
where emp.reporting_to=mgr.employee_id
But the problem with this query is, it gives only 1:1 mapping. And my requirement is to build a tree structure.........
So please help me oput in this regard........
Please lemme know if the problem is not understood to ya guys.......
Waiting for the earliest reply..........
Thanks,
Rahul Jha
Hi,
Thanks a lot for answering my previous questions.
Here's one more thing that I need. I have my data in one table called as Team_Aggregate.
The fields there are TeamID, Date (1st of every month), Permanent Employeed, Contractor, Open Positions, Total Employees, Max Posns.
Now, when a user selects some months data that he wants to display I want it to appear something like this -
Columns as Month Names (Jan 08 Feb 08...June 08)
Rows as Team Name
and each cell = Team Total for that month and the corresponding team.
Can I do something like this in sql? I want to display the data on the web eventually where I am using Gridview with datasource and databind methods.
Thanks a lot
Hi,
I have created an area graph.My requirement is the following:-
When the user moves his mouse over the graph on different points, the values corresponding to that points should be shown as a tool tip or as a textbox value.
Any idea to capture the values in the graph(Category,Series and Data values) and display them in a textbox or tool tip in a SSRS chart?
Thanks
Arobind.B
Is there a Lift chart viewer like the model viewers that can be embedded within your windows apps ? If not, then can this be easily created via Adomd.net api calls ? Has anyone done this easily in custom DM applications ?
Thanks in advance,
anil
Can you have different scales on a bar chart. I want to chart sales and quantity. Oracle lets you label the top of the bar chart as money and the bottom as quantity.
I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart. I am using the sum of the sales/1000000 as a point label. Is there any way to limit the number of decimal places displayed. Currently it is displaying something like 1.94889312043; 1.95M would be better.
Thank you.
how can i change the language of lift chart for description of vertical axis and horizontal axis and howcan i see the script of this chart for time series algorithm
Hi All,
I have got a query regarding SSRS report chart control. Can i have a chart with both bars and lines within it?
I have a dataset which has two columns as my outputs.Can i have a chart showing bars for one column and line chart for the other column in the same chart?
I will appreciate if somebody can help me out.
Dinesh
I created a graph which retrieves value from database.And currently,my axis is in ranged 0-10.But i have a doubt that my value in will exceed my maximum y-axis value 10..My question is, could it be possible that i make my y-axis dynamic??Thanks!!
View 5 Replies View Related
Hello,
I am working on generating a Pie Chart in Reporting Services. I want to display percentage (%) in the pie chart slices, rather than having the actual values, since it does not fit properly into charts. A percentage would be better as a report.
Hope the question is clear. I would be grateful to anyone who answers this question.
thanks a lot.
Hi,
I have a chart that is created in SSRS with the size property set to '15cm, 8.5cm', I want to set the height based on a parameter that is passed to the chart ( so that it fits onto a 1 page report it is fed through to), I have tried putting =Code.SetChartHeight() in the height property but it brings up an error saying it needs to be in a format like '8.5cm'. The SetChartHeight() function just returns the height parameter + 5.
Does anyone know how I can do this?
Many thanks in advance
Hai all,
I am generating chart using the Sql Reporting services.I have done 2 charts. when i am clicking one chart it will navigate to another chart.It is happened in reports.
when i used in UI page(web Page). when click the chart it is not navigating to another chart.The same chart will appear when i click the chart.
Can u guys help me soon to solve this problem..
Thanks In advance.
Hi,
I am using simple line chart in sql server reporting services 2005.
I am showing 4 lines in my chart.I want to change that line colors.
Please help me for this.
Thanks
Shekar