Migrating From Crystal Reports Charts Using TopN And Other To Reporting Services

Mar 6, 2007

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

View 5 Replies


ADVERTISEMENT

Reporting Services :: Migrating All Crystal Reports Over To SSRS

Oct 16, 2015

I am in the middle of migrating all Crystal Reports over to SSRS and am having some troubles converting formulas used in Crystal Reports to functional expressions in SSRS. For example: My formula for one of the crystal reports is the following. Very simple logic but how would I build it as an expression to work in my SSRS report?

IF {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY} < 0 THEN 0 ELSE {CUST_ORDER_LINE.ORDER_QTY}-{CUST_ORDER_LINE.TOTAL_SHIPPED_QTY}

View 3 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

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

View 4 Replies View Related

MS Reporting Services And Crystal Reports

Aug 23, 2004

Can anyone tell me if MS Reporting Services can import/read a Crystal Reports file as it can an Access report file?

I've seen a few posts out on other boards that there are some companies charging fees for converting Crystal Reports over to MS Reporting Services.

Is there any easier way? Are there any tools out there that can do it?

Perhaps Microsoft should produce such a tool for converting...

Thanks in advance for any help!!

View 3 Replies View Related

Crystal Reports To Reporting Services

Jul 12, 2007

Crystal reports to Reporting Services
Is there any way I can convert Crystal reports to Reporting Services instead of creating reports again in Reporting Services?

View 3 Replies View Related

Crystal Reports GridRowColumnValue Equivalent In Reporting Services

Feb 20, 2008

Hi,

I am converting a crystal report cross-tab, in to a reporting services matrix. The cross-tab uses a GridRowColumnValue function to hide/show the data & total fields.
Is there an equivalent in reporting service or a workaround method for this?

Thank you

N

View 1 Replies View Related

Reporting Services :: Page Break After Charts And Tables In SSRS Reports

Aug 2, 2015

In SSRS reports i have multiple charts and tables. per page i have to display one chart and one table. How to put page break after the chart and table. I have not used rectangle. I created all the charts and tables in the body area.

View 5 Replies View Related

Migrating PIVOT TABLE Reports In REPORTING SERVICES

Oct 18, 2006

HI,

We currently have a report generated weekly running script which creates an excel file and pivot tables. Using pivot tables we can drag and drop the various required fields and the report changes instantly. But i was told there is a limitation of size while using pivot tables.

Can this report be easily created with almost all the flexibility in reporting services, if so could you please guide me with some sample report or tutorials.



currently there is a some store procedures thats run every week using a DTS manually, is there a way of automating this.

Many thanks in advance.

Cheers

Dargonheart 007

View 1 Replies View Related

Charts For Reporting Services

Apr 25, 2007

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

View 1 Replies View Related

Reporting Services Charts

Jun 5, 2007

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.

View 1 Replies View Related

Charts In Reporting Services

Jan 2, 2007

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

View 1 Replies View Related

Doubt In Charts In Reporting Services(on 3rd)

Apr 3, 2008



Hi all,I have created on Chart using Chart control
But legend names are by default 'Series1','Series2'.
How to change these names according to x and y axis values names.
Help me

View 1 Replies View Related

Reporting Services :: How To Exclude NULL From SUM In Charts

May 15, 2015

I have some data from SQL server which contains NULL values for certain fields. I have to create a chart with sum of a field. There is no category and series groups, we are just showing the total sum of a field in chart. Since I have NULL in my source data, nothing is displayed in the chart. I cannot exclude this record  from dataset as I have to use this record for other charts. I have to do some filtering in the chart area itself. I have given IsNothing() in the filter of chart properties. It does not work for me. Even I tried to give IsNothing() in the exp of  Sum() .

View 6 Replies View Related

Reporting Services :: Bar Charts With Different Colors For Different Categories

Jun 24, 2015

I have been asked to derive a bar charts in SSRS. Each bar would represents a different category and each bar should come with different colors. No. of categories might vary every time, it is not fixed. How to achieve this dynamically?

View 2 Replies View Related

Need Help Regarding Custom Colors For Charts In Reporting Services

May 30, 2007

I need some help regarding Custom Colors implementation for Charts in the Reporting Services.



What we are trying to do is to make every color for every Series(see example below) to be a customized Corporate color.



For example each of the series on the Chart should be in specific Custom Color:

Series 1 - "LightBlue"
Series 2 - "LightYellow"

Series 3 - "DarkBrown"



All I found from MSDN is how to do it in the Chart Properties in a Code section (right click on the report outside the chart -> Properties -> Code tab -> paste the Custom Code ).



And then to use it in the Chart color definition as:


