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 RepliesI 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
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
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
Hi all,
i have this Crystal formula below. I'd like to convert it to SSRS,but i can't convert it just like that because SSRS needs another "else condition"
anybnody can help me out?
if {.RMDTYPAL}=7 or {.RMDTYPAL}=9 then 0else if {.DUEDATE} < {?Cut-off Date} then {.CURTRXAM}*{?IntRate}*({?Cut-off Date}-{.DUEDATE})/360
thanks,
Addin
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,
Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.
View 1 Replies View RelatedConverting Crystal Report formula to SSRS
I've got a formula written in Crystal Reports that I'm trying to re-do in SSRS 2005. I've just been using Crystal Reports for so long, I've got a mental road-block today.
Here is the formula in Crystal Reports:
IF {V_VIEW.FIELD1} IN ["AAA", "BBB", "CCC", "DDD",
"EEE", "FFF"]
THEN ({V_VIEW.FIELD2}&"*")
ELSE ({V_VIEW.FIELD2})
(It concatonates an asterisk to the end of FIELD2 if FIELD1 contains on of the values in the list.)
In SSRS I'd like to cause an entire row to be bold if FIELD1 contains one of the values in the list.
So in SSRS I'm putting an expression into the FontWeight properties of the TableRow and trying for something (which doesn't work yet) like:
=iif (Fields!FIELD1.Value IN ("AAA", "BBB", "CCC", "DDD", "EEE", "FFF"), "BOLD", "NORMAL")
(SSRS doesn't like the "IN" in the above statement.)
Can anyone offer a suggestion on how to write this for SSRS?
Thanks!
-ErikR
------UPDATE------
2007-SEPT-17
Ok. I found a workable solution. Does anyone have a better suggestion than the following? The below works but it seems it could be done more simply... Any suggestions?
=iif (Fields!FIELD1.Value = "AAA","Bold",
iif(Fields!FIELD1.Value = "BBB","Bold",
iif(Fields!FIELD1.Value = "CCC","Bold",
iif(Fields!FIELD1.Value = "DDD","Bold",
iif(Fields!FIELD1.Value = "EEE","Bold",
iif(Fields!FIELD1.Value = "FFF","Bold",
iif(Fields!FIELD1.Value = "GGG","Bold",
iif(Fields!FIELD1.Value = "HHH","Bold",
iif(Fields!FIELD1.Value = "III","Bold",
iif(Fields!FIELD1.Value = "JJJ","Bold",
iif(Fields!FIELD1.Value = "KKK","Bold",
iif(Fields!FIELD1.Value = "LLL","Bold",
iif(Fields!FIELD1.Value = "MMM","Bold",
iif(Fields!FIELD1.Value = "NNN","Bold",
iif(Fields!FIELD1.Value = "OOO","Bold",
iif(Fields!FIELD1.Value = "PPP","Bold",
"Normal"))))))))))))))))
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
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}
Hello,
I am asking a question i have seen many threads on, but I am looking for an idiot's guide on how to convert my SQL 2005 database to SQL 2000 so i can get it to run on my web hosting server. I'm very new to asp.net , but have ahd years of experience in normal HTML and a year or two in the old ASP.
I was advised to learn ASP.Net 2.0 and have found it nothing but brilliant. The intergration with SQL 2005 made it a lot quicker to link up a database than using Access. Unfortunatly my hosting company is a little behind and still using SQL 2000. There isn't mch databse intergration (a few aplication forms) so I dont mind re-writing the whole database but I dont know how to set Visual web developer up with a SQL 2000 Database. I have also read from various other forums that you can convert a databse to 2000 by doing something with the scripts, but the explaination is too complicated for me to follow.
Is there anyone out there who wouldn't mind going over some old ground and explain this all in simple terms? Im using 'SQL Server Managment Studio Express' (although i dont know how to use it) and 'Microsoft visual web developer 2005 express edition' .
Thanks for reading this
Simon
Hello everyone, I am upgrading from SQL Server 2000 to SQL Server 2005. Any caveats? Can I just detach the db's and attach them into 2005. Or is there any conversion I should run or import first?
Thanks,
I have abt 30 reports currrently in SQL 2000. My data still resides in SQL SERVER 2000. However, I need to convert these reports to SSRS 2005.
I want to use the cool features like sorting, multi-value parameters from the RS 2005.
Can you pl advise how I shud go abt converting these reports from RS 2000 TO RS2005 .
Thanks.
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
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,
I'm very new to SQL Server, I'm coming from an Oracle background.
I've set up a server with windows authentication but I'm having no luck connectiong to it with Crystal Reports XI.
Can anybody go through the basics with me?
Regards
Sean
Hi,I'm semi-new to crystal reports & sql server and what i want is toextract data from a sql server file. I've been able to connect to sqlserver directly and get the info. i need but is there a way to just openthe data file (in crystal reports) without making a server connection?TIA
View 1 Replies View RelatedHas anyone had any luck getting Crystal Reports 8.5 to work with theSql Server 2000?I keep getting a "Unable to open Database" error. I've tried openingwith either the .Connect property and the LogOnServer method and getthe same message from either approach.I am using the OCX control.Does this version work with Ms Sql?Any thoughts and suggestions would be most appreciated.Thanks.-Dave
View 4 Replies View RelatedI exported a column of type float to SQL Server using DTS. In Crystalreports, it 'sees' the column as a string! Is 'float' the best type touse? Must I create a formula field in CR to 'correct' for this?
View 3 Replies View RelatedI am just exploring options for setting up online databases to permit input by clients and output in the form of Crystal reports. Am I barking up the wrong tree or on the right track?
View 1 Replies View RelatedHi
Im new to reporting services but experianced in crystal reports
Im trying to convert some crystal reports into sql 2005 reporting services.
I have this formula in crystal reports which I cannot seem to replicate in Reporting services
if {TABLE1.TYPEID} = 1 then (0 - (
if {TABLE2.CURRENCYDESC} <> 'GBP' then {TABLE3.TOTALVALUE} / {TABLE4.EXCHANGERATE} else
({TABLE3.TOTALVALUE})-{@line total}))
else
if {TABLE2.CURRENCYDESC} <> 'GBP' then
{@Gross Profit} / {TABLE4.EXCHANGERATE} else {@Gross Profit}
I have already created the formulas for @line total and @gross profit
Can any one please put me into the right direction
Thanks for your help
I showed my boss the functionality of ad hoc reporting in SRSS and he likes it. He asked me if we could completely move away from Crystal Reports (CR) to SRSS.
Does anyone have any issues with SRSS that didnt exist in CR.
One question i have is programmability capabilities. Some time back i had to make a very complex report in CR. I create a table in the dataset. Designed the report to pull data from that table and the table was being populated through some VB.NET code. So the users will open a GUI and hit RUN, which is when i will populate the table and show the report. You can assume that populating the table required complex programming and couldnt have been done through user defined functions in a report.
I dont suppose stuff like this can be done in SRSS?
Hello
i have a problem in crystal report, i want to dispaly data from MYSql data base to crystal report through my application
I have'nt work on crystall report before this
please help me.....
thanks in advance
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!!
All,
I have been tapped to help with fixing a reporting tool. We have a Sql Server database/crystal reports(10) setup. I havent had the chance to look at the tables in the DB yet, but I was told that aggregate tables were used. In my past experience with crystal reports, we used database views to feed crystal reports (in Oracle). I was thinking that I could somehow use views instead of tables and then try to re-index the base tables and compile satitics (if theres such a thing with Sql Server). I was also going to look into bottlenecking and locking (table locking as opposed to row or page locking for the lookup tables...to reduce overhead on the main tables) but, I'm not sure if it'll make a difference since this is just a demo server with no major traffic hitting it yet.
The question is, does anyone have any experience with crystal reports running slow with Sql Server, what should I look out for??
'Wale
Hi guys!
I am new in Crystal reports so please help me on this one.
I have to create a report that will bring back the TOP 20 customers per Sales Rep. My SQL stored procedure needs a parameter @SalesRep to execute. My stored procedure links between 2 tables. How do I get this stored procedure executed in Crysal Reports to give me results. The SP works fine.
THANKS!!