(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: [1] 2  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Keyword Report (Read 2626 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Keyword Report
Oct 20th, 2006 at 3:56am
Print Post Print Post  
Hi -

I am having a problem with a keyword report and am unable to find any help in the users manual.

I have a keyword element called When taken.  It contains a value of 1 through 5 and may contain any combination of values such as 1  1;2     1;2;3   1;3   etc.   Another element (let's say fruit) contains a value such as apple, peach, pear, etc.

if the keyword field contains 1; 3 I want to see

1     Apple

3     Apple

I have a break on the keyword field in the group header; however what I get is a "group" of

1;3
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #1 - Oct 20th, 2006 at 4:25am
Print Post Print Post  
This need has come up a number of times in the past. 

Here are some previous answers to this question:
Quote:
Yes there is. It takes a little bit of programming to do but it is done in less than 100 lines of code. and can be done several ways. Send an e-mail to Support@lantica.com and ask me for it and I'll be glad to send it to you.
and Quote:
Send me an e-mail at Support@lantica.com and ask me for the Keyword report sample. It currently has two different ways to build a keyword report. One of the ways uses a standard Sesame Report, which is the way I showed Foster how to do it. The other way builds the entire webpage at the click of a button using X-Commands. 

Both ways are under 100 lines of code and I just built them both this afternoon. No need to export to an external program. 

-Ray

I don't recall seeing a "keyword report" solution anywhere except to request this from Lantica.  How about providing the code in the Sesame Library for "How To"?  In the meantime, I would appreciate a mailing of the code sample so that I can work with it.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Keyword Report
Reply #2 - Oct 20th, 2006 at 1:36pm
Print Post Print Post  
Hello Bob and Spencer,

You both have an e-mail with the Sample File attached. If you have any questions about how it works just let me know.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #3 - Oct 20th, 2006 at 1:56pm
Print Post Print Post  
Thanks for the email Ray.

I will look into that over the weekend. 

I know Spencer needs it now, I just need it to put into my toolbox fur the future.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Keyword Report
Reply #4 - Oct 20th, 2006 at 2:38pm
Print Post Print Post  
I'd like it too, please.  Thanks Ray.
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Keyword Report
Reply #5 - Oct 20th, 2006 at 2:46pm
Print Post Print Post  
Infinity wrote on Oct 20th, 2006 at 2:38pm:
I'd like it too, please.  Thanks Ray.


Ray,

May I please have a copy also?  Smiley

Maybe you should post the code under samples or turn it into an Inside Sesame article because you might get lots of requests.

Thanks
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Keyword Report
Reply #6 - Oct 20th, 2006 at 2:57pm
Print Post Print Post  
Hello Infinity and BOBSCOTT,

You both have an e-mail with the files attached.

I will try to get the application into the sample applications section of the forum but until then, if anyone else wants it all you have to do is ask.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #7 - Oct 20th, 2006 at 5:00pm
Print Post Print Post  
I did get a chance to start looking at the sample you sent.

I understand that it is only a demo to show the technique.
I have modified the "button" report to include count of records in each KeyWord group, and an overall total of KeyWord individual records.

But I did notice that this is not using the CurrentRecordSet, it is retreiving all records with key fields in the entire database.  Can you show a modification to get the data from the current record set vs. the entire database?

Thanks, looks good.  Will be modifying to make more generic.  Hope 2.0 or 1.1.5 will have a "normal" Keyword Report that will not require this extra programming.
« Last Edit: Oct 20th, 2006 at 6:46pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Keyword Report
Reply #8 - Oct 20th, 2006 at 5:11pm
Print Post Print Post  
Hello Bob,

There are two techniques shown in that app. The second one is a report that will display the current result set.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #9 - Oct 20th, 2006 at 5:59pm
Print Post Print Post  
I understand that Ray, but I am greedy.  I think I prefer the "button" report because it is more generic for Cut/Paste.  So I would like to have that one work on the CurrentRecordSet.

This makes me think that perhaps we need a built-in Sesame function to use with XL functions:  Instead of using Filename for the first parameter, we could use @CurrentRecordSet as a source.  That would have many benefits, especially for those times when you need to filter record sets by additional retrieves on the current set.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Keyword Report
Reply #10 - Oct 20th, 2006 at 10:48pm
Print Post Print Post  
Ray -

Thanks very much for the keyword report database.  It was a big help and got me the beginning of my report.

I have a few concerns however and would appreciate your help.

1)  I notice the hobbies repeat on each line (e.g. dancing is repeated many times).  I need a clear delineation between the groups so I want the keyword to appear only once and not repeat itself.

2)  I need additional columns.  Using the database as an example, I want additional columns to show for Street Address, City, State, Zip, Phone Number, etc.  Can you help me with this or at least point me in the right direction.

3)  As I'm sure has been pointed out several times, the keyword report in Q&A was very straightforward and required no programming.  Also, judging from the additional requests for the Keyword Report database, it appears that there is some interest in it, besides my own and Bob's.  Is it possible we could get a "fix" in the current edition or do we have to wait for version 2.0 to be released.

