Can anyone enlighten me on how to find and remove a default parameter in Crystal Reports 8.5 and/or 9? I get all confused by visual code techniques like this where I can't just grep the codebase and find the string I need to remove. :D Basically, it looks like the former developer saved the report with a couple parameter fields populat...
The report is runnig fine in Visual Studio 2005 but fails when I deploy it on IIS. It prompts, the report you requested requires further information. I think it needs to get installed some service pack either of SQL server client, or of Crystal Reports. Please suggest. ...
Hi, I'd like to change the owner of stored procedure (i.e. dbo) for smth else in crystal reports at runtime. Is it possible? TIA UDP May be I need to clarify. I have a reports with lots of subreport within. I have to use this report with the other database. So I need to change the scheme of stored procedure at runtime without changing a...
OpenConnect(); OleDbDataAdapter olda = new OleDbDataAdapter("Select * from RECORD where LIC_PLATE='GE 320'", con); DataSet dataset = new DataSet(); olda.Fill(dataset); cr1.SetDataSource(dataset.Tables[0]); crystalReportViewer1.ReportSource = cr1; crystalReportViewer1.Refresh(); ...
I'd like to generate a printed version of a crystal report that has (ideally) all the field names on the report in place of the data. Is this possible? I'd also be ok with just highlighting all the fields in a different color or something like that. So far I don't see any way to do this other than highlighting all the fields and changi...
I'd like to iterate through a certain set of fields in a report (rpt) file and, for the sake of argument, make them have a blue background. I'd like to do this for many files and on a conditional basis. The ReportDocument class seems like the way to go, but I don't see any Fields or anything like that in the API. Is there a way to do t...
Hi everyone, I'm happy when your answer. Please help me, That is I have already got one report 10 (colunm) but search database in my report: 6 colunm then my report have got 6 (colunm) fit paper. And 5 colunm fit paper so on.... How do I do? Thanks all, ...
Hi, I have created static parameter which has some 4 values in crystal report 2008 and once i move that report from developement enviroment(databse) to UAT the values which i created in the parameter is getting vanished.....could any one help me out.... ...
hi i have build C# program that connect to Oracle and make some report's using crystal-report. in my computer it work's excelent (when i bind to my Oracle) but when i run my program on other computer - the program work and i see the data on the screen, but when i try to see report with crystal report i get error (problem with connection ...
I am new to crystal report here. Need to display more than 25 columns in same row for a report. No idea how to show them as the design window accomodates hardly 10 columns per row. Using this report in a .net windows application. How do i show more columns on single row of crystal report? Can anybody help on this, pls? ...
Hi guys, I have a VB6 application, reportwriter, that runs a crystal report and outputs a pdf. I have a .net 3.5 asp application that calls the reportwriter dll. I am getting an error saying 7 "Out of memory", when trying to load the report. I have 4gb of memory and running windows 7 (64 bit). I also have Crystals Reports 11 with servic...
Hai friend s i am using three colums in the crystal fields credit,debit,netbalance.in net balance i have to total the two fields credit and debit as running total and put in the net balance how to do it.output should come like this: debit credit netbalance ------ ----- ---------- -1700.00 0.00 -1700.00 -6250.00...
im using asp.net crystal report ........ sql query: CONVERT(NUMERIC(17,3), CASE WHEN CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END = 0 THEN NULL ELSE CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END END) DR, CONVERT(NUMERIC...
Hi all, in my Crystal Report have a Page Header(section Page Header "a" and Page Header "b") and Groupe Header #1 and #2 My problem is, I want to hide Page Header "a" when Group #2 have more records, I want to print records next page without Page Header "a" Please reply me , its an urgent one.. Thanks in advance ...
Hi all, in my Crystal Report have a Page Header(section Page Header "a" and Page Header "b") and Groupe Header #1 and #2 My problem is, I want to hide Page Header "a" when Group #2 have more records, I want to print records next page without Page Header "a" Please reply me , its an urgent one.. Thanks in advance ...
im using asp.net crystal report and this is sql query CONVERT(NUMERIC(8, 2), CASE WHEN CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END = 0 THEN NULL ELSE CASE WHEN GLDD_DOC_AMOUNT > 0 THEN GLDD_DOC_AMOUNT ELSE 0 END END) Q3_DR, CONVERT(NU...
Hi, all I have a problem about Crystal Report. I created a setup file with .NET. Then I install my setup, to an another computer. It works well. But when I try to generate crystal report, login screen of access database opened. It seems that --.accdb path in Crystal report is wrong. Before creating setup where can I change and how can ...
hi i have database that connect to crystal report. i have only one field. how i can print this field in 2 column ex: col1 ---- clo2 1 --------- 4 2 --------- 5 3 --------- 6 thank's in advance ...
List<NastavaIzvjestaj> nastava_izvjestaj = new List<NastavaIzvjestaj>(); var data_context = new DataEvidencijaDataContext(); int pomSum = 0; var prisustvo = (from j in data_context.nastava_prisustvos select j.br_indexa).Distinct(); var lista = prisustvo.ToList(); foreach ...
We are using Crystal Reports to generate pdf's of customer bills (from a CR template). It works fine except the engine seems to be adding the letter "i" to random words in the output. Certain alignment problems are also evident (words overlapping etc). Standard fonts are being used. We are using .net 4 and C# linked to the 10.5 CR ass...