Convert Sum(a,b) From Crystal Report To SSRS
Oct 19, 2007Hi all,
need help to convert Sum(a, b) i found in Crystal Report to SSRS.
a = the dataset that i want to subtotal
b = the group
thanks!
Addin
ADVERTISEMENT
Convert Crystal Report To Pdf
Sep 27, 2007How can I convert a crystal report to a pdf format.ASP.net is not loaded in my machine.pls help me...
View 3 Replies View RelatedCan You Host Crystal Report (rpt) Files In SSRS
Apr 23, 2008Can I create reports with Crystal Reports and Deploy them in SSRS?
Thanks in advance,
saied
Converting Crystal Report Formula To SSRS
Sep 17, 2007Converting 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"))))))))))))))))
Convert Access Report To SSRS
Feb 12, 2008hi,
I'm using this query to generate a report. When I preview the report I should be able to select values from parameter drop down list for the following fields.
OfficerName
OfficerId,
BorrowerName
frmMain( is access form type. wonder how do I get this as a parameter to my ssrs report. how do I make available data set for this one?. I can not see available data set for this one when i click drop down menu in report parameter box)
Forms
ToDate
FromDate
But when I run the query I can see only date parameters. I can not see anyotehr parameters. I can add parameter and select fields like officerName, OfficerId etc. But it does not work when i preview it.
Actually one of the developers has created a stored proceedure for this report. He already created an Access report, What I really want to do is recreate it in SSRS or convert into SSRS. But in either way, this parameter thing does not work.
Here is the code;
Code Snippet
CREATE PROCEDURE [dbo].[GET_EXPENSES_REIMB_OFFICER]
(@FromDate DateTime, @ToDate DateTime)
AS
SELECT
BorrowerName,
TExpense,
TReimbursement,
CREATE_BY_DT,
OFFICER_ID,
RC_NUM,
OfficerName,
FROM (
SELECT
b.Title AS BorrowerName,
m.INVOICE_TOTAL_AMT AS TExpense,
0 AS TReimbursement,
CONVERT(varchar, m.EFFECTIVE_DT, 101) as CREATE_BY_DT,
m.OFFICER_ID,
m.RC_NUM,
o.OfficerName,
FROM EXPENSE m
INNER JOIN .adBorrowerObligation bo on m.Borrower_Obligation_ID = bo.BorrowerObligationID
INNER JOIN .entity_to_obligation eto on bo.BorrowerObligationID = eto.Borrower_Obligation_ID and eto.entity_type_id = 1
INNER JOIN .adEntity b on eto.Entity_ID = b.EntityID
LEFT OUTER JOIN OFFICER o ON m.OFFICER_ID = o.Enum
WHERE (m.EFFECTIVE_DT >= @FromDate)
AND (m.EFFECTIVE_DT <= @ToDate)
UNION ALL
SELECT
b.Title AS BorrowerName,
0 AS TExpense,
r.REIMBURSEMENT_AMT AS TReimbursement,
CONVERT(varchar, r.CREATE_BY_DT, 101)as CREATE_BY_DT,
r.LENDER_ID as OFFICER_ID,
r.RC_NUM,
o.OfficerName,
FROM REIMBURSEMENT r
INNER JOIN adBorrowerObligation bo on r.Borrower_Obligation_ID = bo.BorrowerObligationID
INNER JOIN entity_to_obligation eto on bo.BorrowerObligationID = eto.Borrower_Obligation_ID and eto.entity_type_id = 1
INNER JOIN adEntity b on eto.Entity_ID = b.EntityID
LEFT OUTER JOIN OFFICER o ON r.Lender_ID = o.Enum
WHERE (r.CREATE_BY_DT >= @FromDate)
AND (r.CREATE_BY_DT <= @ToDate)
)
ad
ORDER BY OFFICERNAME DESC, CREATE_BY_DT, BorrowerName
can anyone help me out to design this report?
Thanks in advance
Crystal SSRS Migration
Aug 9, 2007
Hi James,
I need some help from you on solving a problem in Crystal to SSRS conversion.
I am trying to convert a Crystal Report to an SSRS Report.In the Crystal Report the Data is filtered using a Parameter which can accept Multiple Range Values.In order to achieve the same feature in SSRS I wrote a small Custom Code in VB.
This Function will accept the Field and the Parameter as Strings with multiple ranges separated by commas and will return a Boolean True if the field satisfies any one of the given ranges.Otherwise it will pass a Boolean false.
So only the Rows with True as return value are passed forward.
I used the above condition in the filter clause of the Datasets not in the where clause unlike Crystal.Now I face a new Problem. In the Crystal report there are 3 Groups and the Crystal Query has an Order by clause on these 3 Groups.
So In crystal after the where clause the Sorting is taking place.
Now I tried to do the same in SSRS and implemented the Order By clause in the SSRS Query.But the outputs are not matching.
One reason may be that ,In Crystal the Sorting of data in groups is done after filtering but in SSRS Sorting is done before the filtering.
Is there an alternative or any work around that you can suggest me to get the same as of Crystal.
Please help me.
SSRS Or Crystal Reports
Feb 19, 2008Hello 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,
SSRS Vs. Crystal Reports
Jul 13, 2007Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.
View 1 Replies View RelatedReporting Services - Crystal To SSRS
Sep 5, 2005I 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 RelatedConverting Crystal Reports To SSRS
Apr 3, 2007I 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 RelatedComparision 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
Converting Crystal Formula To SSRS
Feb 28, 2008Hi 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
Sql 2005 Standard Advice SSRS Crystal Reports
Mar 24, 2008I 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
Seeking Advice On Converting Crystal Reports To SSRS
Aug 20, 2007Hi. 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 RelatedReporting Services :: Migrating All Crystal Reports Over To SSRS
Oct 16, 2015I 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}
Crystal Report Using SQL CE
Aug 10, 2007I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?
Thanks,
Kathy
How Can I Modify A Report In Crystal Report 7
Jan 12, 2007I am a Web developer. I am new to VB 6.0 and Crystal Report. I havejoined an organisation where there is an application running(developedin VB6 and crystal report 7). I have to modify one report. In twocolumns I have to make minor changes i.e put and = operator. I amencountering following problem:1. When I open the report using Seagate crystal report for rational /32 bit crystal Report Designer there are three columns which are goingout side the visible area and I am not able to scroll up to them. Iincreased the page margin (left / right) and made it to zero and zerobut still I am not able to see those columns. Please guide.2. Please suggest any good web site for learning Crystal Report 7Thanks n RegardsDeepak Sinha
View 2 Replies View RelatedCRYSTAL REPORT 8.0 PROBLEM
Apr 26, 2002Hi,
I am trying to run the crystal report from asp.
its says SQL Server connection failed. But i could connect SQL server using the same DSN. Any idea???
Set crp = Server.CreateObject("Crystal.CRPE.Application")
iReturn = crp.LogOnServer("p2sodbc.dll", "DSNNAME","USERID","PASSWORD")
Set oRep = crp.OpenReport("C:inetpubwwwrootpdftestest.rpt")
oRep.Preview
Set crp = nothing
Thanks
Ilango
Crystal Report 8.5 Vs SQL Server 2K
Jan 12, 2004Does Crystal Report 8.5 work OK with SQL Server 2K ?
Anyone encoutered problems for with this couple of programs ?
SQL 2000 && Crystal Report 11.5.8
Feb 25, 2008I have a report that feeds the data from SQL 2000 and its giving me this error:
Failed to retreive data from the database.
Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ Connection Open (Connect ()).] SQL Server does not exist or access denied.
SQL State:08001
Native Error: 17 [Database Vendor Code: 17]
I test the database and its ok, we update both Crystal and SQL and nothing happend. We test communication from PC to server and everything looks OK. We check ODBC Settings and looks fine...
Thanks in advance
Generating Crystal Report From Sql Server
Mar 4, 2001we have data base in ms access and reports in crystal reports 5 recently we converted our data base to sql sever 7
and reports to crystal reports 8. when i opend directly in cystal reports and given data base connecting through oledb
i am getting reports but from the application it is in vb6 the report window is poping up and latter a error msg saying un able to open sql server
when i checked up the connection it is ok help me
anil
Crystal 9 - Broken Report SQL Server
Dec 8, 2005I'm using Crystal 9 with SQL Server database. I have a report that was working fine for the first 8 months. As soon as I add another month, the report fails. I've tried different setting in my indexes with different variations of periods. The minute I have over 8 periods included, the report fails. No errors, just no data. I don't even have a clue where to look for possible answers on the Internet.
Can any one help or direct me to some resources??
Thanks,
Debbie
Can You Launch A Crystal Report From A Sql Trigger
Mar 21, 2006and if so does anyone know where I can find some code examples?thanks
View 1 Replies View RelatedCrystal Report Parameter Issue
Jun 14, 2007Hello,
There is probably a really simple solution to this problem... but, here it is..
I am working on CR Designer v11 and have a report that uses a stored procedure. Originally, when the report was created, this stored procedure had one parameter. Since then, however, I have added an additional parameter to the SP in SQL. After doing so, I opened the report, in report designer, and manually added the new parameter to the parameter list. I then realized that I did not need to do this. The Verify Database function should auto populate the parameter list for me. So, I then deleted the parameter(that I had created manually) and performed the Verify Database. But now the parameter does not auto populate in the parameter list.
By deleting the parameter (that I had created manually), did I cause the designer to ignore this second parameter in the actual SP? How can I get the designer to auto populate the parameter list with this new parameter?
Crystal Report Reference Errors
Feb 14, 2008HI,
I have a windows .net program that creates and displays crystal reports. I was able to download all
the .dlls a needed such as the CrystalDecisions, etc.., however, when i ran my program it tells methat I cannot run these .dlls outside of managed code. Where do I need to put these .dlls and how do I make my application work?
THanks
SQL Stored Procedure To Populate Crystal Report
Mar 15, 2004I'm working on a stored procedure to populate a Crystal report. My company insists that we put the report parameters in the stored procedure instead of in Crystal...so that the SQL server (rather than the desktop)does the work of restricting the data. Is there anything I can do on the SQL side(possibly User Defined Data Type) to get Crystal to prompt me for a date WITHOUT the time? I started with this:
CREATE proc uspReportData @BeginDate datetime, @EndDate datetime
When Crstal prompts me for the parameters, I can type the date or use the calendar to pick a date, but I AM FORCED to enter a time. I know I could choose to ignore the time in the stored procedure, but the users don't want to see the time section of the parameter. Apparently SQL doesn't have a plain "date" parameter without a time.
I've also considered this:
CREATE proc uspReportData @BeginDate char(10), @EndDate char(10)
However if I do it this way, I can't seem to find a way to make sure a valid date is entered when Crystal prompts the user for the dates.
If using char(10) turns out to be the best method, is there a way I can pre-populate the Crystal prompts like this:
@BeginDate = 1st day of the current month
@EndDate = the current system date
Crystal seems to allow hard coded default values, but I can't find a way to do calculated default values.
I'm open to suggestions.
Thanks,
Mike
Calling A Stored Procedure From Crystal Report
Aug 7, 2007I've tried to find this documented on the Internet and found Crystal Reports User's Guid online documentation (582 pages of it!) It looks like it will be helpful for my other questions, but what I'm trying to do right now is call a stored procedure from my crystal report. So in Field Explorer under Database Fields my stored procedure is there with the three columns it selects. How do I put these three columns on my report? I try dragging them to Section 3 details and they're there but when I preview the report all I get are the headers, not the records. Is there something else I need to do? It requires an input parameter which I am not getting prompted for - maybe that is my problem, without an input parameter it can't successfully run the stored procedure, so how do I make it prompt me?
Thanks for helping me with my first Crystal Report!
CLR Stored Procedure Not Visible In Crystal Report XI
Jun 29, 2007Hi guys
i am developing a Performance Management System for my organisation and reports are quite complex. so i thought to create a CLR stored procedure and then use this in Crystal Report.
The problem I am facing is that the CLR stored procedures I create using Visual Studio 2005 are not visible from Crystal Reports XI come with Visual Studio 2005. I can create stored procedures using standard transact sql and these are visible, but the CLR stored procedures are not.
I Simply create a CLR store procedure in Visual Basic and debug it. This CLR procedure then appeares under stored procedure node in SQL Server 2005.
I've noticed when I browse the stored procedures in my SQL Management Studio that the image of the stored procedure has a padlock shown in the icon, as if they are locked?
Do I have to explicitly enable a security attribute on CLR stored procedures to make them visible?
any help would be highly appretiated.
best regards
Ali
Link 2 Store Procedures In 1 Crystal Report
May 20, 2015In a report called ICD_PrivateHospital, I have designed to show output to two table from two store procedures. 1st store proc: usp_RPT_Private and 2nd store proc: usp_RPT_Private2.
I have created both the store procs and it is executing successfully. I also have designed the Crystal Report in Visual Studio 2008.
I have added both the store procs in the crystal report with no error. I only wants to show top 20 records. It is running successfully when I add the fields and parameters from the first store procedure. But when I add the 2nd store procedures fields into the report, duplication occurs for both the results in store proc 1 and store proc 2. How to solve this issue?
Which Is Faster Reporting Services 9 Or Crystal Report 11?
Jun 12, 2007hey 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
Unable To Connect To SQL Server - Crystal Report Integration
Oct 11, 2005Hi,
I am using SQL server 2000, Crystal Reports 8.5. I dont see any problem with accessing thro' VB Coding(ADODB).
Crystal Report connection thro ODBC also working fine.
But when i try to connect to database thro "More data sources" -> SQL server , i was thrown out with an error "Unable to connect to SQL server servernam"
I have uninstalled & Reinstalled both SQL server and Crystal Report. Still not working.
I have been struggling with this problem for quite a long time.
Can any one give me the solution for this ??
Regards
SRagghu
Question Related To Reporting Services Vs Crystal Report
Apr 10, 2007I 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.
Crystal Report Error Message (Must Declare The Variable)
Apr 2, 2008hi there,
I have a crystal report that calls a stored procedure from SQL Server 2000. The only parameter I have is @A
the SP is:
--------------
CREATE PROCEDURE Final
@A INT
AS
Declare @SQL VARCHAR(2000)
SET @SQL = 'SELECT * FROM Schools where Areano = @A'
EXEC(@SQL)
GO
-------------
From the standard report creation wizard, i choose the data (SP). and select the SP, then i got window to enter a parameter values for @A, and i check ( Set to Null value), then press OK, the following error occured
Must Declare the variable @A
Please help me!
Best Regards