ANY guess at all on when we might hope to be offered version 2.0

Once again, thanks much for your help.  It is very much appreciated.
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #11 - Oct 21st, 2006 at 12:02am
Print Post Print Post  
If you are using rhe "Keyword Report" vs. the "Button Report":
Add the extra elements )Address, State) to the Group Header.  Make them all invisible.

Go to the programming for the Hobbies (JeyWord) element and add additional elements as needed:
vHobby = @AccessStringArray(vKeys, vKeyLoop)
     Edited:
If vHobby <> "" Then
     {
           // *** USER DEFINED *** Next line includes fields to be printed on the report.      
           vVal = vHobby + "|" + First + "|" + Last + "|" +  Address + "|" + State
           vKeysFinal = @AppendStringArray(vKeysFinal , vVal)
     }
     vKeyLoop = vKeyLoop + 1


Also go to programming for Out and add additional lines for additional cells.  Here is a section as an example adding Address and State to support change made above:

Edited:
vOut = "<TABLE>"
vOut = vOut + "<TR>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Keyword</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Name</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>Address</B>"
vOut = vOut + "</TD>"
vOut = vOut + "<TD>"
vOut = vOut + "<B>State</B>"
vOut = vOut + "</TD>"
Out = vOut + "</TR>"


Also add additional lines in the next section of the "Out" program .....

====================
a.  Have you tried using the "button" report?  Key element only prints one time.
b.  Remember to make report changes in DSR but then reconcile them to the DB and run the reports in the DB.  Reports are using XL statements and will not work in Preview mode.

Edit:  The KeyWord Report has no XL functions, so it can be tested in Preview Mode.
« Last Edit: Oct 22nd, 2006 at 8:31pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #12 - Oct 21st, 2006 at 7:48pm
Print Post Print Post  
I am pleased to report that I was able to get Keyword Report to stop repeating the KeyValue, and was also able to get a record count at the end of each keyword group, and an overall record total count. 

So I can now use that for running reports on the current record set vs. the "Button Keyword Report that runs on every record in the database.

Also found that the KeyWord Report does not use any XL functions, so it can be tested in Preview Mode, while the "Button Keyword Report" cannot do that.  Have to test that report in the normal Database Mode.
« Last Edit: Oct 23rd, 2006 at 6:24am by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Keyword Report
Reply #13 - Oct 21st, 2006 at 7:57pm
Print Post Print Post  
In an earlier message, I mentioned that additional code sections needed to be modified.  Here is that info:

In the Out-OnPrint section, indide the WHILE loop, you need to add the following block for each of the columns you want in the report.  So to support adding Address and State above, the following section should be added two times:

Edited:
vOut = vOut + "<TD>"
vOut = vOut + Split(vData,"|")
vOut = vOut + "</TD>"
« Last Edit: Oct 22nd, 2006 at 7:24pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Keyword Report
Reply #14 - Oct 22nd, 2006 at 5:17am
Print Post Print Post  
Hi -

Well, once again Bob Hansen came through like a champ!!!   He worked with the keyword report until he got exactly what I needed.

The report contains several columns all with separate headerss and the "keyword" does not repeat so that a neat, clear "label" appears in the report.

If you would like a copy of the database, to utilize his coding to create a professional, easy-to-read report, I will be happy to send it to you.  Just let me know.
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: [1] 2 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge