Search results for query: *

The above said is if you are trying to get all records into your report if user gives 0 for your parameter. If you are trying to create a formula to put on your report then IF{?BeginAmount}= 0 then 'ALL' else BeginAmont field = cstr({?BeginAmount})

IF{?BeginAmount}= 0 then true else BeginAmont field = {?BeginAmount}

Hi LB, You should be given a Star for your patience and especially for your politeness and modesty!!! You are really wonderful not just in giving great solutions but also for the above said things. Thank you so much for the knowledge you share with us. Regards, JK.

Under Database, could you please tell me , what all properties you can see?

Go to DATABASE tab, select Set DataSource Location and then whatever tables/views/procedures etc you are using in your main and subreports, set their USer DSN Default Properties to TRUE. You'll find the User DSN Default Properties under Properties. If I'm not clear please let me know. I'll...

Create following Formula - numbervar n; (cstr({table.number}[5 to 6]&{table.number}[3 to 4]&{table.number}[1 to 2])); Then sort the data on that formula.

Try having two groups. First should be on the year and second one should be on the month.

Create the following Formula and then group on it. if {table.field}>4 and {table.field}<18 then '5-17' else if {table.field}>17 and {table.field}<60 then '18-59' else if {table.field}>59 and {table.field}<76 then '60-75'

if pagenumber=1 then TRUE Else if pagenumber=totalpagecount then TRUE else False Please copy the above and paste in it wherever you were typing in the code for suppressing the last blank page.

Replace with the following code where you have this code //‘if pagenumber=1 then true Else False’ // if pagenumber=1 then true Else if pagenumber=totalpagecount then true else False I'm hoping that this is waht your report needs. If not , then I didn't...

Try this one: Please go to each of your subreports and go to all the sections' expert (which are not supressed by you) check in the box besides 'Suppress blank section' option. But this shoud be done for all the subreports including report footers.

you're welcome!

Why can't you use 'Newpageafter' in your group footer's section expert? I feel that it would help!

Could you please tell me the value of you groupheader 1 for the first time and the value for the same in the last group?

go to 'format subreport' by right clicking on the subreport and select 'Subreport' tab among the four tabs you have. In this you'd see a box (which you should check in) for 'Suppress blank report'. Then on the main report, where ever you have your subreports , go to tje section expert and...

I mean, the filed name you give in groupname({table.field}) as well as maximum({table.field}) should be te name of the field on which you have your first group.

Hi, Go to the 'Format Text' / 'Suppress' x+2 and type down the following and see groupname({table.field})=maximum({table.field}) It should work.

How about creating a formula like this: {field1}&'.'&{field2}

Click on 'Default Values' button in 'Edit Parameter Field' Window.It would take you to 'Set Default Values' window. first set the description for the values of your field and then select 'Description' for 'Display' Option in the same window.

CURRENTDATE-90 would give you 3 months previous date.