Code Snippet=Code.GetColor( Series# )











But we are trying to do it in a separate C# class that would be updated only in one place, instead of changing 30 reports each time something is changed. So that it could be generic.





The C# class:






Code Snippet

namespace CustomColorPalette

{

public class CustomPalette

{

public CustomPalette()

{

}



public static string GetColor(string GroupingValue)

{

int groupingValue = int.Parse(GroupingValue);

string[] colorPalette = {"Green", "Blue", "Red"};

if (groupingValue < colorPalette.Length)

{

return colorPalette.GetValue(groupingValue).ToString();

}

else

{

return "Black"; // if # of Series is more than defined - all undefined will be = Black color

}

}



}

}









I tried 2 different ways:





1.



Then I put a code into a Custom Code section of a report:






Code Snippet

Public Function GetColor(SeriesNumber as String)

Return CustomColorPalette.CustomPalette.GetColor(SeriesNumber)

End Function







And in the Chart Custom Color settings I put:




Code Snippet=Code.GetColor( Fields!SeriesNumber.Value )





And after compilation I get an error:



Error 303 [rsCompilerErrorInCode] There is an error on line 2 of custom code: [BC30451] Name 'CustomColorPalette' is not declared. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0










2.



Second way I tried:





Then I put a code into a Custom Code section of a report:






Code Snippet

Dim X As CustomColorPalette.CustomPalette

Protected Overrides Sub OnInit()

X = new CustomColorPalette.CustomPalette()

End Sub









And in the Chart Custom Color I put:




Code Snippet=Code.X.GetColor( Fields!SeriesNumber.Value )







And after compilation I am getting an error like this:

Error 302 [rsCompilerErrorInExpression] The BackgroundColor expression for the chart €˜chart2€™ contains an error: [BC30456] 'X' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0



Is there any workaround? Or all I can do is to make the Custom Colors manually in each report, and if something need to be changed - I will need to change it in each report separately





Thanks,

Alex

View 5 Replies View Related

Reporting Services - Crystal To SSRS

Sep 5, 2005

I have a requirement to convert reports from Crystal Reports to SQLServer Reports. Is there any tool to do this? or Do I need to redesignevery report in SQL Server Reports?Madhivanan

View 2 Replies View Related

Crystal Alerts But In Reporting Services

Apr 20, 2007

In Crystal Reports you can setup Alerts to alert you to a certain criteria when ever you refresh the report..



Is this possible within Reporting services?



If so how do you set them up?



Thanks

View 6 Replies View Related

Reporting Services :: Multiple Charts From A Single Dataset

May 20, 2015

I'm looking to build a report that is basically a series of line charts that is plotting a value over time.  I can accomplish this one chart/dataset at a time, but I believe with 'List's this can be achieved in a more automated fashion.If I have some data similar to this:

Area_ID, Location_Name, DataValue, ReadingDate
1,Site1,100,1990-10-10
1,Site1,110,1990-11-11
1,Site2,105,1994-01-07
1,Site2,105,1994-02-07
2,Site3,113,1994-06-02
2,Site3,120,1994-07-30
2,Site4,120,1994-06-30
2,Site4,120,1994-07-30

I want the charts grouped by the Area_ID, and then each Location_Name is a Series in that chart.  So in this example, I would end up with 2 charts (Areas 1 & 2), each have 2 series (Area 1: Site1, Site2 and Area 2: Site3, Site4)Is it possible to build this with a list? or do I need to structure the data differently?

View 6 Replies View Related

Reporting Services :: Charts Not Visible In Report Manager

Aug 27, 2015

I am able to preview my report in Microsoft Visual Studio with a chart embedded at the top of the report. However after uploading the report to Report Manager, the chart is blank. How can I get the chart to be visible in Report Manager?  I am using SQL Server 2012 on a Windows Server 2012 R2 machine.  I can see the chart if I edit the report in Report Building in the print layout mode.  I can also see the chart in my Microsoft Visual Studio Project.

View 5 Replies View Related

Reporting Services :: How To Avoid Value Overlap On Column Bar Charts

Sep 8, 2015

I have a column bar chart which displays values for each month. As per the requirement, I am displaying the column values by selecting "Show labels" options. I see few values overlap on the column bars.

View 2 Replies View Related

Reporting Services :: Expression To Hide A Rectangle With 2 Charts

Oct 20, 2015

I have 2 reports in a single report

Report 1: This report has a tablix and a pie chart which displays member counts for genders.Dataset is written such that the gender names are always displayed in the tablix even when the count is Zero for Female and Male

Report 2: This report has a tablix and a pie chart which displays member counts for category Age.Dataset is written such that the age category names are always displayed in the tablix even when the count is Zero for age categories

Both Report 1 and Report 2 are place in separate rectangles and then these 2 rectangles are place in one single rectangle.Now I want to hide this main rectangle with an expression.

View 4 Replies View Related

Which Is Faster Reporting Services 9 Or Crystal Report 11?

Jun 12, 2007

hey i m startint in reporting services 9 and i find it so interesting but kinda slow, which is faster reporting services 9 or crystal report 11?



best regards



Joseph

View 6 Replies View Related

Reporting Services :: Calculating Percentage Of Column Total In Charts

Jul 22, 2015

Calculating % of Column Total in Charts...

Doing this exercise in Excel is always very simple: 

View 3 Replies View Related

Reporting Services :: Data Visualizations - Gauges Charts Not Rendering

May 22, 2015

We have recently migrated to SSRS2012 and since this time any report with a gauge or a chart within will not render. Upon researching even newly created reports will not render them. 

View 2 Replies View Related

Question Related To Reporting Services Vs Crystal Report

Apr 10, 2007

I am migrating my reports from crystal 8 to reporting services 2005 but before this my client wants answers of following question.Can anybody provide me answer or link related to mentioned question...

1 -Will there be any performance improvement when the same Report (considering big data) is being run with Sql-Server reporting services compared to the one with Crystal report engine?

2- Is it possible to make the labels which are part of Top Palette like €œ1 of 1€?, €œFind€?, €œNext€?, €œSelect a format€?, €˜Export€? according to the Account language?

3- Can both Versions of Reporting Tools (SQL-Reporting service and Crystal Report) run on the same machine?
4- What are the limitations of this Tools like whether there are any additional load on Database Server because of the involvement of Reporting services which are installed on DB Server.
5- Whether there are additional (to Crystal Report) types of Graph formats, Export file types available?
6- How is the licensing done for SQL-Server Report services?


Please provide me the answers ASAP.

View 4 Replies View Related

Reporting Services :: Boxplot And Whisker Calculation In SSRS Charts Within Stored Procedure

Jun 2, 2015

I have a requirement to display each student Fitness test results in the form of a Box plot chart with High Whisker , Low whisker , Low box,high box , Mean and Median in a stored procedure since test areas are dynamic. But , i have never done this before.

Test Type
TestSeq
Test Date
Student ID
TestArea
Test Result

[code]...

View 2 Replies View Related

Error Migrating Reporting Services

Jul 21, 2006

I am migrating our reporting services from 2000 to 2005. I am following the instructions in http://msdn2.microsoft.com/en-us/library/ms143724.aspx. I am currently using the Report Server Configuration tool to restore the encryption key. I click "Restore", point to the backup that I created at the beginning of the process, enter the password, and the process begins. I get a check mark and a message saying "Restoring Encryption Key." The problem is that it never comes back from this. I let it run for over an hour and finally clicked one of the previous steps to abort this. I went back and started it over. Again, it has been running for over an hour. I get no errors; it just does not complete. How do I proceed? Thanks in advance for any assistance.

View 4 Replies View Related

Migrating SQL 2000 Reporting Services To 2005

Mar 17, 2008



I am little bit scared that if i upgrade reporting server db to 2005, My report won't work. I just wanna test with some reports in SQL 2005 reporting services.

1) what should i do( I have already installed Reporting services in 2005 (64-bit)?
2) Can i backup Report server db and Report Tempdb database and restore in SQL 2005 but these database already exists in SQL 2005.?
3) If i upgrade these database , Will it effect my 2000 Production Reports?

