hi how to change "-1" to "yes" value in Crystal Report field ? i have database that connect to crystal report, one field has "-1" value i whant to change it to "yes" and "0" value to "No". how i can do it ? thank's in advance ...
I need to set the subreport name through code. How do i do this ? i dont want to change through Format Editor. Is there any way to set the Sub report name in C# ? For Ex: int number ="10"; I need this number to be shown as subreport name.and when clicked on that number,subreport details will be shown. Name Address Number Merc...
Was helping a friend who has some 100+ "Crystal Reports 2008" reports as part of a "asp.net website project". I do not know how/why, but when this "asp.net website" project is building, it spends about 15 minutes "building" the reports directory where all the Crystal Reports reside. Can Crystal Reports files .rpt's even be build/compi...
Often I'm creating reports in Visual Studio's Crystal Reports and want to have a master-detail or 1-many type thing. Something like this: Invoice Number 13245 Total: $1,000,000 Date Raised: 1-Jan-1989 Date Due: 1-Jan-2019 Line items: # Desc Cost 1 Hat 23.00 2 Gloves ...
I am able to open and see crystl reports designed for VB5 on crystal report in VS 2005. The database in use is Ms Access 2003; Error reported while trying to bind the old .rpt files to winforms. value cannot be null parameter name : path1 Please help me in how to fix this problem. Thank you ...
I hope I can explain this well enough so that you can understand the problem. I've created a Crystal Report with 2 columns of fields. The right column contains on large field containing a description, the left column contains a series of small fields like so: Marketing {description} {marketing} Sales Points {sales points} Al...
I want to bring in all the values in a specific field to populate a parameter. I can do so, but I also want to add the word "..ALL" to the head of the list so the parameter essentially becomes optional. When I choose a new data source, I don't seem to have the option of entering a SQL statement to pull the values, I can only choose a f...
I have a report that I'm exporting to PDF using the VS2008 version of Crystal Reports. There is a field that displays a product description that contains HTML data pulled from my database so I've set Text Interpretation to HTML for the field. The text displays fine with all the appropriate HTML formatting, however, there is only a singl...
Is there an API call for Crystal Reports 8.5 that will generate a TTX schema file from a VB6 ADODB.Recordset at runtime, much in the same way you can generate an XSD from a DataSet in .NET? I could roll my own, and I think I probably will have to, but I don't want to reinvent the wheel because I missed something obvious. ...
after some googling-fu on making subscript text in crystal report, i found this, this and numerous others. my question is, how can you know if a problem(or lack of feature) on a certain software is a business case or technical one? a part of me tells that this is a business case(Business Object(SAP?)), they want to squeeze money from ...
I need to make a pivot table on my Crystal Reports. Right now i'm using an OCDB connection...but while i know you can create a pivot table in CR, i'm not 100% sure how to do it. Anybody here know an easy step-by-step way to do this? ...
I have followed the Microsoft tutorial here to create a Crystal Report (with v12.0) within Visual Studio and attach it to a web form using a CrystalReportViewer, CrystalReportSource and SqlDataSource as I wish it to read data from my SQL Server instance. The report will load fine once (this appears to be snapshot data though saved embed...
Hi, I have devoloped an application in Visual Foxpro 9.0 using Crystal reports 10 as report designer. Database in SQL 2005. For report preivew, I have used Crystal Report Viewer 10. My problem is, while exporting it in PFD through Report viewer, How do I set default File name for the exported file? By default it gives name of rpt file ...
I have an ANT build script that deploys a WAR folder into my JBOSS deploy directory. Can I convert that into an executable WAR/JAR file and run it as well? For example if my folder is called: MYAPP.WAR, can I generate: NEWAPP.WAR where NEWAPP.WAR is an executable file. If i just place it in the Jboss directory and start JBOSS will it pi...
I added a new field to a stored procedure. How do I get it to be available in Crystal Reports without resetting the datasource in the database expert? ...
hi, iam having database table like ItemId,ItemName,Quantity,UnitPrice. Now iam caluculatin the unit price with given frontend value and assigning that value in to label.now i want to generate the report like itemname,quantity,that label value. plzzzz can anybody help ...
How can i make a crystal report every cell to be clickable. By which we can navigate to the other page according the cell value. ...
We are using Visual Studio 2005 and 2008, sending a Crystal Report with embedded codes (in a native printer font - Courier) to a RightFax printer (server). Visual Studio 2003 works; this process stopped working (the embedded codes aren't recognized) when we upgraded to Visual Studio 2005, and then 2008. With Visual Studio 2003, we use ...
Can anyone suggest best method for what I want to accomplish? I have an VS 2008 asp.net(MVC) web app and I am using Crystal Reports as my report engine. My app accepts parms from a form and calls a SQL Server stored proc to create a Dataset which I set as the datasource for the report. The report was created using an XSD file as a schema...
i have a many to many table relationship that involves 2 logical tables. Record table that joins to a relation table on primaryID Second instance of record table that joins to the relation table on ReciprocalID The purpose of this is to show family relations within the database. Each primary Record table has one or more rows in the rel...