Search results for query: *

Thanks Ian. My report is based on SQL command which is something like below. Select product, network, sum(duration) from event_table where event_date between {?BeginDate} and {?EndDate} group by product, network Since parameters BeginDate & EndDate are Dates, the calendar shows up to select...

Hi All, I am trying to figure out a way to create a date parameter where the value which the user selects cannot be more than last 6 months. OR Is there any way I can restrict the user to select the date value to previous 6 months for the date parameter. Can we accomplish this without using...

Thanks LB. Works great.

Worked out great. Also just wondering, how do I highlight the entire row when remit <> revenue? Thanks LB. This is not the first time you are helping me out.

Revenue & Remit are separate summary fields. Row = MonthYear Column = None (No Values for Column) Summary Fields = Revenue & Remit

Hi All, I have the following cross tab report. Revenue Remit Sept 100 100 Aug 90 80 July 230 220 I need to highlight the values in the Remit column where Remit <> Revenue. Any ideas on how to accomplish this? Thanks in advance.

Hi All, After viewing the report in BO XI Infoview there are options to export the report, where we can select the format. Is there anyway we do not show the export option : Crystl Reports (RPT). We do not want the external users to be able to see this option since we denied the rights to...

Yes I was asking about how to create a string generated by a main report that will be accepted by a command in a subreport. Thanks much lbass for the reference. I will look into it.

Thanks Madawc, lbass, bob. It makes sense to enter the parameters as 'Dave','Joe','Bill'. However, the parameter is a List of Values from Business Views and lot of values which would make it difficult for the user to enter multiple names as a string. My current design uses a main report which...

Hi All, I have a parameter with multiple values called First_Name with values like: John, Mike, Paul).Crystal treats the multiple values parameter as an array. I need a formula to join these to a string like: 'John','Mike','Paul' . I plan to use this string as a parameter within a sub report...

This is very useful information. Check this out as well http://www.pdfburst.com/ Not sure if it works well with crystal. Let us know how it which one works better with Crystal

Thanks LBass. Am using something similar. RunningTotal formula in TaskNotesID group footer: WhilePrintingRecords; NumberVar Amount; Amount := Amount + {@yourformula}; RunningTotalReset formula in TaskOwner group header: WhilePrintingRecords; NumberVar Amount := 0; RunningTotalDisplay formula...

Hi All, I am calculating the difference between two dates within a sub group {Command.TASK_NOTES_ID} using the following formula. DateDiff ("d",Maximum ({Command.ASSIGN_DATETIME}, {Command.TASK_NOTES_ID}) ,Maximum ({@LastUpdateDateTime}, {Command.TASK_NOTES_ID}) )+1 I want to sum of these...

LB you mentioned in your first response: While in the subreport, suppress all sections within the subreport (but the not the sub itself or the section in which it is located). I saved my report as two reports subrpt.rpt and mainrpt.rpt. Now I inserted the subrpt.rpt as a sub-report in the...

Hi LB, I did everything which you mentioned. But however the report doesnot show the results which we wanted. Infact its showing the opposite. The report has same hospclass groups and valid transfers. Is there anything which we have to change. Thanks

Thank you LB for the response. However I need the report for a little complicated scenario. 1. The patient SSN will have 2 (admission and discharge) or more records based on the treatment. So instead of checking for the first record we need to verify based on the previous record. For example...

Can anyone share any thougts on how Crystal formulas can be used in this scenario. Thanks,

Hi All, I have a sql code which extracts the hospital patient data. The records are grouped by SSN and ordered by timestamp. Here is the source data SSN HospClass Activity 123 Inpatient Admission 123 Outpatient Discharge 234...

Thank you.. this will work..

Regarding vertical formatting.. is it possible to insert a new line before the summarized fields? Thanks.