Search results for query: *

Hello, I have an Access find duplicates query, that part works fine. It pulls in invoices that can be entered multiple times... once with Processing, Payment Processing or Paid as a status. How can I set the query to only pull in Duplicates for the Invoice field, and those that also have paid or...

We hacve an access DB that was created in '97, but are currently using 2010. The user level security wizard was used to lock down the DB, but the person who did it is on extended medical leave. We used the User and Group permissions wizrd to add a new user, and is seems to complete, but that...

How can I create a cross tab in Crystal 11 that won't ignore the overall Selection Criteria? When run, the detail data is correct, but the Cross Tab pulls in everything thanks in advance

I am pulling data based upon a date field, now they would like the next full month, plus 14 days (so basically a month and a half). Any pointers on how to do that based upon a date field? Thanks in advance!

I have a report, the records shown in the detail section are being limited by the selection formulas, but the crosstab seems to pull in all data, there are records in the crosstab that aren't in the details area. Any ideas of why this might be?

Is there a way to put a formula on the report that will give how long the report took to finish? I'm trying a few methods to speed up my reports, but need a method to verify the changes. Thanks in advance

Is there a way in SQL to show the end user a message as parts of the SQL script complete? I'm using WinSQL if it helps.... Thanks in advance

Hello, I'm using CR XI SP2, as I tried to create a new report today, I am unable to manually link keys in tables. It will do the auto link, but I need to drag and drop links. It worked yesterday... I've uninstalled and re-installed, still same issue. Thanks in advance Bob

Hello, We're using Office 2003, excel, word etc always ask me if I want to save the current copy when I close, even if I have not made any changes. This even happens on a document that I have previously opened and saved. Any way to turn that off? Thanks in advance

Hello, I have data in a table that is identified by a fieldnum, if fieldnum = 1 then the answer column is a zip code. Each "chunk" of data also has an identifying number that shows which group goes together. Is there a way in sql code to "flatten" the data? Move each pice to a column so that...

I'm pulling data from a strange database, there is a FieldNum id that denotes what data another field is (If Fieldnum = 31 then Answertext = State, Fieldnum = 92, Answertext = County). Is there a way add criteria to the Insert command such that if FieldNum = 92 it populates the County field etc...

I have a make table query, where I get the error "the command did not produce any data, and did not create any rows." The Select portion works fine by itself. What am I missing? It is being run against an Advantage DB Create table Title ("EntityID" CHAR(24), "EntityRole" CHAR(16), "Office"...

I have make table query, where I get the error "the command did not produce any data, and did not create any rows." The Select portion works fine by itself. What am I missing? Create table Title ("EntityID" CHAR(24), "EntityRole" CHAR(16), "Office" CHAR(50), "Borrower" CHAR(64), "Client_Name"...

Hello, I have a Dell Latitude C640 that does not have a cdrom installed (unit is missing), should it still boot up, or at least give beeps? Thanks

Hello, I've finally gotten the CE10 system up and running, but I can't schedule to the unmanaged file system. Under Servers, reportjobserver and programjobserver, the Destinations Tab is greyed out. I've checked, and a full install was done. I'm logged on as the BO Administrator, although I...

Hello, I'm using CR11, and trying to decipher someone else's report. There is a date range parameter that seems to work correctly, but I can't find where in the report it restricts the data. It isn't in the select expert or group select, it doesn't show in "show sql"... where else can I look...

Hello, I'm running IIS 5.x on XP SP3 in order to use Crystal Enterprise. localhost works fine... CE sets up Applications mappings for custom webpages of .cri, .csp and .cwr which point to a .dll in the program. This install works fine at home for testing, but on my work machine, I get HTTP 500...

Hello, I'm using CE 10 on XP SP3, running IIS. I can open the Admin Launchpad, but when I try to open the Crystal Management Console or any other page from there, I get the error "The website cannot display the page" the URL it is trying to open is...

Hello, I'm using the following code to set my column width in a Macro, but it doesn't always work. Is there a better way to do it? I have about 15 different columns that I need to set. Excel 2003 Thanks,

Hello, I'm using access 2003, I have a table that is sorted on an description field, when I added an Autonumber field, it changes the sort of the table. How can I stop it from doing that? Thanks