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
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
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!!
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?
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}
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
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 RelatedIn 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
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
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.
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
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.
I have installed and am using Reporting Services.
I can create RDL files using Visual Studio.NET, but like to offload this task to a minion who does not have VS.NET.
Is there a stripped down something-or-other to make reports that and end user or business analyst could use and then upload the reports?
Thanks.
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 RelatedWe are planning to migrate our crystal reports to reporting services, just wondering if we have cross tab reports in sql server reporting services. Thx.
View 7 Replies View RelatedI currently have a report on our Reporting Services 2005 server that takes a CompanyID as its only parameter. Also, in our database, we have a list of contacts that are linked to the CompanyID that is used in the report. What I would like to do is email a pdf or each company's report to every contact for that company in our database daily. However I am stuck on how to do that. My project is using C#, but if there is a way to do this directly through Reporting Services I could do that as well. If anyone could help me out I would greatly appreciate it. Thanks!
View 5 Replies View Related
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.
I get the following message:
A connection could not be made to the report server http://aklink1/reportserver.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Please help!
A long shot but someone may have experienced same problem. We are using Crystal Info to run reports against a SQL 7 database. Reports that usually take 1 or 2 minutes to run are taking up to 15 minutes to run. The database is fine ie you run the query through the query analyser and it runs in 1 or 2 minutes. Any ideas... I've spoken to Seagate but not making much progress.
Thanks in advance..
Can any one tell me where can I find good online help for Crystal Reports for learning?
Thanks!
I am working on creating Crystal Reports from a SQL database.
In CR you can define a multiple range parameter i.e. 1-10, 100-200, 300-400 and Cr will filer records that satisfy this criteria.
How can I transfer this functionality using a stored procedure?
Hi,
I am new to crystal reports.
I need to change the database connection in the reports to different sql server database and use the same report layout.
Any help is appreciated.
I'm new to SQL but have quite happily been using Crystal Reports without it until now.
I am creating a letter template and it has the name at the top then the address
<name>
<address1>
<address2>
<address3>
<address4>
There is always an address 1, but maybe not a 3 or a 4, and aparently we dont want any line gaps to show, so I figured i should use an isnull to eliminate the line and to move the other address line up?
Not sure what to put though, any ideas?
Thanks in advance for any help :o)
THE TIME PORTION OF THE DATE/TIME IS NOT DISPLAYING IN CRYSTAL 8.5
IT SEES THE DATE...BUT NOT THE TIME
ANY SUGGESTIONS
Hi,
I have a question. How can i fill a report made in CrystalReports in .net
Thanks in advance
what are the good resources for crystal reports.
Also is it something which is difficult to work with ? Suggestion, experiences and notes please.
Hi all,
Currently I have a project that require me to use reporting services (Reports) together with ASP.net web application.
However, I have the following problem.
I have an asp.net web application. From there, I have a textbox whereby user can type a specific date. The specific date should then be incorporate with the sql reporting services. The report that is being generated will contain data that is on the specific date.
How can I do that?
I try to search through the internet but to no result. Can anyone help out?
Thank you so much.
We will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In addition, we will moving from a Local Catalog Deployment to a Remote Catalog Deployment. My question is this: Is there a way I can prevent my team from having to manually redeploy our reports in the new system? They have not been diligent about saving the Visual Studio solution or project files, so they will have to pull the most up-to-date RDL's off the server and deploy them on the new server one by one.
I suppose I can install SQL 2000 on the new server first, then move the Reporting Services databases to the new server, then upgrade the server to 2005, but installing 2000 and upgrading to 2005 does not sound like a best practice. I would prefer a clean install of 2005. Does anyone know if I can move the deployed reports from one server to another?
Paul Teal
paul@partytilyoupop.com
We have created and scheduled some test reports via Idera performance tool but we are unable to delete the reports. These are not custom reports and reports created with Schedule Email option in Idera. Unfortunately, I dera does not have any option to delete these reports and support is asking me if I tried this by deleting from SQL Server Reporting Services.I looked at the Reporting services but can't find any place to delete these reports. This link does not provide any support because I don't have these (Or Report Manager)----> Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.
URL....All I have is "Reporting Services Configuration Manager" under "Configuration Tools". How can I delete these reports from SQL Server Reporting services ?. Can I delete them from some tables in Reports databases ?. If so, what are the tables ?. I delete the jobs from SQL Server but the jobs are automatically created the next day emailing the reports again..
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
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!
Is there a good way in TSQL to:
1. List all SSRS reports containing sub-reports
2. List the SSRS sub reports?
I have a question regarding Reporting Services:
I want to run the Reports on a system that has Oracle Database but reporting Services are not installed there. Only Application exe file will be there designed in .NET Windows Forms.
Reports will access oracle Database.
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?