I'm trying to create a report of some data. The data has be grouped in 2 sections: has already been done (enddata <= today) and has not been done yet (enddate > today). I created a group with groupexpert and added grouping on enddate, on specific order. Added named group 'done', with formula 'is less than or equal to' but I can't set th...
I've been doing some accounting reports and have been summing up my different currencies using a formula IE CanadianCommissionFormula if {myData;1.CurrencyType} = "CDN" then {myData;1.Commission} else 0 CanadianCommissionSum SUM({@CanadianCommissionFormula}) Then I'd just display the CanadianCommissionSum at the bottom ...
I need to use SQL SERVER to try for it and then generate a crystal report out. who can teach me how to make it as the pattern i show in? Daily Registration / Activation Report As Of 12/10/2009 Year : 2009 Month : ALL Registration Activation Port Out Month Imported Activated Imported Jan...
Given that FormulaFieldDefinition does not have a Top, Bottom, Left, or Right properties...is there any way to move/resize the formula at runtime? ...
I have a crystal report that is connecting to a database. The datatable from which this information is coming from is rather large and I need to know how to filter information. I have a field in my report that needs a list of requirements. The datatable i'm pulling from has all these extraneous requirements for other departments that ...
Hi I am trying to export a report as CSV format from Crystal Reports 11, but the problem is that each string value is wrapped inside quotes, which I don't want. I tried to set the delimiter as space but it didn't works. Can someone please help me with this..? Here is my code: elseif ExportFormat = "CSV" then ExportType = "5" ExportFile...
I have the following formula as the grouping for a Cross Tab Report: {Command.Year} & ' ' & {Command.RF Period} Year is a SmallInt and Period is a TinyInt. The problem is that it shows on the report as: 2,009.00 9.00 The database values are actually: 2009 9 I can't remove the decimal places via formatting because th...
I'm trying to show employees at a company grouped by worked and still working (in vs2005 crystal reports). The user can pass by parameter a list of companies they want to show. Tables: VRP-COMPANY, VRP-COMPANY-OPPORTUNITY, VRP-OPPORTUNITY-PRODUCT The record selection formula: {VRP-COMPANY.COMPANY company} in {?companies} Grouping is ...
I am not at all familiar with SQL expressions and was hoping to get some help I have this: "Reservations"."NY IT Services/Computer Presentation" which is a boolean How would i write this to say "If "Reservations"."NY IT Services/Computer Presentation" is a 1, then display, else do not display? I need to do this in Crystal Reports and ...
I currently need to replace an existing crystal report datasource from a View to a Stored Procedure. I tried doing "Set Datasource Location", but it wouldn't allow it. I then thought to add the proc to the datasources and just modify all the fields to point to the proc, but wasn't sure how to do this. Any ideas? EDIT I should clarif...
I am updating an existing reporting system in ASP.NET which uses crystal reports. In the past reports have been given their parameters by session variables, however I now have a need to post them in the web address e.g. www.mysite.com?reportname=myreport&year=2009 I have grabbed the parameters off using request.querystring as usual an...
I have: Delphi 2007 Crystal 11 The Delphi 7 version of the Crystal VCL component (latest one I'm aware of, and it compiles fine in D2007) A very simple test Crystal report, written in Crystal 11, which just dumps a table onto the screen (no selection criteria, no formulas, just straight data) I tried Created a new VCL forms app Dr...
Hey all I have the following fields in my report (I am running a report on meetings that occur at my company): Meeting start , meeting end , General/meeting title, general/host, booked by and finally a custom formula field that shows only IT requirements. Right now if i run the report, it shows me every single meeting that the company...
I'm trying to make a Crystal Reports 11 report off an Oracle database that's grouped by user. I've got over one thousand users. I want to create a parameter field that prompts the person to select which users they would like to view the results for. However my parameter selection field is only showing 221 of the possible users. The u...
Simple question, yet i haven't found the answer. Anybody here know how to suppress a boolean field from displaying a "False" ? For example in my report, I have fields that say True or False...i'd rather just see a True and have crystal reports suppress the "False" Anybody know how to do that? ...
I'm in the process of upgrading an existing ASP.NET2.0 application to .NET3.5 (moving from VS2005 to 2008 - yes I know I'm late!) and have encountered a problem with Crystal Reports. Basically the following line of code causes the Webdev.WebServer.exe to close and the application to crash (I'm returned to VS). CrystalDecisions.CrystalR...
I have a crystal report that is based on an XSD schema file. Within the report definition, I can modify the datasource location, specifically, the file path. This is where I can set the file path to where the XSD schema file resides on my machine. At this point, everything works correctly. Here is the problem: If the file path does ...
I'm running through this tutorial found here: http://vb.net-informations.com/crystal-report/vb.net_crystal_report_from_multiple_tables.htm which teaches how to pass a parameter text field on a vb form to an embedded Crystal Report in visual studio. I've followed it all the way through however when I attempt to build, I received the ...
I have a list of numbers and I want to somehow know if there is a number missing. ...
How do I determine when a crystal report was last run? ...