How do I access an unbound field in my report from vb 
Author Message
 How do I access an unbound field in my report from vb

This is my first time using CR 6.0.  I have a report that is made up of
unbound fields.  Can I set these fields with code from inside vb.



Mon, 30 Oct 2000 03:00:00 GMT  
 How do I access an unbound field in my report from vb

Yes, for example -

In your Crystal Report, create a formula called Name, this formula need only
contain a pair of double quotes.

In your VB code with a Crystal custom control present, pointing to the
report you just made do this -

CyrstalReport1.Formulas(0) = "Name=" & Chr(34) & "This text will appear on
the report" & Chr(34)

To set more than one formula, use Formulas(1), Formulas(2) etc.


Quote:
>This is my first time using CR 6.0.  I have a report that is made up of
>unbound fields.  Can I set these fields with code from inside vb.



Mon, 30 Oct 2000 03:00:00 GMT  
 How do I access an unbound field in my report from vb

Hi
I have an unlinked subreport  in my Main report's footer, which needs to be
printed after my Main Report's data.  The reason for not linking them, is
because the have nothing obvious in common, be are related somehow through
the ShippingLine.

In my VB code with a Crystal custom control present, pointing to the main
report, I specify the selectionformula:

CrystalReport1.SelectionFormula = {Orders.ShippingLine} = "ABC"

            (with "ABC" selected by the user from a Combobox)

My problem is that I also want to filter my subreport with a certain
Selectionformula through VB.
What is the VB Code do to this?

Another problem I have is that if my main report is BLANK (no orders for
ShippingLine "ABC"), then suddenly my subreport is also blank, even though
there should be data.

Can somebody please assist a desperate beginner!!

Kind Regards
    Maryka Swartz
    Programmer
    South Africa




Sat, 04 Nov 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. How do I access an unbound field in my report from vb

2. SUBSCRIPT OUT OF RANGE Error When Running crystal report with unbound field objects in VB6

3. Update a Bound field with data from unbound field

4. Cannot access fields using recordset property when doing a self-join

5. VB to Execute Access Report - Access report displayed on Web

6. use a field inside sub report as group field of primary report

7. How to modify the field length from an access-field in Ms-VB

8. how to change field size and delete field MS ACCESS/VB

9. Importing a MS Access form to a VB Project can it be done

10. Combining values from a group of checkboxes into an unbound combobox field

11. Collecting unbound fields on a form

12. Acc97 and unbound fields in a form

 

 
Powered by phpBB® Forum Software