4) i donno what to do

Please help SQL reporting experts.

View 2 Replies View Related

Converting Crystal Reports To SSRS Reports

Mar 27, 2008


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

View 9 Replies View Related

Reporting Services :: Server Not Fully Functional After Migrating To New Domain

Jun 19, 2015

I had to migrate my report server (2008R2) to a new domain. I built new server and restored the old ReportServer and ReportServerTempDB into new server and also restored the certificate from old server. The Report Server is running but I don't have full access to all server futures anymore, looks like it's AD authentication messed up. My new account is Admin on new server but I can't see all options, like New Data Source, or wehn going on report level to manage to see all option such as Parameters, Subscriptions, Data Source.

View 2 Replies View Related

Migrating Reporting Services 2005 With Integrated Sharepoint 2007 To Another Server

Sep 27, 2007

hello good afternoon, I am having this issue, I need to move reporting services from one server to another, but I need that credentials, roles and reports stay the same. But as the reporting services is integrated with sharepoint, dont know if I can move both at the same or it has to be done one at a time. this is just data migration, but still I will like to Know how it can be done having the same structure with the roles and credentials. or it is prefered to do a ghost?? but the issue will be that we have the reporting services in one place and the data in another... don´t know how this will affect. thanks in advanced for the help.

View 1 Replies View Related

Reporting Services :: Error When View Reports Or Manually Processing TFS Data Warehouse And Analysis Services Cube

Apr 24, 2015

I am trying to configure the reporting for TFS using SQL Server. But I get following error when viewing any report:

So I try to manually process the cube to check if it works. I am following this article: [URL] ....

When I click on GetProcessingStatus and invoke it (with last field set as TRUE) I get following error:

How to resolve this issue and be able to see the reports.

View 5 Replies View Related

VB 6 && SQL Database: How Can I Create Reports With Charts ?

Sep 14, 2005

I am writing a VB6/SQL Server database app.I know I can't add charts to data reports.What is the best means of creating printable reports containing charts -should I simply create a form which contains the required charts & make itpossible to print this out ?.TIA,woodglass...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved