Recent content by glenninflorida

I'm currently working in an CR 8.5 Environment and have various data sources including a few different SQL Svr 2000 dbs. I have a possible future opportunity that has a requirement of understanding using temp tables for CR data access. I have read articles (spent a good few hours googling and...

I have searched and searched. I have found plenty of great tutorials on using the .NET Datagrid features of Dreamweaver 8 to view, edit, and delete records. However, none address the topic of inserting a record. A great article on 4guysfromrolla addresses this (inserting records using a...

I am helping to set up a small business network. On the WAN side we'll have a single DSL connection and be supplied a DSL modem (I don't know what model yet - whatever AT&T supplies). On the LAN side a very basic LAN - 4 PCs (no server) and 3 networked printers (wired - no wireless). I have...

Thanks synapsevampire, It's worth it to me (business requirements). I'll run with a variation of that and see how it goes. -Glenn "Go Gators!

Hi, I'm not sure how a new page after will dynamically fill in the proper white space (size the group footer) after the details? Thanks

As IdoMillet mentioned: When using aggregate functions such as COUNT, SUM, ..., I have had to create a global variable to capture the running total like this: //in your distinctcount formula shared numberVar RunningTotal; numberVar MyResult; MyResult := (DistinctCount(table.field))...

In 8.5, is there a way to create a "fill the remainder of the page" section? For instance, last record for group is 1/3 way down the page, start a group footer that would print spaced lines (ruler paper) for the remainder of the page, then new group starts on the next page. There appears to be...

I have the arduous task of converting (re-writing) some CR10 reports in CR8.5 Is there a method of saving user-defined / custom functions in CR8.5 ? I see no repository and no "make custom function" feature as in later versions. Thanks

Hi all: I'm in need of the best practice for the following: I need to update the destination table with only new records from a source table. I can use the following to append "new / non-existant" records. INSERT INTO destination SELECT user, status FROM source WHERE NOT EXISTS (SELECT * FROM...