Recent content by srajesh

yes, the details of all 35 columns are listed. the problem is with summary options while grouping in report wizard

i have used report wizard, grouped under Subfincode. Then under summary options, fields 3710 to 3920 are only listed. (the result of query is attached with earlier post)

i have attchd. result of crosstab query in excel.

thanx for the reply. i tried again but i don't know why its limiting to 20 fields.

Hi, I have a crosstab query which generates 35 columns under column heading. The report based on this query shows summary option for 20 columns only. How do I extend this to include all fields generated by crosstab query. When I try to add a summary for one of the fields in report design, it...

Hi all I have a date field in a table. In a query, I want to capture the startdate and enddate. However when I select the date field in two separate columns in the QBE grid and give [enter start date] & [enter end date] in criteria, the query on processing clubs the two and converts it into...

Hi Justin Thanx for the reply. Actually I want to view records based on the values in one of the calculated controls which I have brought on to the report. Thus this cannot be specified in a query. Also if I specify any criteria in the visible property of the control, this will apply only for...

Hi I have 3 sub-reports in my report placed one below the other. I also have six test box controls which are adjacent to these sub-reports. Now, while previewing as well as printing the report, there are gaps between the text box controls which I think is because of the sub-reports. Is there...

Thanx for the reply. Actually I have based my report on a query. But I also have added some controls onto the report. Now I want to view records based on values in these controls, the criteria for which cannot be specified in the query. For eg. I want to see records for value > 1000 only.

Hi I am having a report which has calculated controls. 1. Is there any way I can filter the reported based on the value in calculated controls. 2. Also when I am exporting the report to Excel, the calculated controls do not get exported. Is there a way of achieving it. Basically, I want to view...

I have a form based on a Table for data entry. I converted one of the fields into a calculated control. But the field in the table does not get updated with this value. How do i bind the control to the field in the table.

Many thanx for the code. will definetly try it out.

I have a text box control in a report for calculating tax liability depending on taxable income and income slab. However I am not able to use nested IIF. How do i achieve it.