Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search


Crystal Reports :: Duplicate Values In Details Section

I have the following tables:ACTNUM inACT1 and ACT2 is linked to ACTNUM inACT0. I amusingACT0.ACTNUM for grouping (Iwant todisplay allMEMOTEXT and all Descfor each ACTNUM). the poblem is thatI am getting duplicate values in the details section although the dataset is being filled without those duplicate values.

View 1 Replies (Posted: Feb 05, 2010 03:52 AM)

Sponsored Links:

Related Forum Messages For ASP.NET category:
Crystal Reports :: How To Fix The Details Section Height
I have an issue while working with a Crystal Report 10.0 I am printing a Students records in a pre-define format. now the detail section is dymaically change beacuse of No. of records for the studentsfor some students there are 8 record ,& for some other students only 2 records are theirbecause i am printing on pre defined format when 2 records comes in the details section it is placing the reords at wrong places

Posted: Aug 28, 2010 05:37 AM

View 1 Replies!   View Related
Crystal Reports :: How To Change Details Section(Section3) Height In Code Behind
I want to change Details section(Section3) height in code behind

Posted: Aug 25, 2009 07:13 AM

View 8 Replies!   View Related
Crystal Reports :: Independent Section Printing?
I have a report, whichhas two sectionsnamely Labour and Spares.In labour section no of records per page must be limited to 5 recordsand the Spares section have to limit to 10 records per page.If either Labour or Parts exceed the max limit the records must be shown in the next page.

Limiting one section by using formulas can be done easily ...but it is very difficult control two sections simultaneously.

Posted: Jun 08, 2010 08:52 AM

View 1 Replies!   View Related
Crystal Reports :: Delete Space Between Each Section?
this is an image of structure of my crystal report and the result of it as you can see, there are no space between the label "auditor" and the beginning of section2, but then i run it, crystal insert some blank rows in it how can i do to delete this space?

Posted: Mar 23, 2010 12:59 PM

View 1 Replies!   View Related
Crystal Reports :: How To Set Fixed Length Of Detail Section
Actually i am creating 1 sofware in which i need to print bill. On that bill my page header (company's name) is constant & on Report footer (companys rule & some more data) is also constant. & myDetail section is varying. On bill if data is short,my footer goes upside.

I need to fixed my detail section so that position of detail section will be maintained.


I need to fixed myfooter section so that position offooter section will be maintained.

now which is the solution form above 2? . and how to implement?

Posted: Apr 03, 2010 08:20 AM

View 1 Replies!   View Related
Crystal Reports :: Pass String To Textbox At Header Section
I want to pass a string to textbox at report header section. how to do this? Devlopment plateform is C# ASP .net. (VS2005)...

Posted: Feb 01, 2010 10:07 AM

View 3 Replies!   View Related
Crystal Reports :: Detail Section Coming With Multiple Headings
Ijust started playing around with crystal reports. Icreated a report crystareport1.rpt and from the data base fields section I dragged and dropped empid, empname into details section. I want the report to show

empid empname
1 a
2 b
3 c

Like this . But now it is displaying

empid empname
1 a
empid empname
2 b
empid empname
3 c

Like this how can i get the desired out? One more thing on the button click I wrote


But I am unable to open the report whatshould I do to see the report?

Posted: Feb 01, 2010 04:15 PM

View 4 Replies!   View Related
Crystal Reports :: Duplicate .vb Code Behind Files / Getting Error?
I have a weird problem that I am struggling with. We have a legacy project (VS 2003), and all I have to do is change a Crystal Reports label, when I change it and save it creates an additional code behind file. So after saving I have the file rptInvoice.rpt with two dependant files rptInvoice.vb and rptInvoice1.vb. I have no idea why it is creating an additional file but it is causing a compiler error.

Posted: Apr 23, 2010 07:29 PM

View 1 Replies!   View Related
Crystal Reports :: Count Total Number Of Record In Group Section?
how to count total no of record in different group section in seagate crystal report

Posted: Jun 02, 2010 07:26 AM

View 2 Replies!   View Related
Crystal Reports :: How To Pass Values From Page Or GridView To A Crystal Report
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?

Posted: Mar 30, 2010 06:21 AM

View 3 Replies!   View Related
Crystal Reports :: How To Pass Values From Page To Oracle Store Procedure In Crystal Report
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure.In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.

Detail code:

1. ASP.NET page store the values in the Session:


2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.

Posted: Mar 11, 2011 07:32 AM

View 3 Replies!   View Related
Crystal Reports :: How To Pass Values To Crystal Report
i can develop crystal report with password itself.But, i want to pass values in to crystal report programatically..

Posted: Mar 14, 2011 01:29 PM

View 1 Replies!   View Related
Crystal Reports :: Either The Crystal Reports Registry Key Permissions Are Insufficient Or The Crystal Reports Runti?
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

Posted: Aug 05, 2010 12:13 PM

View 2 Replies!   View Related
Crystal Report: Display 0.00 For Duplicate Values
I am making a crystal report which displays values from database. Now the values from db contains duplicate values. I need that duplicate values should be suppressed and should display 0.00


Should display

I have applied "Suppress Duplicate" to the column but don't know how to display 0.00 there.

Posted: Feb 11 at 7:16

View 1 Replies!   View Related
Crystal Reports :: Logon Failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description
I wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:

note: Crystal Report works fine in dev environment....

Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,

1. Microsoft OLE DB Provider for Oracle

2. Microsoft OLE DB Provider for ODBC

but we got the same error in report module when we using two methods.

Our Coding : //CrystalDecisions.CrystalReports.Engine.ReportDocument crpt = new ReportDocument();
private ReportDocument crpt = null;
private void Page_Init(object sender, EventArgs e) [code]....

Posted: Feb 24, 2011 09:58 AM

View 3 Replies!   View Related
Crystal Reports :: Logon Failed. Details: Crdb_adoplus : Object Reference Not Set To An Instance Of An Object?
I am using Asp.Net 3.5 .I have created one Crystal Report (Business Object) , for datafields I have taken one DataSet.Now when I run the Page where ReportViewer is placed, it asks for Dataset Login.I change the property EnableLogonPrompt=False then it gives following error

Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File E:DOCUME~1ADMINI~1.AMULOCALS~1TempCrystalReport1 {E2E91774-D27C-4994-BABE-0835B1AEE10E}.rpt: Unable to connect: incorrect log on parameters.

Posted: Mar 21, 2009 05:43 AM

View 12 Replies!   View Related
Crystal Reports :: Integrating Crystal Reports XI(stand Alone Reports) With Web Application?
I'm new to Visual Studio.NET .I need to integrate the crystal reportsinto an ASP.NET application. I generated Crystal report with the help of crystal report XIdeveloper edition(Stand alone version andNOTfrom the one which comes from visual studio).

How to integrate this report with theweb application.

Posted: Jun 13, 2010 06:15 PM

View 1 Replies!   View Related
Crystal Reports :: Calling Reports Developed In Crystal Reports 8.5 In VS2008?
We have quite afew reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).

What dlls are needed forcalling 8.5 in the applicationand how should they be added to the application while shipping it to the client?

They are also struggling to get the code running. Would also need the code to call the report with parameters.

Posted: Jul 16, 2010 10:08 AM

View 9 Replies!   View Related
Crystal Reports :: Missing Parameter Values?
I have a Crystal 10 report with 4 subreports, the main report and the first subreport use data from the same tables and then the other three subreports use common tables different from the main and first sub.

