Search options (Page 70 of 104)

Hi Raheel,
Try it like this (see attached).  Edit1 and Edit2 are passed through to the report as component variables rather than data.
Derek.

Ciao Reteinformatica,
The reason why you have to click two times is because you have defined two different buttons to 'show record' (see attached screen shot).
Change the 'stampa' button from 'show record' to 'report' and this should fix the problem.
Regards,
Derek.

Hi Manixs,
Does the attached example help you?
You also need to set the form's position to 'podesigned' (see screenshot1 in the attachment).
Regards,
Derek.

Привет pt82,,
Возможно, так?
Derek.

Hi,
There are a few things you need to follow.
1.
A script is a set of instructions to be executed when a certain 'event' occurs to an object.  In your example, the 'event' is 'onclick' and the object is form1.tablegrid2.  But in your example, there is no link between the object/event and the script (see screenshot1).  To generate this link, double-click against the 'event' you want, the link will get created (see screenshot2) and the script editor opens.
Without this link, no code will get executed.
2.
When you're developing, if you use hidden fields, it's best to leave them visible until you've finished testing and are happy they are working properly.  I've made Edit1, Edit2 and Edit3 visible so you can check them - just make them invisible when you're finished.  In your example, click tablegrid2 and you'll see Edit1 and Edit2 get filled with the relevant dates, click tablegrid3 and you'll see Edit3 get filled with the relevant venue.
3.
You cannot use tablegrid2 and tablegrid3 as search criteria in the report because there is no relationship with 'addressbook' - that's the whole point of having to use Edit1, Edit2 and Edit3 as local variables.  Replace tablegrid2 and tablegrid3 in the report search criteria with Edit1, Edit2 and Edit3.
4.
With Edit1, Edit2 and Edit3 populated, click the 'Print Invitation' button and open the report in designer mode;  you should see Edit1, Edit2 and Edit3 are available (in the 'Variables' tab);  they can now be place on the report layout as required.
Derek.

Hi,
Because there are no joins between the address book table and the venue and party tables, the venue and party details need to be put into local variables (edit1 - edit4) and added as search components in MVD (screenshot1).
When you go into FastReport, these additional variables (edit1-edit4) are located in the 'variables tab' (next to the 'data tab' on the right side of the screen) - see screenshot2.
Now you can just drag them onto the report like any other fields.
Derek.

Hi,
Your 'invitations' report requires information from the 'addressbook', 'venue' and 'party' tables. 
But because there is no relationship between the 'addressbook' table and the 'party' and 'venue' tables, the information from the 'venue' and 'party' tables isn't automatically built into the report data-set.
So you need to pass this additional information (venue, party start and end dates and party text) through to the report as variables instead.
This is what the script in the attachment is doing (I've stripped out everything that isn't needed so you can see more clearly what is going on).
On a different point, if you need to upload your project, you can delete the executable file (it's not needed) before zipping it to reduce the size of the zip file.
Derek.

Hi,
It's a fair comment about some of the 'standard' things like button styles, forms etc.
But there is also a lot you can do by using icons or images instead of standard buttons, a bit of imagination  and a few lines of script.
Have a look at the attachment for some light-hearted examples.
Regards,
Derek.

Hi,
So if I understand your message correctly, you are,  in effect, wanting to use the status of 'active' or 'inactive' to determine who gets an invitation, rather than adding guests to a 'guests list table'.  There's no problem doing it that way (see attached) but you lose the functionality of being able to see who was invited to previous parties (because their status may have changed, or people may have been added  / deleted in the address book in the meantime).
Derek.

Hi,
In the dbimage1 properties, the tablename was blank.  Also, you need to specify 'linkfile' as the 'type' (please see attached screenshot).
I wasn't sure from your post if you also wanted the images to display on 'frmstudent'.  If so, there are 2 basic ways of doing this (both of which require a script.
In the first way, the image is displayed when a row in frmstudent.gridcheck is highlighted.
In the second way, all images are displayed against the relevant row in frmstudent.gridcheck.  Whilst this is nice to have, you either have to increase the row height in the tablegrid quite a lot and so only get a few rows per screen, or if the row height is reduced, you can't really tell who's image it is anyway!  Also, retrieving images for each row in the tablegrid can increase load times which may be a problem if you have a large number of students in your database.
But ultimately, the choice is down to your specific needs.
Hope this helps,
Derek.

Hi There,
Not sure what you mean by 'live search' but the combobox on Form6 is already searchable so it gives you both options (pick from the drop down list or just type any part of the firstname or lastname).
Derek.