Hello,
i am working on charts where i collect data for different age groups for two locations.
now i am displaying data having agegroup in the category field and location in the series field. and count on the top.
the problem is i am trying to display %s instead of the count of the people.
like for 2 bars for age group 18-20 should be like (35% , 65%)
any ideas???
Hi all,
I have two problems.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Thanks,
Mahesh Manthena
Is there any option to display more than 1 page, when the chart contains more values which doesnt fit into single page.
View 1 Replies View RelatedI have a report I'm writing and have got a problem that has stumped me.
The data the report is based in is in this format:
Date Type
1/1/08 A
1/3/08 B
3/1/08 C
3/5/08 B
3/10/08 A
3/12/08 C
3/20/08 A
Management wants a report showing a line chart that summarizes the data by Month and by Type. So, there are 2 series depending on the Type and data values are based on the count of each Type. So, in the example above the x-axis group would be month, the values would be count(Type) and there would be 2 series �� Series 1. A, B and Series 2. C
I��ve defined the x-axis to be Month(Fields!DateOccured.Value). However, they want the x-axis to show every month for the entire year not just what is in the database. So, I defined the x-axis to have a scale of 1 to 12 and the major interval is set to 1. This displays 1 through 12 on the x-axis.
The problem is when there is no data (null) for a particular month. Instead of showing 0, the line chart does not plot anything and the line is drawn to the next displayed point. So, for example on the data above the line chart would plot:
January
Series 1 �� Qty. 2 Series 2 �� Qty. 0
February
Null
March
Series 1 �� Qty. 3 Series 2 �� Qty. 2
The line chart would draw a line from January to March skipping February. I need to display the null values as 0 and not null indicating no occurrences for the month rather than no data present.
Thanks!
I have a table that contains some data.
LabelName
LabelValue
TotalForRetire
10337
dummy1
0
TotalForRelatives
5850
dummy2
0
TotalForDisability
7337
TotalForOrange
23
I have a pie chart and a bar chart.
In the pie chart I want to plot only TotalForRetire and TotalForDisability and TotalForOrange
In the bar chart I want to plot only TotalForRetire,dummy1,TotalForRelatives.
Also, here I want the horizontal axis not to show the label for dummy1 as the value is 0. How can i do that for each chart?
I have one report "Incident Summary" which has a Report Parameter called DimPoolPool using ParameterValue for Value Field and ParameterCaptionIndented for Label field. The default value is [Dim Pool].[Pool].[All]
From another chart report I want to be able to click on a column to make open the Incident Summary report parameterized by "Pool". So I got to properties of the chart > Data > Values > Edit > Action > Jump to report > Parameter, and here I enter DimPoolPool = Fields!Pool.Value.
It seems to me that this should be picking up [Dim Pool].[Pool].&[poolname] and entering that into the parameters of Incident Summary report. However instead the Incident Summary opens with blank parameter waiting for user to enter.
How do you format parameters correctly between reports?
Hi All,
Is there any way to display reports in one page? My reports has 3 pages by default.
Thanks.
Hi all,
Can somebody tell me how to display reports created in SSRS 2005 in PDA/mobile devices? How to connect to the PDA device?
hi friends
i am new to working in crystal reports in my application i want to display barcode in crystal reports.
i was totally confused in this. can u help me..........
Hi ,
How can I hide the URL information when I open a report, some with parameters and some do not have
parameters. Is there anyway or properties in RS that I can set to have it hide all the important information,
like datasource, credentials, parameters, and display the report like a aspx page instead?
Or does this need to have special programming to make this happen? and if so, what do I need to do?
thanks very much
Hi Experts,
I have a reporting scenario, where the reports are fetched from Analysis Services.
The reports should display data only spcecific to that user.
All users except those in admin roles should be validated using the Windows Authentication ID and data specific to them has to be displayed.
Any pointers/suggestions on how to implement this in Reporting services/ Analysis Services 2005 would be highly appreciated
Thanks,
I'm using SQL Server 2008 R2 BIDS to accomplish this.
View 7 Replies View Related
Hi all,
I have been using the reportviewer control to display my ssrs reports. However, i'm facing issues in displaying Server reports in the control. The following error show up whenevr i click on View Report.
Execution 'aaxe3ke5k34l5355qbup0rvo' cannot be found
Please help if anyone has come across something similar
Hello,
I am fairly new to SQL 2005 and Reporting Services.
We are trying to create a report that will display sales data based on group membership from Active Directory.
For example, if USER1 logs in and looks at a Year to Date Sales report, it will only show data that pertains to his group. If USER2 logs in and accesses the same report, it will display different Year to Date information because he is in a different group.
Background Information: We are running SQL 2005 Enterprise Edition Service Pack 2 with Analysis and Reporting Services. We are delivering the reports through a Sharepoint site.
Please let me know if anyone has a good way to tackle this.
Thanks,
Justin
In SSRS 2014 std (on a win 2012 server) the report controls display incorrectly in IE11. The save and several other features display on multiple lines instead of one line unless you are in capability mode.Also works fine on SSRS 2014 entr on win 2012 server.
View 7 Replies View RelatedHi All,
I have a sample data like this..I have added the cases for the particular worker in the table..My question is that when displaying the cases for the particular month...the date should not be displayed..instead of date 2008-04-30 I have to display...like April 2008...if the date is 2008-10-20...it should display as October 2008...can anyone please help me with this...
312 KRISTI WHITE 865400 2008-04-30 2
312 KRISTI WHITE 1000264311 2008-04-30 3
312 KRISTI WHITE 1000430815 2008-04-30 1
312 KRISTI WHITE 1000660614 2008-04-30 1
312 KRISTI WHITE 1002371318 2008-04-30 2
312 KRISTI WHITE 2003722520 2008-04-30 4
Thanks
Chaitanya.
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 RelatedMost developers running SharePoint in integrated mode have been experincing issues when displaying SRS reports in a web site other than the default zone.
There is a blog http://www.sharepointblogs.com/nrdev/archive/2007/06/21/ssrs-in-sharepoint-2007-site-using-forms-based-authentication-sharepoint-integrated-mode.aspx that explains that this is a bug and may be fixed when SP3 is released.
We are usi ng dual authentication for a particular site that hosts SRS reports and the default zone is windows auth and the internet zone is FBA. Since we cannot display reports using the RSViewerPage.aspx that comes with RS sharepoint addon, I decided to look for some way to display these reports in a non default zone. This method may help those experincing ths issue but the method assumes that you have one default zone or default zone [0] is the zone where reports are deployed from Visual Studio.
Here are the steps.
1. Go to your Layouts/reportseerver folder in your MOSS installation.
2. make a backup of RSViewerPage.aspx
3. Open RSViewerPage.aspx in visual studio and on the header declarations change the following line that looks like
<%@ Page language="C#" Codebehind="RSViewerPage.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.SharePoint.UI.RSViewerPage,Microsoft.ReportingServices.SharePoint.UI.ServerPages,Version=9.0.242.0,Culture=neutral,PublicKeyToken=89845dcd8080cc91" %>
to
<%@ Page language="C#" AutoEventWireup="false" %>
4. Add the following script line to the page
<script runat="server">
protected override void OnLoad(EventArgs e)
{
SPSite site = SPContext.Current.Site;
if (!Page.IsPostBack)
{
String RelativeReportUrl = Request["RelativeReportUrl"];
if (site.Zone != SPUrlZone.Default)
{
foreach (SPAlternateUrl url in site.WebApplication.AlternateUrls)
{
if (url.UrlZone == SPUrlZone.Default && RelativeReportUrl != null && url == site.WebApplication.AlternateUrls[0])
{
String path = url.Uri.AbsoluteUri.Substring(0, url.Uri.AbsoluteUri.Length - 1) + RelativeReportUrl;
m_sqlRsWebPart.ReportPath = path;
}
}
}
else
{
m_sqlRsWebPart.ReportPath = site.Url + Request["RelativeReportUrl"];
}
}
//add nav
SiteMapPath map = new SiteMapPath();
map.SiteMapProvider = "SPSiteMapProvider";
map.RenderCurrentNodeAsLink = true;
m_breadCrumbs.Controls.Add(map);
}
</script>
5. This script section just points the web part in the RSviewerPage to the report file hosted in the MOSS default zone.
Thats it.
This should work in either of the MOSS zones.
Gatharia
I 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
I would like to display a portion of report where there is data or no data
There is data subreport display
Product Name Latex Gloves
Product ID
xxxx5678
There NO data in the subReport
Product Name
Product ID
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
Is there a way to do this?
Thanks for your help.
Hi,
We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?
With regards,
Constantijn Enders
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