Search results for query: *

I might be asking a silly question. What are guides? Tried checking in the help/guide, couldn't find any. Can you provide some more details on placing guides.

I am using CRXI. And the oreintation is Landscape. Need some inputs from experts who have dealt with this kind of problem.

I have 38 data elements to be displayed in a report. In page setup, chose " 11X17" and orientation has "Potrait" still am running out of report layout for data elements to be placed. Is there a specific layout or settings in the layout that can be done to increase the report layout. When tried...

It works. Thanks Ian.

It doesn't work. Its looking for the else part to have something for the parameter. In my scenario, If {param-5} <> 'ALL' then {report.field-5} = {?param-5} else I want all the records to be considered including NULL values for the field. {report.field-5} Like '*' / {report.field-5}...

My report extracted based on parameters. There are about 12 parameters. Few of the parameters will be initially set to default values in parameter section like 'ALL'. ALL - means no filter on that field, problem here is the field is null in the DB. How to handle this is Record Selection section...

Check box is unchecked.

I have strange problem in setting N/A to null dates in the report. When quering db it returns the data where date is null but the same when checked in formula CR XI doesn't set to N/A but displays some julian date instead of N/A. Code piece is as follows if isnull({sp.LOAD_END_DT}) then...

It works fine. Looks like the convertion of DB field using variable was not required. Thanks LB. -RP

Hi Experts, I have a view created in DB, columns in the view are based on grouping and not individual values for columns. The problem is when there are null vlaues, want them to be replaced by "N/A" value. The data type of the column is date. Tried all validations of IsNull, DatePart, InStr...

I know what was the problem was. Fixed it and it works. Thanks for the help LB

Hi LB, When the formula is validated it throws an error that " This field name is not know " and highlights this {?ShipmentEndDt} in the second line. if {?ShipmentCrtdDt} <> date(1999,9,9) and {?ShipmentEndDt} <> date(1999,9,9) then

I have an issue in applying a condition based on the parameters provided. StartDate & EndDate are parameters where data is provided and the report is supposed to extract data where createddate from database falls with in the provided date range. code written in record selection section is a...

It works. Appreciate your help. I am using the following code If IsNull({FMX_SHPM_OPMZ_RPT.PLAN_ID}) THEN 'NULL' ELSE cstr({FMX_SHPM_OPMZ_RPT.PLAN_ID},0,"") For only this data field the NULL validation is not working and shows " 0 ". Used the same code for other data fields and it...

I have one question on this solution. By converting numeric to character using cstr function, the numeric data is represented as 9,999. I could remove the decimal part from the data and couldn't do away with comma. Is there a way to remove the comma from data. Thanks for the help GP. Thanks, RP

I have a report where charater data like "NULL" to be displayed for number data types. Ex: - If and ID is blank in the database then display NULL in the report. ID is of Number data type in Database. Need to display the same for Date values too. If the start and End dates are blank then display...