I've got an existing report with quite a few fields on it. I have just modified my database changing a varchar(10) to a varchar(20) When I test it out with data '12345678901234567890' the query against my view works perfectly fine. However, even after I've completed a "Verify Database" it doesn't display the whole value. I have attemp...
Hi, Here's my situation. I've got to report a list of activities for a place chronologically. There are a multitude of different kinds of activities. They do share some data in common (i'll put this in the main report), but I want to have it so that depending on what kind of activity is done, a different subreport shows the details that...
Guys, i have a crystal report with a combination of database fields and static text. Is it possible to resize the field or reduce white space between these fields and the static text? For ex: John works for "fieldA ", his title is "fieldB ". In some cases, there is significant white space between the static text and the field, s...
I want to use a DNS-less connection Report in order not to set the DNS each time that I install my application but I have problems when I try to set the connection string from C#, the best thing that I have found is: http://stackoverflow.com/questions/674363/how-do-i-change-a-crystal-reports-odbc-database-connection-at-runtime I have tr...
This is my current query to pull data out of an Access Database: SELECT Count(Master.MasterID) AS Logs FROM Master WHERE (((Master.SubmitDate)<=#5/01/2010#) AND (((Master.CompleteDate)>=#5/01/2010# Or (Master.CompleteDate) Is Null))); Currently I have to change the date for each month I want to find the count for. I am trying to migra...
i am working with c# windows application as front end and mysql as back end. Now i am creating crystal report,in that crystal report i need to show serial no which not in my table. How can i put serial no for each row in crystal report. Thanks in Advance. ...
In Business Object XI 3.0, while logging in publishing wizard I am getting following error. Any Help please Logon Error Transport error: Communication failure.(FWM 00001) OK Even CMC option is also not working. Yesterday also it was giving same problem. I had reinstalled the software. then it started working. Now today it is ag...
I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data it was pulling and what WHERE clause parameters were used. I can open it up and see the report layout. But when I select Database|Show SQL Query...
I have an application that uses the Crystal Report COM SDK to create and manipulate reports against a Crystal Enterprise 10 repository. I would like to upgrade from Crystal Enterprise 10 to BusinessObjects XI and try to minimize changes to the existing application. I remember that the initial BusinessObjects XI release had a COM SDK pro...
I've designed a crystal report that will be sent to a specific (barcode) printer through a web interface. Allowing the report to be generated in the standard crystal report viewer was causing issues, so I am now using the code-behind to send the report directly to the printer. ReportDocument Report = new ReportDocument(); ...
i am working with windows forms application.i need to put serial no for records which is coming from database,is record number help for me for that solution.i dont have serial no field in database i like add from frontend. I Found that Record no help for me but also some problem in that ,it shows the values with decimal value like 1.00,e...
i am using record number from formula field for SerialNO.Recordenumber shows the values in decimal format like 1.00,2.00 etc, but i like show that in 1,2 etc ,how can i do this pls i need very urgent.Thanks In Advance ...
Hi, In my crystal report, I am actually filtering the data based on start date and end date. But I am not getting data out of a fixed range(1-1-1985 to 31-12-2009). Data I am getting is directly from DB table, I am not calling any procedure. I checked all possible way to restrict/filter the data, I could not find anywhere they are f...
i am working c# windows form application and also in crystal report.i am retriving the date from database in datetime format but i like display date only in report,Is any formula field in crystal report help for me for this problem.Thanks in Advance. ...
I have following code for export to excel in ReportByApp.aspx page containing crystal report crReportbyApp.rpt Dim outstream As System.IO.MemoryStream Dim strFileName As String strFileName = "Report_" & Now.ToString("MM-dd-yy") & " " & Now.Hour.ToString & Now.Minute.ToString & Now.Second.ToString & N...
Hi guys, I am trying to build a setup file which will install my vb.net application with database and crystal report files to the client. 1.) I created my vb.net application in release mode. 2.) I created new setup project and added my vb.net application project in that solution. 3.) Also added the primary output in application fold...
Is there any way to export a Crystal Report as an image? CrystalDecisions.Shared.ExportFormatType The above type doesn't include anything that looks like an image, so does anybody have a clever workaround to generate an image? I am using C# to generate a PDF already, and I would like to generate an image (.png, .jpg, .gif) along sid...
hi all, I might be very stupid to ask this question. But I really hav no idea how to do it. My boss wants to get a crystal report and he wants 2 formats. that means he wants summary page on page 1 with one format and details page on page 2 with another format. So I have been thinking two ways. 1st way is to get 2 formats in 1 crystal r...
We have an application written in Delphi and we are using Crystal report 11 for reports. There is a HP 3 tray printer which we uses for printing. Our order form is printing to tray3 in pre-printed document, and after that the order details are supposed to print on tray2 plain paper. But its not happening, if we are doing these tasks simu...
I'm working in Visual Studio C# and want to make reports with Crystal Reports, but this software will be installed in another computer, so my question is how I can send as a parameter the local server name and the path where the file .rpt will be located to the Crystal Report so the application would be generate the report in any compute...