Showing parameters pass to data environment in data report header 
Author Message
 Showing parameters pass to data environment in data report header

I pass a range of date to my report using the following code.

   With DeConceptoNAS
     If .rsSQLlisteParticipant.State <> 0 Then .rsSQLlisteParticipant.Close
     .SQLlisteParticipant CDate(DTPickerDebut.Value), CDate(DTPickerFin.Value)
   End With
   RptConceptoNAS.Refresh
   If Not RptConceptoNAS.Visible Then RptConceptoNAS.Show

The data show is correctly.

But now I want to show the date range in my report title (ReportHeader).

How can this be done ?

Thanks in advance for your help

Christian Paquet
Analyst Programmer



Mon, 24 May 2004 03:05:18 GMT  
 Showing parameters pass to data environment in data report header
The calling program must set the values on the report. You can do it like
this:

Create two labels in the ReportHeader section of your report to contain the
dates:
    lblDateDebut and lblDateFin

In the vb program:
Dim lblRptDateDebut as RptLabel
Dim lblRptDateFin as RptLabel

With RptConceptoNAS
    Set lblRptDateDebut = .Section("ReportHeader").Controls("lblDateDebut")
    Set lblRptDateFin = .Section("ReportHeader").Controls("lblDateFin")

    lblRptDateDebut.Caption = DTPickerDebut.Value
    lblRptDateFin.Caption = DTPickerFin.Value

    .Refresh
    If Not .Visible Then .Show
End With


Quote:
> I pass a range of date to my report using the following code.

>    With DeConceptoNAS
>      If .rsSQLlisteParticipant.State <> 0 Then

.rsSQLlisteParticipant.Close
Quote:
>      .SQLlisteParticipant CDate(DTPickerDebut.Value),

CDate(DTPickerFin.Value)
Quote:
>    End With
>    RptConceptoNAS.Refresh
>    If Not RptConceptoNAS.Visible Then RptConceptoNAS.Show

> The data show is correctly.

> But now I want to show the date range in my report title (ReportHeader).

> How can this be done ?

> Thanks in advance for your help

> Christian Paquet
> Analyst Programmer



Mon, 07 Jun 2004 08:12:33 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Showing parameters pass to data environment in data report header

2. Showing parameters pass to data environment in data report header

3. parameters for data environments/data reports

4. Report showing sample data not the passed data!

5. Data Environment and passing parameters to child commands

6. 2nd Request - Passing parameters to ADO Data Environment command

7. Problem with parameter passing with data environment

8. Passing parameters into stored procedure using Data Environment

9. Data Environment and passing parameter

10. How to show Data List with data environment

11. Editing data in a parameter query in Data Environment

12. Editing Data in a Parameter query built in the Data Environment

 

 
Powered by phpBB® Forum Software