Recent Posts
Superboyac - you live up to your screen name. I wish I could wade into the guts of programme as you have on this and other occasions and really wring them out. I install programmes and dabble - you OWN them. AwesomeThanks for the words, Darwin! Well, I don't do this with all programs, but I think SQLNotes is going to be really important in the future. My thing is that I don't like to waste my life with needlessly repetitive tasks or things that take longer than they should. So, computers are perfect for that. They allow me to concentrate my time on things that really matter by doing all the dirty work for me. SQLNotes is a great example of this. I can have so much of my life's important information available with a click in this program. That's going to be very useful.-Darwin (January 17, 2008, 12:42 AM)
Then, when I rename a grid, how do I know which checkbox is associated with that grid in cases where I want to include that grid's data into another grid?OK, thanks. By the way, if I rename the grid, does the field name (the field with the check box) for it get automatically updated also?No. There is no connection between field name and grid name (this is by design)-superboyac (January 16, 2008, 04:20 PM)-PPLandry (January 16, 2008, 04:22 PM)
I'll check it, did you try a repair ?Yes, but it didn't fix it.-PPLandry (January 16, 2008, 11:58 AM)
1- Export to Excel works fine here. Writes to the same folder as the database, name=gridname.xls. We can examine why it doesn't work for you.OK, the excel is working fine now.
2- To print with the HTML pane info, best is to do a template based HTML export. See this link:
http://sqlnotes.wikispaces.com/Invoices-PPLandry (January 15, 2008, 04:37 PM)
[edit] After thinking about it, I could use the current item list as a datasource. I'll see how this could work [/edit]Ah! I see. OK, if I am interpreting that correctly, you are working on how to do that and you will tell me later. Great, I'll wait for it. Thanks.-PPLandry (January 14, 2008, 12:55 PM)
>Wouldn't it be better if i could take the columns from the existing transcript grid (including the parent items which do not have grades) and be able to use them in a pivot table?I don't see why it's a problem. Let's take my transcript grid again. Why can't the pivot table just read all of the Items regardless of their position in the hierarchy (without having to adjust the display of the grid using the menu-->grid options)? Furthermore, for the items that have no grades associated with it (year, semester) all you have to do is uncheck the "blank" box in the screenshot I showed above. I guess I'm not understanding why it can't work this way.
Yes columns are no problem, the issue here is which items to take?
---------------
Unfortunately, this is rather complicated. The pivot needs a data source.
One possibility, would be to create a pivot based on the selected items, however it would be complicated when users add items.
Another possibility would be to allow users to set the data source of the pivot (currently it is set automatically). I think that pivot table/chart views will help as far as this issue is concerned.
[edit] After thinking about it, I could use the current item list as a datasource. I'll see how this could work [/edit]-PPLandry (January 14, 2008, 12:55 PM)
OK, this works. But if you don't mind, let me argue this from an efficiency standpoint. I would rather not have to create a new grid just for a pivot table if I don't have to. Wouldn't it be better if i could take the columns from the existing transcript grid (including the parent items which do not have grades) and be able to use them in a pivot table? Because in MS pivot tables, you can turn certain items on/off, so if some data doesn't apply, you don't have to have it show in the table.Does it have to flat for the pivots to read the information?No it doesn't need to be flat. Some explanation is required here. Items exist independant of the Hierarchy. I like to say that items are like individuals. The fact that you have parents or children does not change the fact that you are a person. The same in SQLNotes. To determine what the pivot table of a specific grid can see in terms of items, set hierarchy, context parents and save item states to Off. Those items are the only ones which "belong" to the grid. The rest were added to help you manage your information.-superboyac (January 14, 2008, 10:47 AM)
Pivot table/chart views will be possible later on. Right now, you need to open the grid first. So setting a new grid source to CourseGrade will do 2 things for you:
1- get you the grade
2- isolate the actual courses from the summary parents (semester, year, etc)
I hope this helps.-PPLandry (January 14, 2008, 11:42 AM)
Simply create a grid called CourseGrade (or something else and set the source to CourseGrade) and use that grid for your pivot table/chart (charts will look pretty neat for this transcript stuff)So, am I to understand that the pivot tables will not work when the list is structured as a hierarchy? Does it have to flat for the pivots to read the information?
There are other ways (i.e. modify the source of your original grid) but this way will work.
Pivots are automatically saved. To see simultaneously, right-click on the tab and select new Hoz/Ver tab groupawesome! OK, what if I close that pivot table. How can I reopen it?-PPLandry (January 11, 2008, 03:24 PM)
You are quite right that the user-code needs work:That would be really cool.
1- Divide the code between:2- Better code editor with syntax highlighting
- a) system code (part of SQLNotes, updated)
- b) user-code
- c) database-specific code
This will be done before release 1.0. Idealy I'd like to do it as MS apps with a VBA editor, but it is likely an overkill and MS stopped licencing it (Thanks Bill)
There are plans to include the LUA language into SQLNotes which would allow more powerful code (VBScript is an out-of-process calculation engine and does not have access to the SQLNotes data, the LUA engine would be fully integrated) Version 2.0 perhaps.-PPLandry (January 11, 2008, 12:39 PM)