I have an unused parameter (I can't find anywhere it is used) on report #4 but can't delete it because Crystal says that it is being used. Do I need to code for this parameter?I am not coding for the unused parameter.

Each report uses a parameter named ?dir_id as part of the Selection formula. Following is my code and the error I am getting.


CrystalReportViewer1.EnableParameterPrompt = False

CrystalReportViewer1.SelectionFormula = "{Print_Req.Dir_ID}= [code]....


Exception Details: System.Runtime.InteropServices.COMException: Missing parameter values.

Source Error:[Code]....

Stack Trace: [Code]....


Posted: Apr 13, 2006 06:32 PM

View 2 Replies!   View Related
Crystal Reports :: Not Showing All The Values Of A Particular Field?
I have a query that returns a field called Type. Possible values for Type are A, B, C, or Unknown. I want to create a table that will show the number of rows of each Type but not the not the Unknown type. Also I like the table to show the percentage of known types versus total types. So the table show look like this:

Type Count

A number of rows with A Type
B number of rows with B Type
C number of rows with C Type

Total: (number of rows with A, B, or C Types / number of all rows with A, B, C, or Unknown Types)Please someone tell me how to do this in Visual Studio 2005 reports.

Posted: Mar 05, 2010 05:06 PM

View 2 Replies!   View Related
Crystal Reports :: Distinct Combination Of Two Values?
I have distinct value combinations of two values.i cannot achive in sql why beacause ,here crystal report having grouping options and output will going to print in a foote..

Sample format crystale report

SNo Name TranID
1 Guru 18
2 Inbaa 19
3 Guru20
4 Inbaa 19
Total Name : 3 Tran ID :3

Name inbaa with Tran ID 19 is duplicate ..

Posted: Dec 17, 2010 12:34 PM

View 2 Replies!   View Related
Crystal Reports :: Printing With Crystal Reports Activex Print Control In Vista IE8?
I installed IE8 all my intranet reports after I click on print button stop working. Once I click the button the popup window appears and inmediatly closes.

On my other machines, windows server 2003 with IE8 and XP IE7 the print control works fine, I also disable all the security options on the IE8 in vista to see if there is any popup blocker or Activex security issue, but its the same, I enable all the options to be able to execute activex of any kind and still cant print.

The printing mode of the reports are ActiveX

I dont have any clue about what is happening, and also I didnt find other people with this problem.

Posted: May 11, 2009 04:19 PM

View 5 Replies!   View Related
Crystal Reports :: Passing Parameters In Crystal Reports Dynamically Selected By Users
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.

Posted: Apr 06, 2010 08:54 PM

View 3 Replies!   View Related
Crystal Reports :: Display The Patient Details Of Only One Patient ?
I have database with 5 tables as follows in my crystal report I am trying to display the patient details of only one patient (whose pid is requested by the user) and display the tests information of that patient.I have created a dataset and have the following code in codebehind of crystalreportviewer


I also have a stored procedure to check the whether the pid entered is same as the pid in the test reports tablessomewhat like follows


but still It is not displaying anything in the crystalreport.

Posted: Mar 15, 2011 01:37 PM

View 6 Replies!   View Related
Crystal Reports :: Null Values In Formula Fields?
I tried using this and am concatenating the fields together. It does not appear to be working. Here's what I have.

Posted: Sep 16, 2010 11:33 AM

View 7 Replies!   View Related
Crystal Reports :: While Adding Add Reference It Showing Crystal Reports Version 10 Instead Of 11
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.

Posted: Jan 04, 2011 12:14 PM

View 1 Replies!   View Related
Crystal Reports :: Deploy Crystal Reports On Remote Server Without Running MSI?
I am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?

Posted: Feb 15, 2010 05:58 AM

View 8 Replies!   View Related
Crystal Reports :: Increase String Size In Crystal Reports For VS 2010?
I have a field inmy dataset with type nvarchar(1000). when I link it to crystal reports, itconvertsit toa field of type string withlength set to 100.As a result of that,the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).

Posted: Sep 01, 2010 06:58 PM

View 3 Replies!   View Related
Crystal Reports :: Report Prompts For Param Values When Pageing?
I have created a CR which uses two static parameter fields for 'DateFrom' and 'DateTo' on the report. The parameters are passed to the web page via a query string, and then I use Dim Fromdate As String = Request.QueryString("from") etc to send the parameter via code. The problem I'm having is this. The DateFrom and DateTo values are being sent to the report ( I simply use them in the report header to display the from and to dates selected by the user for the report ) and the report display's as expected. But when you click 'Next' in the multipage report, the report prompts with a parameter popup box to reenter the dates. Once you enter the values, you can page back and forth without any more interuptions.

