Search results for query: *

Great help! It got me past the initial error but, as you said, it doesn't stop there. :) Now I am getting another error: "Internet database error" A whole lot of info in that error. At least with the other, I had something to go on. I know that I have the MySQL server port...

I have created a Data Access Page and published it to an IIS web site. I have absolutely no problems connecting to and using it as long as I am doing that on a machine that is INSIDE the LAN. The website is however also accessible from the internet. When I bring up the page from a client...

And that is all you are going to get. What you are exporting is essentially a view (or query in Access). The closest you MAY get is by taking the SQL statement it generates and plugging that into Access as a Query. You will have to link to the database used but you will have access to more...

There should be no problems there. You will naturally have to install the MyODBC drivers and create a connection the database you want on the computer running Access. From there just link through that MyODBC connection to the tables you want. -- Loren

I have 1 W2K server and 2 XP machines networked together and to the internet (all machines have static IPs). The server was upgraded from NT4. It is connected directly to the internet (1 static IP) and that NIC is software firewalled on the server. The rest of the machines come in through a...

THANKS! That was it! :)

I have a simple one table DB where I am tracking incidents. On the incident input form I want to have a total count of an entered incident number from the table. In other words, when I select or enter a number in one form field (IncidenID), I want another form field (Count) to output the...

Already tried that. It outputs 12:00, irregardless of the number. Thanks anyway. :)

I have a Query pivot table that is generating totals and grand totals of a number which is actually seconds. I would like to show these totals and grand totals in a time format: hh:mm:ss Is this possible? Thanks Loren

That should do it. I did not design the actual page but after looking at the KB article it looks like its exactly what I need. Thanks (again!)

I have a report setup to run through a web page. I requests three parameters: startdate (date), enddate (date), groups (text). When the user runs the report on the web it askes for each parameter but does not allow entering multiple values for the group parameter. If I run the report through...

...it takes a while but the gods do answer! :) This is, as you guessed a MagicTSD database and the way the multitude of tables are interconnectd makes it a pain to work with from the get go. I'll get with you by email once I get a chance to. Thanks Ro! -- Loren McDonald

In the order you Posted... I guess I'm just too DB illiterate to fuly understand your indexing question. I know that each table has its own Index field. The Help_Desk index is the Problem# field which corrasponds to the Details Prob# field. The Details index field is called Index and there...

No change in the performance at all. I guess that there are just too many records to sort or group records at the same time as selecting on sub records... about 2000 Ticket records and about 16000 Ticket Detail records. Maybe this is causing it to hit all 16000 records 2000 times as it sorts...

Thanks for all the tips. Our Help Desk software has quite a complicated database of tables. "Action ID" = "SENDLATENOTICE" is correct. I pulled it directly from the field just to avoid spelling errors. The naming scheme is not always understandable or what you think by...

Ok... Above I changed some of the field and record names to make it easy. The following is directly from the report and should be self explanatory: This is the version of the report with no grouping, only sorting on the Last Name. With grouping on the server the time is 7mins. Selection...

If I am understanding you correctly, yes, both tables are indexed. Ticket.Ticket# is the index for that table. There is a different index for Ticket-Detail. After posting the question I tried generating a new version of the report with no grouping and no sorting at all. I put the...

I have written a report that sorts records of two tables in order to get a trend report for clients that submit tickets that "need more info" and "need more time" to complete. Each of these are reflected by a Detail-Type in the Ticket-Detail Table. The report drills down...

Great Quick answers! Thanks!

I'm new to using Crystal but I thought this wouldn't be such a difficult task: I am pulling open duration information from Help Desk Tickets to calculate how much time each person is spending on them over a given range of days. Each instance is in seconds and a grand total, also seconds, is...