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


ADVERTISEMENT

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 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 - 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

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

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 :: KPI In SSRS Reports

Apr 29, 2015

I have a Manager dashbord  report.In this report 1st page contains some tables and 2nd,3rd page contains line charts with tables.Actually what we need is in 1st page tables are pretty simple,we need to add kpi's and shown these tables in kpi. kpi in ssrs and how to add kpi in ssrs reports?

View 2 Replies View Related

SSRS Or Crystal Reports

Feb 19, 2008

Hello all ...

I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.

Regards,

View 7 Replies View Related

SSRS Vs. Crystal Reports

Jul 13, 2007

Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.

View 1 Replies View Related

Reporting Services :: Publish MDW Reports On SSRS

Jun 1, 2015

Is there a way to publish the MDW (Data Collection) reports (Disk Usage history, Query Statistic history, and Server Activity history ) on SSRS server?! 

It is not logical for all who wants to view the mentioned reports to open the SSMS !  

I've already check [URL] .... there, the writer is suggesting to recreate the reports from scratch on SSRS, that if I could figure their queries, which I don't think the only way that we have!

View 3 Replies View Related

Reporting Services :: SSRS - Join Two Different Reports

Jun 8, 2015

I'm using the SQL Server Reporting Services to build a sales report. 

I'm having two different reports because I need to have a matrix table into one of them.

Is possible to Join two different reports (two different reports.dll) into one? Basically, can I, in the end, export two different reports in only one report?

View 2 Replies View Related

Reporting Services :: How To Use JQuery In SSRS Reports

Jan 1, 2015

I make SSRS Reports and I use SSRS RDL file to perform coding and all..

How can I use jQuery scripts in my Report Server Reports(SSRS) to make it more attractive and user friendly?

View 4 Replies View Related

Reporting Services :: Exporting SSRS Reports To PDF

Jun 2, 2015

I have generated an invoice report is SSRS. It works correctly via Report Builder and the viewer. However if I then export the report to PDF, it throws the formatting of the report off.

As I have mentioned, it is an invoice report. If I print 1 invoice, and export it, everything exports correctly and all formatting is retained. However if i print off and export multiple invoices (range of Invoice 1 to 4), the 1st invoice is exported correctly, but all subsequent ones are not. In so far that where 1 invoice should be printed on 2 pages of A4 paper, it is spread over 7 pages.

The header is one page, then 1 row is on the second page, then a blank page, then another set of data on another page etc. Is it a problem with the page/report sizing/margins?

View 8 Replies View Related

Converting Crystal Reports To SSRS

Apr 3, 2007

I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?

View 3 Replies View Related

Comparision Of SSRS With Crystal Reports

Apr 23, 2008


1) Crystal Reports provides extensive parameter support. The types of parameters supported are: single value, multi-value, and range value (e.g. Start date to End date), or a combination of all three.
2) SSRS parameters only support entry of a single value. It doesn't support multi-value parameters or range parameters. For example, the user can't be presented with a list of Employees and select more than one for reporting on. Doing so requires writing custom code and writing more complex SQL queries

View 5 Replies View Related

Reporting Services :: Details Of Reports Scheduled On SSRS

Jun 4, 2012

Is there a way to find all SSRS scheduled reports details such as (Report Name, schedule time, mail IDs configured, etc.)?

We have many SCCM reports on SRS, and manual work will take very long time..

View 14 Replies View Related

Reporting Services :: Expand / Collapse All Sub-reports In SSRS

Jul 9, 2015

In my report i have more than 10 sub reports each should be displayed when we click on some label but my requirement is to expand all the sub reports at a time or collapse the sub reports.URL.....problem here is it is a genius solution working beautifully in my local machine but in the client server if i click on the Expand/Collapse radio button it is asking for the parameters again.

View 9 Replies View Related

Reporting Services :: SSRS Reports - Unable To Open In PDF

May 15, 2015

I have deployed SSRS reports to the Report Server, but am not able to open them in PDF. 

View 3 Replies View Related

Reporting Services :: SSRS Reports Are Not Working In IE11

Sep 7, 2015

We had migrated the SSRS reports from 2008 R2 to SSRS 2012 SP2 version. We had a strange issues after migration.

The report which is having images is not working and it just hangs.

The reports which doesn't have any images are working fine.

On top of it some times we are getting the following error message.

Error message : The request failed with HTTP status 503: Server Error.

View 4 Replies View Related

Reporting Services :: SSRS Reports Not Running Through Sharepoint

Sep 29, 2015

We couldn't get the report through SSRS deployed URL.  We found dead locks in SQL DB end.how to proceed further issue resolution.

View 5 Replies View Related

Reporting Services :: Access SSRS Reports In Java

Nov 18, 2015