Would anyone know what I have set wrong? Here is the code that I use to populat the report.

Dim reportpath As String = ""


Posted: Sep 14, 2010 04:32 PM

View 2 Replies!   View Related
Crystal Reports :: How To Run Crystal Reports From Web Server Having .net Framework 2.0 Installed
I have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.

Posted: Feb 09, 2010 05:49 AM

View 1 Replies!   View Related
Crystal Reports :: Dynamic Graphic Location In Crystal Reports XI R2
I have an issue with a Crystal Report and dynamic graphic locations, which has been developed in Crystal Reports XI release 2, running from an ASP.Net web page.The report has two images that have dynamic graphic locations, which are taken into the report as parameters. The report is then used by an Aspx web page to create a pdf for the user, this is done using the following code:

rpt.SetParameterValue("PID", ProductID)
rpt.SetParameterValue("HPic", Server.MapPath("") + "IMAGESReport headers")
rpt.SetParameterValue("BPic", Server.MapPath("jacketsmedium"))
rpt.SetDatabaseLogon(ConfigurationManager.AppSettings("DBUserName"), ConfigurationManager.AppSettings("DBPassword"), ConfigurationManager.AppSettings("DBServer"), ConfigurationManager.AppSettings("DBName"))
rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, True, "Flyer")

Posted: Sep 21, 2009 11:57 AM

View 1 Replies!   View Related
Crystal Reports :: Generate Crystal Reports Through Query String?
I want report generted based on value from querystring.

Posted: Jun 15, 2010 01:51 PM

View 3 Replies!   View Related
Crystal Reports :: Crystal Reports Error When Publishing A Website On To The Web

Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception

Posted: Feb 04, 2011 04:43 AM

View 3 Replies!   View Related
Crystal Reports :: Make Graph Chart In Crystal Reports?
How to make graph chart in crystal reports ?Any nice totorial for beginner.Is database very neccessary ?Also,
from where do I download microsoft chart controls for microsoft for 2.0 ?Not getting any links.

Posted: Dec 04, 2009 10:32 AM

View 4 Replies!   View Related
Crystal Reports :: Crystal Reports Basic (for VS 2008 Ver 10.5) Vs C. Reports For 2.0 (ver 10.2.36)?
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.

Posted: May 27, 2010 03:45 PM

View 2 Replies!   View Related
Crystal Reports :: VS2008 Crystal Reports - "Load Report Failed - Error"?
I'm getting the "Load Report Failed" Error.

I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.

My development system is WinXp and my deployment system is Win2003 Server.

Here is what i have done -

1) Added a Crystal Report to my project "rptReport.rpt"

2) Added a Crystal Report Source (crSource) to my .aspx page.

3) Added Crystal Report Viewer to my page, with crSource as its Report Source.

This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:

1) Giving IIS_WPG full control to temp folder.

2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.

Posted: Jul 25, 2010 11:16 AM

View 1 Replies!   View Related
Crystal Reports :: Crystal Reports Are Not Displaying On Web Server
Crystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.

CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....

Posted: Dec 17, 2010 04:28 AM

View 6 Replies!   View Related
Crystal Reports :: Generation Of Dynamic Crystal Reports
I have a requirement to generate Dynamic Crystal Reports.I am a new bea of Microsoft .net.

Posted: Mar 28, 2011 05:42 AM

View 2 Replies!   View Related
Crystal Reports :: Beginner To Crystal Reports Configuration?
We have an old server (Win Server 2003/ IIS) that makes use of an old version of Crystal Reports for pages. I'm making a new server (Win Sever 2008 SP2/ IIS 7) that will be the replacement for the old server. I have apps working, but since I can't use the old Crystal reports install, the new one isn't doing anything for me.After installing CRRedist2008_x86, it shows some files in:

andC:Program FilesBusiness ObjectsCommon2.8inAre there any special configurations I have to do in IIS to get to recognize this stuff? Right now, I'm getting nothing.

Posted: Mar 11, 2010 03:26 PM

View 1 Replies!   View Related
Copyright 2005-08, All rights reserved