Hello, I have a little problem with the vertical lines in Detail section. In detail section at the end there is horizontal line. Also I have Report Footer section which displays total number of records. I suppressed Page Footer section. I would like end all the vertical lines to the last line of the records not to extend beyond the "T...
Is there a way to specify the transaction isolation level when Crystal Reports queries a SQL Server 2005 database without resorting to any of the following: Encapsulating the report's query in a stored procedure that executes SET TRANSACTION ISOLATION LEVEL... before the query itself Hand-writing the SQL query in Crystal Reports to exe...
I am using the Crystal Report Viewer in an ASP.NET application. On the viewer it displays the page numbers along the lines of '1 / 1+' where the 1+ is dynamically calculated. I would like it to display the correct total number of pages from the start rather than 1+. Is there a way to do this? ...
Hello, I have couple of images in my SQL SErver 2008 table of which the datatype is image. In my VS.net 2008 project I have a crystal report which is displaying all the fileds from that table. But the image is showing as blank. Any thoughts, How I can make it work? ...
I'm using the Crystal Reports-2008 included with VisualStudio 2008. I would like to change the image that is displayed on the report at runtime ideally by building a path to the image file and then have that image displayed on the report. Thanks, Sr ...
The situation is the following: In a database I have a table that stores the number of occurrencies an error occurred. Say ErrorId Timestamp N Err1 t1 2 Err2 t2 7 I query this data, and must use the cross-table of crystal report to show the data. Three (3) error codes must be shown: Err1, Err2 and Err3, in t...
I have a crystal report written in 10 with two parameter fields start_date end_date Both have been placed in the header of the report. Now I would like to select the results of the report based on the 2 dates. When I click on Select Wizard >> click "new" tab >> select database date type field and then "is between" condition. The ...
public void crys() { con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Documents and Settings/techsoft/My Documents/Database.accdb;Persist Security Info=False"); con.Open(); OleDbCommand cmm=new OleDbCommand ("select * from Table3",con); DataSet ds=new DataSet (); OleDbDataAdapter db...
I have created a report which links into subreports. I created parameter fields to feed into the parameters of the subreports using subreport links. If I do not add a subreport link and therefore the subreport is prompting for the value directly it will allow the set to null option. However if the enter value prompt is being generated ...
Hi, Does anyone know how if there is a way to link to a Folder or Report contained in Business Objects Enterprise? I would like to add a link on my intranet web site to a Report. ...
hello everybody, I want to set image as report background. I insert new section before details-section and insert picture there. and in the Section Expert set "Underlay Following Section" to true. that's worked but my tables remain blew. I also create new report and set it's background and insert the main report as a sub-report inside it...
Hi all, I am trying to use the crystal reports application in ubuntu. So far i was able to connect the MYSQL database using c# in .net platform and run a small application in ubuntu over crossover linux. But when i try to fetch the data from mysql database and display in crystal reports i get an error as shown in the below picture: ...
I have a number of Crystal Reports (9) report files that are distributed with a legacy VB6 application. When distributing the application to different customers i'd like to make sure that the original servernames and login information is not contained in the .rpt-file anymore. The login information is set in the code anyway. As soon as ...
Hi. I'd like to know whether crystal reports allows url access to render reports? I know we can create webpages that host a reportviewer object. However, I plan on using C# windows service to access the report, i.e. through a url. The report I wish to generate needs to be in MHTML/HTML and PDF format. So if I could do something that UR...
hi How to feeding Crystal Report 8.5 parameters from VB6.0 Application? ...
I'm making a change to some legacy software to dump the contents of a CR7 report in the "Record Style" format, which basically dumps each visible data field into a fixed-length text file. This is all well and good, with one exception. All of my numbers are being rounded to the nearest whole number when I need some of the numbers to sho...
hi all i'm using vs2005 ,crysal report i want to make a chart that shows the days on x-axis like this(1/1-2/1-3/1 till 11/1) where 1/1 means the first of january can any one tell me the steps starting from the type of chart till the answer of my question thnx in advance ...
I have set up a crystalreport by using a dataset. After binding it to the crystalreportvewer I get no error, but the database fields are simply not visible. I have done it in vs.net 2005, using C#. Can anybody help me? ...
I have made a new report using Crystal Reports 8.5 (report1) which uses a stored procedure as its data source. The stored procedure has 2 input parameters (@p1 and @p2) and when I enter some test data for @p1 and @p2 within crystal report IDE , every thing is all right. Then, I added the report1 in visual basic 6.0 IDE and added a new fo...
I have a value in a report that is returned as a number for example 1 - What i am trying to do is whenever 1 is displayed in the report i want it to show text such as Program Live. I am using crystal 9, any help would be appreciated. ...