Crystal Reports for Visual Studio Forum

Problems about SubReport

Fri, 27 Nov 2009 19:55:52 Z

Hello:

I have some crystal report files need to combine together. I tried two ways:

1. create several Details Sections, Import the files as subreport. or
2. use one file as primary report, add several "Report Footer" to contain the others as subrepot.

one problem is , if subreport is a multi-pages repot, it will lost page head after first page(the page head only appear once).

Another problem is that if subreport has a subrepot, it will lost the child-subreport.

how can I solve these problems?

Thanks for help!

(I am using Crystal Reports XI Release 2)

Large file size problem and SQL Authentication problem using Crystal Report

Wed, 18 Nov 2009 14:24:19 Z

Hey all,
In my project I had used crystal report which works fine but there's a problem. file size of generated rpt files are about 16MB while one of my reports is just 320Kb in size.
I've tried everything even I cleaned my solution but sounds nothing, I don't have anything special on reports and I can't figure out what's the rational reason for crystal report to generate a 16MB file. When I open rpt files using notepad it contains a large amount of charachters like ےےےےےےےےےےےےےےےے in it which are obviously useless. Can anyone save me hours of headache?

oops, and there's one thing more.
Two of my reports are using stored procedures as datasource while my database needs SQL Authentication, in my code I had used globalReport.SetDatabaseLogon("Username", "Password") which works fine on my computer, but after publishing my project on clients using clickonce I come across a window asking me to enter username and password while openning the report , I used to get this error on my computer when I didn't use that line of code as well, but after using above code it solved, can anyone tell me how can I solve it in a way that this message doesn't appear on clients too? Obviously I'm not gonna give my database's authentication information to all the clients

learn to learn

Crystal Report Problem with sub reports that contain large volumes of data – runs for days

Fri, 27 Nov 2009 11:46:07 Z

I have a Crystal Report that has a main report and 8 sub reports.

The main report contains one record per employee, and each of the sub reports displays information about different data pertinent to the employee, e.g. cars, loans, medical benefits, etc. Each sub report may have zero – many records.

The application that runs this report is supplied to a variety of customers. These customers may have MS SQL Server or Oracle databases.

The Crystal Report is invoked via a VB.NET program. The program reads all the data required from the database into a dataset. The data is passed to the report using ReportDocument.SetDataSource for the main report table and ReportDocument.SubReports.Item(“xxx”).SetDataSource for each of the sub reports.

Each of the datatables is described using an XSD, for the main report data and each of the sub report’s data. The Crystal Report uses these XSDs to describe the data and create the report fields.

The main datatable has approximately 25,000 records.

Subreport 1 has approximately 31,000 records.

Subreport 2 has 5,000 records.

Subreport 3 has 2,500 records.

Subreport 4 has 0 records.

Subreport 5 has 30,000 records.

Subreport 6 has 2,500 records.

Subreport 7 has 1,000 records.

Subreport 8 has 1 record.

These numbers may be higher in future. The more data records that the sub reports return makes the report exponentially slower.

When we are dealing with smaller amounts of data :- eg. Maximum of 1,000 records for each, then the report runs through in a few minutes. With the data as described above it was running for 2days and it still didn’t finish! Obviously NOT ideal for the customer.

As a test I have tried to using OLE DB to access the database direct, so that I could use ADD SQL Command to select the data for each subreport, but I could not find any way of reducing the number of records selected. It would dramatically reduce the time of the report if I could pass a “Value” from the main report into the Command SQL in each of the subreports, so that in the WHERE clause it has EMP_ID = {passed in EMP_ID} from the main report. This EMP_ID changes for each of the 25,000 employees in the main report. It seems that you can pass in a fixed parameter and not a dynamically changing one. Don’t know too much about SQL Expressions and whether or not they may be of any use.

Obviously I would like to keep the report as it is with regards to using ADO.NET, just with some magical workaround to speed up the report.

I have spent days googling for possible solutions and none have yet to be suitable, obviously avoiding sub reports is a good answer, and I have avoided them in the other reports and they run very quickly, but unfortunately this report cannot be written without using them as far as I can tell.

Any help on this would be greatly appreciated as I have no more ideas left to try.

Regards,

Wayne.

Sharing is not just for Xmas...

avoid asking about username and password in Runtime

Mon, 23 Nov 2009 09:47:54 Z

Hi,

How can i avoid asking about the username and password in the runtime ?
Is there any code that feed the Crustal report with the Username and password of the SQL Server 2000 instead of entering password everytime displaying the report

how i can hide minimize,maximize and close button in a vb .net windows form.

Fri, 27 Nov 2009 08:45:39 Z

Hi,

how i can hide minimize,maximize and close button in vb .net 2008 windows form.

thanks,

Detail section vertical line problem.

Wed, 18 Nov 2009 13:37:44 Z

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 "Total"(Report Footer).
It works fine if everything on the same page. The problem starts when the last line of the detail is on the first page and the "Total" wouldn't fit on the first page. It displays "Total" on the second page and it draws vertical lines to the end of the page.

Thanks for any suggestion.

Crystal Reports Data Source

Fri, 20 Nov 2009 13:01:24 Z

Is it possible to change the data source for an embedded report in VB.NET?. I have a situation where the same program on two sites uses two different SQL servers and it is a pain to use the report's Datasource Location every time I need to change sites, as there are over 20 reports to do. I would hope to set the datasource from within code.

Thanks

Redistributable MergeModule for .net 2005 with xml database drivers.

Wed, 10 Jan 2007 07:59:05 Z

Hi MicroSoft,

my requirement is: Redistributable MergeModule for .net 2005 with xml database drivers to deploying the crystal report on client.

i have a mergemodule which is updated on 29th nov 2006. But it do not have xml database driver.

how to deploy crystalreports application.

we developed one application using C#.Net with XML database.its install to client system thats doesn't work.it displays some error.

that is "FAILED TO LOAD DATABASE INFORMARTION"

error in file c:document\local\temp files and so on.

if you have find any solution for it. please help me..

Thanking you..

Suresh

Localize data from crystal reports

Tue, 24 Nov 2009 07:25:13 Z

Hi All,

I am working on globalization/localization part on my project. I found how can we use resource files provide local support for windows forms. Now I am searching solution for how can we provide localization support in crystal reports. Crystal report provide localization support for their standard menus and controls which are there on the crystal report viewer control. But I am confused about how to localize data that we are displaying at run time?

can somebody help me on this? I am stucked up because of this.

I can be still better.

trouble to ses a parameter manually with crystalReport and VB.NET 2005

Fri, 20 Nov 2009 22:43:36 Z

i am having a trouble with a tutorial that i found on msdn, its tut about how to set a parameter manually for a crystal report http://msdn.microsoft.com/en-us/library/ms227722.aspx.

my problem is that i would like to pass an integer parameter and just one parameter?

the code in the fellowing

Private Const PARAMETER_FIELD_NAME As String = "numb"

    Private impbonrecepReport As ReportDocument

    Private Sub ConfigureCrystalReports()


        Dim myArrayList As ArrayList = New ArrayList()

        myArrayList.Add(999)
     


        Dim numbrecep As Integer

        numbrecep = 999



        SetCurrentValuesForParameterField(impbonrecepReport, myArrayList)
        
        impbonrecepReport = New ReportDocument()
        Dim reportPath As String = Application.StartupPath & "\" & "ImpBonReception.rpt"

        impbonrecepReport.Load(reportPath)
        CrystalReportViewer1.ReportSource = impbonrecepReport

    End Sub


