I want to display a number to words. for eg : RO 70.357 should display as "Seventy Rials and three hundred fifty seven baiza" because in Oman currency is of 3 decimal digits.
My question is below
When I used truncate function to get the decimal value it returning with 2 decimal digits. eg: 70.36 (357 is rounded to 36)
I want to display exact digits without rounding a decimal value.
How to change float number such as 0.12 to 12% in CR? I knew how to % but only display 0.12%
View 2 RepliesI want to print number in the (national) form (arabic localization sys)
I tried some solutions as here: [URL] ....
But still face problems with the stringthat contain digits ....
I had a 14 digit create datetime and resolved datetime in float time format and I could parse the date using following conversion:
CONVERT(datetime, LEFT(CAST(CAST(is_resolved_datetime as BigInt) as varchar(14)),8)+' '+
SUBSTRING(CAST(CAST(is_resolved_datetime as BigInt) as varchar(14)),9,2)+':'+
SUBSTRING(CAST(CAST(is_resolved_datetime as BigInt) as varchar(14)),11,2)+':'+
SUBSTRING(CAST(CAST(is_resolved_datetime as BigInt) as varchar(14)),13,2))
If I were to extract only the time difference of two datetimes in hr:min:sec.
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 Repliesin my web application i want to validate that user can enter only digits and the digit may be a integer or decimal how can i write the regular expression for this.
View 2 RepliesI have one textbox, in which I want allows to enter value like
1, 1.5, 2, 2.5, 3, 3.5, 10, 10.5....
That means user can enter only 1 digit after decimal and it is restricted to .5 only, not .25 ot .34 or .75
Let me know how can I do this?
i have textbox it should accept only integer or float values..........
View 1 RepliesI'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesIn my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 RepliesI am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
View 8 RepliesI have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
View 3 RepliesI have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
View 1 RepliesI want report generted based on value from querystring.
View 3 RepliesCrystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
View 2 RepliesI'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
Crystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....
I have a requirement to generate Dynamic Crystal Reports.I am a new bea of Microsoft .net.
View 2 RepliesWe have an old server (Win Server 2003/ IIS) that makes use of an old version of Crystal Reports for asp.net pages. I'm making a new server (Win Sever 2008 SP2/ IIS 7) that will be the replacement for the old server. I have asp.net apps working, but since I can't use the old Crystal reports install, the new one isn't doing anything for me.After installing CRRedist2008_x86, it shows some files in:
C:inetpubwwwrootaspnet_clientsystem_web2_0_50727CrystalReportWebFormViewer4
andC:Program FilesBusiness ObjectsCommon2.8inAre there any special configurations I have to do in IIS to get asp.net to recognize this stuff? Right now, I'm getting nothing.
why does my crystal reports not loading on the server
View 4 RepliesI'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
I have requirement that have to add header and footer into 50 over reports. So I dont want to change one by one.
Is there a way to create master page header and footer and used it in multiple reports?