Recent content by kenndot

oh , sorry... have you checked it out? if you keep it open in the corner somewhere you can just click the funtion name you want.... kinda the same thing?

not exactly, but you can use the document viewer... that gives you list of all your functions/procedures and then you can click on THAT to manipulate where you go.. does that help?

Ditto on everything! One thing, though, we're starting to use Cognos here (Impromptu) but migrating over to ReportNet, if anyone has any of that background, please visit the Cognos Solutions forum! There's NOTHING out there right now for Cognos and what IS out there, nobody answers most of the...

Using Reportnet I have 2 dates: date1 date2 on each row I want another field to tell me the difference in minutes between the two. When you create a calculated field, you have 3 options, the documentation tells you to use the 3rd option (Layout) to use runtime info. (I have tried all 3...

DoubleD You mention that it's possible to hide/show groups? Where is that option? FYI: I've had problems w/grouping, it's not as straightforward as you would expect. Furthermore, there is a known bug which I ran into (it was logged back in March I guess) where when you group and view the...

Just in case anyone has a similar problem... I figured out the solution. Somewhere in SQL Server an older view of the table that I am using in the database was stuck and that had a different datatype for the field I was working with. So eventually I decided to recreate the view in SQL Server...

I have two tables tblallclaims tblpaidclaims they both have this field: age decimal 9 I have a lookup table tbl_ageranges and an alias of this lookup table alias_tbl_ageranges this table&view have fields - exactage decimal 9 tblallclaims will link to tbl_ageranges on the exactage field...

Trying to recreate an Impromptu report in ReportNet. I have a very simple grouped report: Priority # Completed 1 201 2 100 3 103 ... and so on. There is another field being used in the query called Completed that is a date/time field. I am...

thanks everyone, what everyone said was great and certainly true but not really what I meant to ask for. I don't think it came out the way I thought it did. I will try to think of a more clear way to post the question that I am trying to answer.

i tried it in 6 & 8 and i got 0 in both... i don't have 7 or i'd try that too are you doing this in the command window and then displaying "x"? or are you putting this into a table with perhaps not the correct field size? that could give you those results, too

I am actually trying to take that just a bit further and translate the commands SHARED,EXCLUSIVE,NOUPDATE into CREATE,READ,UPDATE,DELETE so then based on what you are saying the answer to my question is as follows?: CREATE - anything that's opened with SHARED,EXCLUSIVE READ - anything opened...

Hi all, Making a crud matrix in I guess the "traditional" format. So I need to determine what Foxpro keywords match up with the CREATE READ UPDATE DELETE All I'm aware of as far as access to tables is NOUPDATE and SHARED and EXCLUSIVE. How do those translate? EXCLUSIVE C,R,U,D SHARED...

can you take it a step further and automate the lookup and output to excel file? I am looking to direct it to a directory which is full of subdirectories (which are app names) and find the tables it uses (from the code) and export that to an excel spreadsheet or html and move along to the next...

here's an even better way, though I open the original table copy structure with production insert into thetable SELECT blah from blah where blah fast and efficient thank you for your suggestions

actually, it did work. I take a small subset of a table, rename it, then copied over the index file and renamed that and it openened fine and I was able to use the indexes and everything. Problem is, however that it takes some time because the files are big and I'm not sure that I want to do...