Private Sub SetCurrentValuesForParameterField(ByVal myReportDocument As ReportDocument, ByVal myArrayList As ArrayList)


        Dim currentParameterValues As ParameterValues = New ParameterValues()



        For Each submittedValue As Object In myArrayList

            Dim myParameterDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()
            myParameterDiscreteValue.Value = myArrayList.ToString()
            currentParameterValues.Add(myParameterDiscreteValue)

        Next


        Dim myParameterFieldDefinitions As ParameterFieldDefinitions = myReportDocument.DataDefinition.ParameterFields
        Dim myParameterFieldDefinition As ParameterFieldDefinition = myParameterFieldDefinitions(PARAMETER_FIELD_NAME)
        myParameterFieldDefinition.ApplyCurrentValues(currentParameterValues)


    End Sub

and i got this error message

An unhandled exception of type 'System.NullReferenceException' occurred in GestionStock.exe
Additional information: La référence d'objet n'est pas définie à une instance d'un objet.

can you help me to resolve this problem ?

How can I redefine dynamic parameters list of values when report datasource has been changed?

Thu, 26 Nov 2009 16:06:11 Z

Hi. I use multiple reports in a single C# project with Crystal Report 2008 in Visual Studio 2008 (CrystalDecisions.ReportSource v12.0.2000.0). In order to reduce developpement and to keep reports fully exportable under the Crystal Report "rpt" format, I try to simply change reports data source while keeping dynamic parameters. Changing the reports data source (either the "DataSourceConnections" or "Database.Tables" collections within the "ReportDocument" object model) seems to works fine but if I do so, i loose the parameters lists of values. Furthermore, I seem to have problems with the selection formula when defining manually the parameters values (using the "ParameterFields" collection in the "ReportDocument" object model).

What is the correct way to proceed in order to be able to redefine report data source while keeping the usual dynamic parameters defined in Crystal Report?

Help adding a picure to Crystal Report at run time

Wed, 04 Nov 2009 23:36:59 Z

I need to have a picture on my Crystal Report and have that picture selected at run time based on user input and calculations. I currently have my program determining the correct jpg file name, out of 114 jpg's that I have loaded into resources, and assigning that file name to a variable (gsSBdetail). I can display that correct image in a PictureBox on a windows form with the follwing code:

PictureBox1.Image = DirectCast (My.Resources.ResourceManager.GetObject(gsSBdetail),Image)

Now I need to have that image appear in a box that I have drawn on a Crystal Report named "Calc Sheet.rpt".
I currently have a CR Viewer named "CrystalreportViewer1" on a VB form named "OutputSheet.vb". What code can I write for the OutputSheet.vb form to get the picture into the Crystal Report?
Thank you,
Dan

Crystal Reports hangs under a Windows Service Thread

Mon, 26 Jan 2009 09:58:56 Z

Hi,

We are currently developing a reporting scheduler service that runs as a windows service. All running great and fine right up until we deploy the solution as a service. Basically, when the code gets to the report generation Crystal reports hangs the thread. When this application is run as a normal windows process, the reports get generated fine. Looking through the crystal code in reflector it would appear that as soon as the report steps in to the .Load method, it hangs (probably when it gets to the COM stuff). I have designated the entry point of the service app with the STAThread attribute and have ensured that the spawned thread that does the processing is also set to STA. I have tried running the service under admin credentials, local system with interact with desktop permissions with no success. Extensive googling seems to point to a COM issue and STA threads, but I have set all threads as STA where possible. The service itself starts an 'application thread' which then loads an assembly which creates a report in a seperate thread. As I mentioned earlier, If I compile the application as a windows app and then run it, it seems to work. It is only when it runs as a service, does it hang on the report .Load or .SetDataSource (which in turn loads the report). The report tmp file is being created but that seems to be as far as it gets. Is there something I have to do with the ServiceBase object to mark it as STA for example? Perhaps it is an issue running reports under the Service Control Manager thread?

The only workaround I can think of at the moment, would be stop spawn some kind of non service process to generate the report (which would run under an STA thread and therefore not hang!).

Any suggestions and help would be MUCH appreciated!

Many Thanks,

Matt.

Crystal report: resizing papersize

Fri, 01 Jul 2005 02:09:38 Z

Hello!