I have developed  SSRS reports and deployed to the SSRS Reporting server. Everything works fine. 

But How can i access these reports in Java application ?

View 3 Replies View Related

Reporting Services :: SSRS Reports To Be Displayed In New UI Based Web Page

Aug 5, 2015

I have one requirement. We have one application in banking and they have developer that application using c# and .Net code so For Business Users--when they enter their details and when they want to check Reports--it should take to a another UI or web page where Users will see all the reports--- and clicking the report he/she should be get able to export it into different formats..

i know that we can give report manager URL--but due to various issues-- we have choosen to built a web[age where they can see the reports work-flow:

so--user opens bank site--enters his details-goes into reports--it should open new webpage or UI, he should see all reports--he should export these reports..

After that based upon security levels each user can see their individual reports.

View 2 Replies View Related

Reporting Services :: SSRS Subscriptions Resend Reports For Each Subscription?

Sep 1, 2015

I have a Daily Invoice Report that has subscriptions for all customers and is run every night.  The report has parameters of @date & @Customer.  We had issues with invoices not being sent due to the Owner on the reports was disabled in Active Directory.  We do not know how many reports did not get sent out so I am tasked with creating a script to rerun the reports for each day in August.  I have queried the subscriptions, but need to figure out how to rerun the reports using the existing parameters set in the subscription, increment the report parameter date, and execute the emailing of the report.

Here is my query that gives me all the subscription information, but how do I rerun the job for all subscriptions for each date in August?

SELECT USR.UserName AS SubscriptionOwner
      ,SUB.ModifiedDate
      ,SUB.[Description]
      ,SUB.EventType
      ,SUB.DeliveryExtension

[Code] ....

View 2 Replies View Related

Reporting Services :: SSRS Reports Migration And Management Between Environments

Aug 13, 2015

How to manage the progression of SSRS reports from DEV > TEST > USER > PROD...I can see that you COULD manage this all from within VS however then all the control is in the developers hands and even though you can control access with permissions and stuff, its not very user friendly to provide a tester or business area manager or project manager with VS just so they can publish reports as they are approved.Are their any such tools to manage migration between ssrs servers or something that you could have a user test a report and then do something like "approve/promote" it to the next environment, or is this something we would need to create ourselves?

I can see that there are a few things that allow PROJECTS to be migrated (powershell scripts and something about octopus deploy) but these all seem to be too "big" for our organisation - we generally develop reports as a "logical group" (project) but migrate them individually or in VERY small groups (5 is probably the maximum), however keeping tabs on what report is at what version in what environment is causing our DBA massive migranes...Maybe there is something we can do from TFS or perhaps we need to build a utility app?

View 5 Replies View Related

Sql 2005 Standard Advice SSRS Crystal Reports

Mar 24, 2008

I have visual studio 2008 on my vista ultimate machine. I also have sql express edition, however I have no installed it
I was thinking of installing sql standard edition because I really am interested in development of ssrs,
crystal reports in a commercial development. Is it best to have both sql express and the standard edition
I am excited about sql 2008. What is the best configuaration for an aspiring small comercial developer
like myself. I am looking for input. Thanks

View 5 Replies View Related

Seeking Advice On Converting Crystal Reports To SSRS

Aug 20, 2007

Hi. We've decided to convert our Crystal Reports to SSRS 2005. We know (thanks to this forum) there are companies that will convert the reports at a cost; however, we'd like to undertake this ourselves. Are there resources you can point us to that might be specific for Crystal Reports users coming over to SSRS, especially for newbies? Thank you.

View 3 Replies View Related

Reporting Services :: SSRS 2014 Reports Don't Display Correctly In IE11

Jul 15, 2015

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 Related

Reporting Services :: Window To Choose One Report From Bunch Of SSRS Reports

May 28, 2015

I have 6 SSRS reports for account receivable module. All of these 6 reports are for one specific business requirement. The difference between these reports are layout, number of columns and styles. I want user to choose one from these 6 reports based on their requirement.

When user clicks the menu in their application to initiate the report, Is there any way that the SSRS show list of these reports in a window so that user can choose one of them?

As I am working on a 3rd party ERP application, I cannot provide a form or window in that ERP to choose one report out of these 6 reports. I believe that there is a way to do this in Crystal report, but do not know how to do this in SSRS.

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 BIS Deploy Does Not Always Clear Cached Reports

Jul 19, 2011

Is there a known problem with BIS Deploy not clearing cache.  I repeatly (but not always) have an issue where I will do a BIS Deploy of an RDL but when I run it, the old report runs.  I can't clear this out until I explicitly log into the Report Manager and explicitly delete the RDL and re-deploy from the BIS.

Is there a workaround, fix, process change, configuration change I can do to keep this from happening?

View 7 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







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