Search results for query: *

I believe there are no nulls

I have ONE table where there are 3 independent name fields: name (lastname, first name) lname (last name) fname (first name) I am looking for ALL mismatches whatever they are. Using Crytal Reports XI will the following work (research for a friend)? {TABLE1.NAME} <> {table1.lname} + " , " +...

We use the Crystal Report Enterprise that comes with Crystal Reports Server. I create a report and upload into the Enterprise and using the Infoview module there I can schedule the report to run during the night and be emailed out to various individuals or groups as a crystal report, pdf, word...

Will this work if its just ONE data field on the page header not the whole page header that I want to suppress on the crosstab pages?

Thank you lbass, that worked perfect for the set of reports that I working with right now. what are the other ways? I have a similar problem with another set of reports... where the crosstab pages vary from 1 - 3 pages...

CRXI and SQL database I have similar reports with varying lengths of detail pages but the last 2 pages are filled with summary crosstabs where I do not want a specific field in the page header to display. I have tried suppressing with the following formula: OnLastRecord and...

I schedule reports to be sent out by email to staff in our agency through InfoView which is part of the Enterprise. There is a spot where you add a message to be sent with the email and I think you could put a web address in there. I can test that out. The report/email can be scheduled for...

This works great lbass!! Many thanks. Would the formulas be different if the totals were at the bottom? Now I have to figure out what this is doing so I will understand it. :)

MonoSpaced Text CRXI and SQL I have read various threads on this but my brain can never figure out what to do with my crosstab to make this work. My report is an insurance profile that runs each month and shows the type of insurances, the number of clients with that insurance and the percent...

Thanks LB... I was close but you were perfect!! I learn something new everytime I visit here. :)

CRXI with SQL I have a report that is grouped by ConsumerID and EpisodeEndDate that shows the number of times a person was discharge within a Fiscal Year and some detail about types and number of services provided. I have a formula for the LOS (length of stay) for each episode of care for each...

I am not sure what you mean by shadow white. If you want a white background inside the box do nothing. Right click on the text box and choose format text. then select border as black and background white. then choose single lines for the top, bottom, and sides. Does that look right to you?

yes, lbass you guessed exactly right, it was the page header. Your formula modification works perfectly!! thanks!!!

CRXI and SQL I have a report that is group by supervisors and report specific data for employees under them. I have the employee name visible in the header with their data displaying on their own page. Sometimes there would be an extra page at the end of the group so I put in a formula to...

Duh... I feel so stupid! :) I had nothing in the RS thinking the parameters did that! I need to make this have as few steps as possible for quickness for the user. Would cascading paramters be a good idea? If I understand them right... they would type in the last name and a submenu would...

CRXI with SQL database I have no experience with parameters but I am trying to create a simple report and I am lost. Using one table with client information I would like to create a simple report that will display the clients case number and date of birth after the user has specified the...

Should there be an ...and... or an ...or.. between the two statements?

Nevermind... I found it in another search!!! thread767-1291407 Works perfect!!! You guys/gals are FABULOUS!!!

ok, I got it plugged in but it did not return data for the Thursday of that week. Actually, there were no appts scheduled for Wed or Fri. Do I need to account for that? There is a preset formula for LastFullWeek. Is there a way to create a formula for NextFullWeek? That would be the best...

Is that an open parens after the word today?