Search results for query: *

Followup; I've found that our ODBC(RDO) rpts are the ones with the verify db msg. If I set datasource to ADO, then the rpt runs fine. Then, if I change the datasource back to ODBC the rpt opens correctly. ...is there a batch tool to move the datasource? Brad ------------------ Curious by...

We use CR 10 (not enterprise) for approx. 6 users and moved our reports 200+ from one server to another for a migration. The database structure mirrors the old server, but every report we open is sending multiple 'Verify Database' msg boxes. The data is there, the reports run, and we can...

ty ------------------ Curious by Nature, Linux by Design

We have benefits that get updated each year. I need to pull the MAX(START_DATE), but... this syntax works fine in SQL, but Crystal doesn't like it. What is the correct syntax? thanks ------------------ Curious by Nature, Linux by Design

This is weird... Our System\******* DBA account is locked out on the Enterprise Consol login. BUT, if you login local or via sqlplus it runs fine. Anyone have an experience and resolution for this issue? btw...yes, we have other DBA level accts on the box and can access the ent. consol...

Now that we have found a few leads on products thanks to this thread. I have a fellow SA that wants to know if any of these products are able to search thru Stored Procedures as well as the db tbls to build the list of fields used in rpts ------------------ Curious by Nature, Linux by Design

Thanks you for the link...It is very promising for what we want to do. ------------------ Curious by Nature, Linux by Design

Sorry to beat a dead horse... If I have a field db.field1, and I want to change that field to db.field.moredescriptive, there is no way to search all of my CR Reports (assuming they are in a single dir) to find all occurances of db.field1 in my CR reports. So that I can have an idea of which...

Ahhh... I've found the Million $$$$ s\w idea :) thanks ~ Do you have a link for the windoze GREP tool? Thanks again ------------------ Curious by Nature, Linux by Design

We are getting ready to deploy CR ent 9.0 on a test server. 1 Question that is being asked is: If we change a Database field, HOW Will we know if that change affects a report in Crystal report. Say we add a status code for something, how can we find all reports that have that db.field name so...

Thanks, I had done that. But I think I have the answer. The overlap of school dist. is causing a problem that I didn't see at first. ------------------ Curious by Nature, Linux by Design

I have a query that pulls the Local and School tax from a payroll check, ie: wage = 1000.00 , local = 2.50, School = 2.00 Now when I rollup the group totals I get SUM of Wage = 2000.00 and SUM of PayDeductions = 4.50. The Taxes are calculated correctly, but I have doubled the Wages ~ because...

Thanks, works like a charm. ------------------ Curious by Nature, Linux by Design

Is there a way to change the default in a crosstab group options WEEKLY on the starting day of the week SUNDAY? Our week starts on MONDAY. If I can't change it in the defaults, can I do it with a formula?? ------------------ Curious by Nature, Linux by Design

are you assigning the date that matches to a variable? " ~ NO I am trying to pull all FIRST OCCURANCES for a set of data. I don't even have data params in the query. I need any and all first occurances. That is what seems to be crushing me... ------------------ Curious by Nature, Linux by Design

I have a record where the each date entry pulls the description with it. ie 12/1/04 charge 1 charge 2 1/5/05 charge 1 charge 2 and so on...each date pulls the orginal charges into the table. Now, when I try to spit out the charges I get charge 1 charge 1 charge 2 charge 2 and so on...

Ah...TY. I had added the formula into the field properties. ------------------ Curious by Nature, Linux by Design

I did and got 3 rows of FTA returned. They didn't sum together...Thoughts? ------------------ Curious by Nature, Linux by Design

I have 2 categories ~ VOP and FTA, but they have sub categorized FTA into FTA, FTA-A, FTA-B & FTA-C so when I run my crosstab I get: FTA FTA-A FTA-B FTA-C VOP All I need to show is: VOP and FTA as a ROWS. How do I add the FTA's into a single summed row? thanks ------------------ Curious by...

Can you add the TOTAL of two seperate Crosstabs into a THIRD cross tab based on the ROW criteria matching? thanks ------------------ Curious by Nature, Linux by Design