Search results for query: *

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...

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...

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...

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...

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

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...

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

I am trying to pull 3 crosstab reports into one master report. I've added the sub-reports to a master report, but they are all on indvidual pages. I want them all on the same, or contiguous, pages. I see that the crosstab puts the data into the Report Header, is that what is causing the problem...

I have {charge.Withdrawn} in [isNULL,1.00] and it hates me so I tried in [Null, 1.00] and it is still wrong. Can you pull a NULL field in a 'is like' formula? otherwise I have to build an OR stmt and I never get them right in CR. thanks, ------------------ Curious by Nature, Linux by Design

I have Proxy Module on Box1 for getting a site on Box2 a)Proxy_mod is loaded, b)This is set in httpd.conf IfModule mod_proxy.c> ProxyRequests On ProxyVia On <Proxy *> Order deny,allow Deny from all Allow from 192.168.0 </Proxy> c) the vhost block is set # Virtual host...

I have been asked to explore options for our department to update our current DATA to FORMS integration process. Currently we have over 200 forms in MS Word 2K Document format with form fields. Since we migrated to Oracle 8i last August, Management now wants the data from Oracle to...

In have a report that requires a count of totals based on 30, 60, 90 120 days. So my report ending June 30 will contain approx 2500 records. I then need to count the number of records in the last 30 days, then the 31 to 60 day, then 61 to 90, etc. So, I have a my date variables auto calculate...

I have a crosstab report of approx. 3500 records. the total col is 1 to 5. SO,I have about 2500 1's, 1000 2's 350 3's ... etc, but I can't figure out how to get the EXACT count of the TOTAL col. My field in there is {Count of REFERRAL.CASE}, but I set up a Formula field like NumberVar x :=0; if...

What it the FORMULA for adding a counter to the DETAIL line? VarNum x :=0; x=x+1; Returns 1 for every detail line. This has to be a fairly common thing. I don't know why I can't find a special field for LINE NUMBERING thanks, Frog

I have a report that requires the Day of the Month to be formatted with the ST as part of it. i.e., 1st, 2nd, 3rd, etc. Is there a format in the Formula builder to add the st, nd , rd to the date? If so what is the sytnax. If not, has anyone built an if..else stmt to handle the addition of...

I have a to setup a number of Crystal Reports for export to MS Word so that users can update them. I want to export the documents with something like a BOOKMARK in word so that the field areas that are available are noticable to the user, but not going to print with gray'd backgrounds. Has...

Does anyone have a tutorial or FAQ for setting up a cookie to store SESSION variables? I cannot get the session variables to work on my testing area. Does SESSION require a web server to process ? I am testing my site work locally. I need to pass a number of variables across a 5 step website...

I need to find the gaps in a number range. i.e. for a given month we use the number range 1000 to 2000, but we don't use 1012 because it was canceled. I need to summurize the column CLOG# to find the gap between 1011 and 1013 so that we can note the missing number. I've been trying sum and...