Search results for query: *

If I place the formula in the suppression area I get an error message: must be boolean.

I tried the formula below as suggested, but it retuned the same values as service day. Nothing was supressed - all fields still show. If previous({ENCOUNTER.ENCOUNTER ID}) = {ENCOUNTER.ENCOUNTER ID} then previous({CHARGE DETAIL.SERVICE DAY}) else {CHARGE DETAIL.SERVICE DAY} No, this is not...

I am using CR 8.5 and have a report that is grouped by Patient ID and Service Day. The data is shown on the Service Day group. Each patient will have more than 1 record (multiple days in the hospital), and I need to retrieve the second to last day of each patient. In the example below I need...

Please disregard. I found a way to circumvent Infoview's refusal to read the 'in specified order' command by using the Top N function instead.

I'm using CR 2008 and my company just moved to Business Objects 2010. I have a stacked bar chart that displays insurance plans in this order (using the 'in specified order' option): Medicare Commercial Medicaid Self Pay Now the new Infoview is rearranging the order to show: Self Pay Medicare...

I added the text, but I got 1's on all minimum dates. I need to limit the count to just a single date. In this case it's 12/1/2010 so I added the second line in the where clause. ( select min(TransferInTS) from edw.lw.vPAT_LOCATION A where A.LWAcctNum = vPAT_LOCATION.LWAcctNum and...

Hi, I'm using CR 2008. I have a report grouped by patient account number and transfer in date. Each account can have multiple transfer in and transfer out dates. I want to display all the dates and times, and add a field that counts patients who are new for that day. For example, on...

After changing it to "<>" it worked. I wasn't familiar with the remainder function, but it seems to work great in designating every 2nd week. Thank you very much.

I'm using CR 2008, and I am trying to create a formula that groups data every 2 weeks and display a label with the last day of that time period. Periods begin on a Sunday and end on a Saturday 14 days later. I would like to do this without creating a separate table that lists 2 week periods...

Turkbear and LB, thank you for your suggestions. I tried a small sample size using an if-then formula along with a supression formula, and it appears to have worked. I'll need more time to test larger data sets, but I think you've pointed me in the right direction. To answer your...

That works if I limit the selection to just those 3 charges. However, I have a list of 20 charge numbers with various combinations. From the list of 20, charge numbers 1 - 5 can be together on the same date, but they can't be with any of the numbers 6 - 20. And within the 6 - 20 set, some...

The charge numbers come from the same field, {Chargenum}. The details section is shown along with the following groups: {Dept} {Account} {Servicedate}

Hello, I'm using CR 11 and I've been asked to write a report showing if certain combinations of charges show up on the same date. If they do that's an error. The report currently uses the "Is one of" function to show all the charges grouped by service date, but some dates only have 1 charge...