I am having a problem resizing the papersize of the report with my desired dimensions which is 13"x17" or any other dimensions for that matter.

Need your expertise guys ..

Thanks!!

generating report in Crystal Report

Thu, 26 Nov 2009 09:09:21 Z

I have to show 35 fields in Crystal Report how can i create that at design time

Please help

Load Report From Vb 2008

Sun, 22 Nov 2009 13:40:36 Z

Hi
I have designed a report with VB2008 by using Crystal report
how can i display the report in the run Time
and alse i have noticed that the basic option of crystal is not found as Alignment , colors adding datafield ...etc
where can i find these options?

Thank you in advance.

Need Help on graphs display in crystal reports

Tue, 06 Dec 2005 06:08:01 Z

Application is using crystal reports 8.5 version in ASP to display bar charts. It displays the bar charts fine in windows NT o.s.

The problem is when the application is moved from windows NT to XP machines, the bar charts are not displayed. Crystal reports is not installed in new machine and dlls registered are

crxf_pdf.dll

crxf_rtf.dll

Crxlat32.dll

u2dapp.dll

u2ddisk.dll

u2dmapi.dll

u2dnotes.dll

u2dpost.dll

u2dvim.dll

u2fcr.dll

u2fdif.dll

u2fhtml.dll

u2fodbc.dll

u2frdef.dll

u2frec.dll

u2frtf.dll

u2fsepv.dll

u2ftext.dll

u2fwks.dll

u2fwordw.dll

u2fxls.dll

u2fxml.dll

sscdlg.dll

sscrc.dll

sscsdk80.dll

Please reply.

Regards

Shilpa

PDF Export error

Wed, 25 Nov 2009 12:49:28 Z

Hi!

I have made several reports with Crystal reports. On one server they are working fine in excel and pdf format but on another server pdf export fails. The problem server seem to have the same fonts installed as the server the pdf export works on.

I get the following error:

CrystalDecisions.CrystalReports.Engine.InternalException:
Selected exporter does not support one of the features used in this report.
C:\WINDOWS\TEMP\StatisticsReport {4857FEFF-822C-41AA-A862-10BDF0C989A3}.rpt ---> System.Runtime.InteropServices.COMException (0x8000030E):
Selected exporter does not support one of the features used in this report.
C:\WINDOWS\TEMP\StatisticsReport {4857FEFF-822C-41AA-A862-10BDF0C989A3}.rpt
   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
   at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
   --- End of inner exception stack trace ---
   at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
   at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
   at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)

I have no clue where to start searching for the problem. The thing is I just create a c# .cs file to get data form a database and another programming (Banqsoft Review) is using the dataset my .cs file generates and the crystal .rpt file I have made.

Any suggestions for debugging is appreciated!

How can I apply CSS to the parameters input form in VS 2008 with the Crystal Reports Viewer?

Tue, 24 Nov 2009 15:29:20 Z

I have a VS 2008 web app and am displaying a report in a Crystal Reports Viewer control.

I have parameters defined that the user can enter to filter the report. The input form for the parameters is automatically generated before the report is displayed in the control but it looks pretty plain and I would to change some of the text (i.e. the title "Parameter Field(s)" and the "Parameters" text for comboboxes when multiple values are allowed.)

Is there any way to do this?

Thanks

System.Runtime.InteropServices.COMException (0x800003E5) in Crystal Report (CR 11 and VS2003)

Tue, 25 Jul 2006 10:35:14 Z

hi forum

i am getting the following Exception

System.Exception: Load report failed. ---> System.Runtime.InteropServices.COMException (0x800003E5): Failed to open report.
   at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)
   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)
   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   --- End of inner exception stack trace ---
   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportClass.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.s()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_DataDefinition ()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetParameterValue(String name, Object val)
   at NetCRM.UI.REPORT.TempCustomerLeadRequest.btnShow_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Request.aspx.cs:line 181

why did this came and tell me the solution this exception.

my id is

rastogi.mahesh@hotmail.com

