Trouble with Header in report (ViP Specific)
At 13 JUL 1998 10:47:21PM Kerry Kilpatrick wrote:
I am a newbie to this so please excuse what may be a stupid/simple question.
I have created a small app to connect to a Lotus Notes data source. I have a text box to input search criteria. That all works fine, the search happens and I get the result set I want.
I have designed a report that I am basically happy with; the only thing I want to add to it, in the header area, would be the search string the user entered.
I have played around with it and cannot seem to find a way to get this to appear.
Any assistance would be greatly appreciated. The more detailed explanation the better.
Thanks, Kerry
At 16 JUL 1998 03:54PM Stephen Bellefontaine Revelation wrote:
Hello Kerry,
This is possible! I created a test app that included …
1. connected data object
2. textbox (for search criteria)
3. commandbutton (for previewreport)
4. connected report object
Steps
1. In the enter event of the textbox place the following code …
Data1.ColumnSetLabel 1, Text1.Text '(may need to be tweaked to fit your app)
2. In the report object create a Header (report/page/or group)
3. Go to the report toolbox and add a field, select formula, then select the field that you are filtering.
4. Run the app, type selection criteria into the textbox then press enter. Then press the print button.
The header should have the text you just typed in.
If you cannot get this to work, please post your email address so I can send you my test app.
Hope this helps,
ViP/DX Tech Support