Search results for query: *

I have a Crystal Report based on an XML connection which is produced by another program. I've made the report and saved it with "Save data to report" unchecked. The report works very well with the first report. But when I update the XML file with new data, the report shows the old data. I...

Thanks for all of your suggestions.

Not sure what you mean by 'side by side'. I imported them into the same worksheet, placing each one after each other so that the one worksheet contained all of the files, one after each other.

Hi Skip, Thanks for you suggestion. I think I described what I did by stating in my post -- I pulled the data into the worksheet by "Get External Data" "From Text". I was able to pull the data from three different csv files, then the button on the ribbon was grayed out.-- But to be more...

I have a number of csv files to combine into an excel spreadsheet. I'm doing this by hand as I only have to do this once. I pulled the data into the worksheet by "Get External Data" "From Text". I was able to pull the data from three different csv files, then the button on the ribbon was...

Checking for the NULL in the bottom section worked. First Formula is: if {CUSTOMER.T_CUSTOMER_TYPE} = 'SO' then {CUSTOMER.ADDRESS1} else if isnull({CUSTOMER.ADDRESS1}) then {CUSTOMER.COMPANY_NAME} else {CUSTOMER.ADDRESS1} & ' - ' & {CUSTOMER.COMPANY_NAME} Formula...

This is a very basic issue but I can't seem to get it to work. First off - CRXI with SQL server 2005. I have two formulas that I need someone to point out my mistake in: 1. First formula //============== if {CUSTOMER.T_CUSTOMER_TYPE} = 'SO' then {CUSTOMER.ADDRESS1} else...

Hi Everyone, I have a text field that is set as an HTML format. The query is pulling a field from the database that is HTML formatted and all of the HTML formatting shows correctly but here is my problem. The HTML field doesn't know how to properly deal with periods that have no spaces on...

Thank you for the help. But I am having some issues with this. Do I put all of the following in one formula and ditto with the verifier example also? -------------- @Analyst whileprintingrecords; global datevar assigned; //* The analyst Assigned date I tried using a formula " if...

Some day I hope to understand how to do things in CR. Right now I am so grateful for the helpful folks in this forum. I have a report that has this data Incident_Type Case# Approval Type Assigned date Esig date Turn around time Burglary 11-1111 analyst 11/11/2011...

I tried Ian's approach and the report shows no records. Not sure why. The other issue with this approach I have to call these reports from another program that overwrites any select expert settings I've set in the Crystal Report and I'm not sure if I can put that formula in my other program...

Thanks. I had to make one change in the formula you gave me above. I put a not in front of the isnull and it is working for most of the records. There are a few that are not showing the agency case number at all and I can't figure out why. I put the not in the formula as the subcase records...

I am grouping by user_name which is from another table x_aproval, but when I removed that grouping and did what you indicated, the formula field (fmAgencyNumPC) I put on the report is coming out empty. Here are the formulas I used (they are named differently): //fmParentcase (I grouped by...

Here's some data from cases table name T_agency_ref Parent_case stat1 stat2 stat3 11-12345 2345RT null null null null 11-12345-L-01 Null 11-12345 1 3 4 I want to display the t_agency_ref for the parent case but...

I'm not sure if this is the right forum or not as I'm not sure if a formula or a sql expression will do this for me. SQL databse through an ODBC connection Crystal Reports XI I have a table name 'cases' that has a field 'T_AGENCY_REF'. In this table I have both 'parent' cases and 'sub' cases...

Sorry it took me a while to get back to you to give my thanks for your help - this was a holiday weekend. Your formulas worked for me. Christy

Oops. Sorry. At the Template group level. I need to show the average turn around cases per template (which corresponds to a section at my work). I have two groups: the top one is the Template, the next one is the case#. I put the @fmDateDifffield in the group footer for the Case# group...

One more question on this - how do I do an average on this the @fmDateDifffield? I tried to make a formula, but the @fmDateDifffield still didn't show. Thanks. Christy

Thank you! That worked. And thanks for the quick response. I'll probably be back with more questions as I have lots of reports to design and the best way for me to learn is to get in and do it. Christy

This is what I just tried following what was in http://tek-tips.com/viewthread.cfm?qid=1523073: I made two formulas: @fmAnalystAssignDate which is: if {X_APPROVAL.APPROVAL_TYPE} = "ANALYST" then {X_APPROVAL.ASSIGNED_DATE} @fmTechEsignDate which is: if {X_APPROVAL.APPROVAL_TYPE} = "TECH_REV"...