not showing multiline fields in crystal reports.

Thu, 19 Nov 2009 11:54:54 Z

Hi,

I have a address field in my emp_detail table. this field varchar2(100). i am inserting data to this field using multiline textbox in vb .net.
it is saving ok. but when i make reports through crystal report the data which is in first row only showing. any data after enter key not showing.
if i put space instead of enter key it will show.

thanks,

Cant get Crystal report to show data from my projects dataset in .net

Thu, 19 Nov 2009 12:06:29 Z

For some reasons I'm getting no data populating in my crystal report. I have set the datasourse of my crystal report to the dataset. I filled my dataset with data straight from the database. My dataset is not empty, I always check it first before populating data to the my report. I built my crystal report off the wzard and I did add crystal report viewer. Please help.

Deploy Crystal Report dlls only using ClickOnce without using prerequisite .msi

Sun, 08 Nov 2009 06:11:22 Z

Hi, I believe the conventional way to deploy Crystal Report with a .NET program is to set it as a prerequisite in the publish settings and then a .msi will be packaged with the ClickOnce files on the web/network/CD/wtv. When the user runs setup.exe, it will check whether Crystal Report is on the client computer. If not, it runs the Crystal Report .msi. But that will always require admin rights. My question is, is it possible to package Crystal Report's dlls along with other application's output assemblies so that no explicit install is required? My application makes use of many many components and including a dll with the install is sufficient for most of them. Could I do the same with Crystal Report?

ClickOnce Deployment when not administrator

Tue, 08 Nov 2005 20:08:51 Z

I have a WinForms application that I'm deploying using ClickOnce deployment. None of my users are administrators on their boxes. If I add a CrystalReportViewer to my app and publish it, will it be able to install the necessary CR pieces?

Crystal report - Export to excel

Mon, 23 Nov 2009 02:24:18 Z

Hello all,

I have some problem with my report. In my report have many group, and I want export to excel group by group (1 group to 1 file .xls, or all group in 1 file .xls, but 1 group to 1 worksheet). Can You give me solution, or code (C#)?
Thanks for attention.

Crystal Reports dropped in Visual Studio 2010???

Wed, 29 Oct 2008 11:32:46 Z

I've been playing with the Visual Studio 2010 CTP virtual machine, and just noticed something slightly worrying - Crystal reports seems to be missing!

Has support been dropped, or will it be an optional feature or something?

Thanks,
Dan

Slow crystal report on its first appearance

Sun, 22 Nov 2009 05:49:12 Z

Hi to all,
I made a crystal report from sql query for its datasource but on its first appearance it will take 8-10. however if a repeat to click the button it will take only 1 second. I use a Command for the database fields with OLE db sql server express 2005 database, i am using vb2008 here is my code.

Private Sub CmdPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdPrint.Click
dim txtClimit As TextObject
Dim objRpt As New RepVerify
objRpt.SetDataSource(ds.Tables("CustomerFile"))
txtClimit = CType(objRpt.ReportDefinition.ReportObjects("Text7"), TextObject)
txtClimit.Text = Trim(Me.txtClimit.Text)
With FrmReport
.CrystalReportViewer1.ReportSource = objRpt
.CrystalReportViewer1.Refresh()
.ShowDialog()
End With
End Sub

above my code is a ds(dataset) which open in the txtMcNum_Keydown

Private Sub txtMcNum_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtMcNum.KeyDown

If e.KeyCode = 13 Then

Ds =

New DataSet

Dim StrCust As String = "Select Cf.IDNo, Cf.MCNum, Cf.CoID, Cf.DateApproved, " _

" Cf.Name, Cf.Address, Cf.PhoneNum, Cf.CLimit, Cf.CCode, " _

" Cf.TCode, Cf.CType, Cf.Flag, Cf.Picture, Cf.Active, " _

" Cf.TagByMSS, Cf.TagByBADS, Cf.Printed, Cf.AmountDue, Cf.Paid, comf.Cname " _

" from CustomerFile as Cf Left join CompanyFile As comf ON cf.CCode = comf.CCode where McNum = '" & Trim(txtMcNum.Text) & "';" _

" Select MCNum,[PO Number], AmtForPayment, Amount, DatePurchased from TransHistBADS where McNum = '" & Trim(txtMcNum.Text) & "'Order by DatePurchased desc ; " _

" Select MCNum, [PO Number], AmtForPayment, Amount, DatePurchased from TransactionHist where McNum = '" & Trim(txtMcNum.Text) & "'; " _

" Select MCNum, Department, DatePurchased, Amount, [PO Number], ORNumber from [TransactionFile-MSS] where McNum = '" & Trim(txtMcNum.Text) & "'"

Da =

New SqlDataAdapter(StrCust, connection_AP)

Da.Fill(Ds)

Ds.Tables(0).TableName =

"CustomerFile"

Ds.Tables(1).TableName =

"TransHistBADS"

Ds.Tables(2).TableName =

"TransactionHist"

Ds.Tables(3).TableName =

"TransactionFile-MSS"

and here is my connection string for the database

Imports

System.Data.SqlClient

Module

ModDB

Public connection_AP As New SqlConnection()

Public Sub OpenSql_AP()

Dim APConStr As String = "Data Source=192.168.10.199\SQLEXPRESS; " _

" Initial Catalog=AR; " _

" User ID=sa; " _

" Password=ar_quebec; " _

" Trusted_Connection=true; " _

" MultipleActiveResultSets=True; " _

" Integrated Security=SSPI;"

connection_AP.ConnectionString = APConStr

Try

connection_AP.Open()

Catch ex As Exception

MsgBox(ex.Message)

End

End Try

End Sub

End

Module

hope for your help guys thank you and hope i made my explanation clear...

crystel reports not showing any data

Wed, 07 Oct 2009 04:04:17 Z

When I use crystel reports viewer in visual studio 2008; the viewer does not show my data. It brings up my colunm headers, such as employee Id, but does not show the data that goes along with it. can anybody tell me why? the data conection is made using the crystel reports wizard.

visual studio.net novice programmer

to pass textbox value to crystal report

Fri, 18 Sep 2009 08:06:12 Z

hi!

i have a form called "dailyreport" .

In this form i have a textbox and a button.

Textbox will get a date value from user and then user have to click the button to view crystal report.

My crystal report shows patient's name and id who visited the clinic on that particular date ( textbox value).

now i have the requiremtent in which i have to show this date(ie, textbox value) on the crystal report..

So, how can i pass this textbox.text value to my crystal report???

pls provide some solution!!

nandini

Error when running windows form with Crystal report viewer

Fri, 20 Nov 2009 18:31:30 Z

I have created a windows form that has a crystalreport viewer control. I then used the click once to deploy the application and in the prerequistes I selected .NET Framework 2.0 and Crystal Reports 2008. When I ran the link that was created by VS2005 it installs the application without any problems, but when I try to run the application I get the following error.
Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, version=2.0.0.0, Culture=neutral, PublickKeyTokan=6=b77a5ac561934e089' failed.

Could any one help me inresolving this error. Any help is greatly appreciated.

donsls

Different Stored Proc but Parameter name is Same.

Thu, 08 Oct 2009 21:39:43 Z

Hello Friends

I have a problem in Crystal Reports.
I am developing a report which contents 4 different Stored Proc and 1 table.
I used 5 different connections for that.
In all 4 SP I have 4 common parameter fields with same name like, @BlockID, @LanguageID, @Param, @LabelID.
And all SPs are having different values for each parameter.
So, when I run the report, it asks for only once for all 4 SP. And, so that, my report doesn't provide accurate result.

So, Please help me to solve this problem.

Thanks in advance.

Thank You

Best Regards
Utkarsh Gajjar.

Utkarsh Gajjar

use main report's summary fields into Sub reports

Fri, 20 Nov 2009 15:41:42 Z

Hello friends,

I have a problem.
I have a report, which contents 2 sub reports.
In main report, there is a group and group is having 4 summary fields.
Now, I don't know, how can I use that 4 summary fields into sub reports.
Can anyone please help me to solve this problem.!

Thanks in advance.!

Thank you.

Best Regards
Utkarsh Gajjar

Utkarsh Gajjar

Print function does not work in x64 runtime

Mon, 13 Feb 2006 13:42:16 Z

Print button in crystal reports viewer does not work in x64 runtime, when I click on the print, no response and no error, nothing happen. Is this a bug? Does anyone else have the same problem?

Custom Paper Size added in Server Properties didnot appear at Crystal Report Paper size choices

Sat, 14 Nov 2009 05:45:50 Z

Hello everybody.. I'm stack with this case

I add a new form in Control Panel - Printer and Faxes - Server Properties. Define a new custom size and new Form Name, and didnt forget to Save Form.

I ascertain the default printer which i set is not different with the selected printer in Crystal Report - Design - Printer Setup - Printer Name.

The No Printer Checkbox is also unchecked.

But the Custom Form Name which i have made doesn't appear.

Please help.

Thanx in advance.

upgrade from vb2003 to vb2008

Wed, 11 Nov 2009 19:49:26 Z

We have a large application in vb2003. Now we are converting it to to 2008. We got lots errors and warnings all in the crystal report files,such as:

Warning 2 'CrystalReport_Sales' is not CLS-compliant because it derives from 'ReportClass', which is not CLS-compliant.

Error 11 'Protected Sub New(info As System.Runtime.Serialization.SerializationInfo, context As System.Runtime.Serialization.StreamingContext)' has multiple definitions with identical signatures.

Could you give me some idea what I shoud do?

Thanks,

Crystal report shows just the first data row from a dataset

Wed, 11 Nov 2009 14:16:27 Z

Hello,

I have a dataset with a table and in the crystal report I have put it a Box Object (I would like to simulate a table), and inside the fields from the table.
The problem is that in the crystal report shows just the first data row from the table.
I have written the data from the dataset:

ds.WriteXml("myfiletest.xml");

The file (myfiletest.xml) has three rows with data and in the crystal report is just written one row (the first one). I have put the fields from the table in the Section 3 (Details) from Crystal Report.

I have other fields. They are parameter fields and they are shown without any problem.

Do you know where the problem could be? Is it possible to mix the data from dataset with the parameter fields?

Thank you!

Regards!

Does CrystalReportViewer Control come with Visual Studio 2008 Standard Edition?

Fri, 13 Nov 2009 17:53:47 Z

I have installed the Visual Studio 2008 Standard Edition, but I do not see the CrystalReportViewer control in the toolbox, nor is it available to add into the toolbox.

shared variable

Wed, 18 Nov 2009 22:50:42 Z

I have report with one subreport that uses a shared variable. The main report is grouped by market then by location. The subreport is grouped by market only. I created a shared variable in the subreport to sum revenue. I then created a shared variable in the main report to access the shared variable from the subreport. When I place the shared variable in the main report and view the records it displays the shared variable as zero for the first record. It should display 16. when viewng the second record the sahred variable displays 16, the correct number for the first record. So in a sense, it seems as if the shared variable is one record behind when I veiw records on the main report. Any suggestions?

How to change text color runtime dinamically

Wed, 18 Nov 2009 20:51:37 Z

Dear My friends,

I am working with crystal reports in vb.net 2009.

I want to change some of text colors runtime. For example I want to set some text color to red when the text value is "<0". I do not want to use formula.

I want to change the text color dynamically runtime.

I would be very thankful if you could help me.

hasanvaez@gmail.com

Best regards,

Hasan

create a .txt file from crystal reports

Wed, 18 Nov 2009 20:14:36 Z

Hi all,

Somebody know if is possible create a .txt file using basic syntax on the crystal reports?
In the execution time I will store a value on a variable an after I write a .txt file on a local hard disk.