Monday, March 19, 2012
Details Section Question?
How to let Detaisls Section fill empty space of the report
For example SalesInvoice Report
ReportHeader-->Sales Invoice Headers
ReprtFooter -->Sales Invoice Totals,etc
Now Details Section-->
i want it to fill the remain space with Salesinvoice Items even if it only contain few items
How do i do that?
Thanks in advancenot a issue man just put the item fields it will display the item it contain and will leave the remaining space blank automatically we don't have to do anything in that . This is the only benefits of using details section it will calculate paper size and then minus header and footer and remaining space will be used by details section
ok.
Details section does not show all details
I have a data entry application where the user is allowed to enter multiple funding, goals and objective selections for each Project ID record. I have a database that lists each Project by ID and a relational table for each selection and its corresponding project id. For example:
projid type descr
1 Funding Capital
1 Goal PI-1 To develop a project that will come in on schedule
1 Objective PI-1.1 Schedule objective 1
1 Goal T-3 To develop a project that will come in on budget
1 Objective T-3.1 Budget objective 1
1 Objective T-3.2 Budget objective 2
1 Objective T-3.2 Budget objective 3
The report only prints the following in the details section:
projid type descr
1 Funding Capital
1 Goal PI-1 To develop a project that will come in on schedule
1 Objective PI-1.1 Schedule objective 1
Any help is greatly appreciated!
I started a brand new report starting with the details and then adding the two groups and now all records and data shows and sort correctly.
|||I started a new report and now all related data is showing in the details for each record. But there is another problem...the report sorts by Project Owner then Project Name. If the project name is the same in 2 different records (i.e. Record id = 89 with project name = "Project" and Record id=90 and project name = "Project" the report show record 89 but in the details it shows related detail for record id's 89 and 90 and then doesn't show the individual record id = 90 at all. I don't understand why the details for each record are dependent on the project name. I am new to SQL Reporting and appreciate any help.
Detail Section printing 18 times
Apologies if its a stupid question but this is my very 1st report - a sales invoice.
I have a detail section - limited by parameter to sales invoice number. When it prints the detail section is repeated 18 times. Ive checked the database there is only 1 record with this invoice number.
Any idea where I should start looking? As this is my 1st report there really isn't anything fancy going on.
Thanks for any help
Beckicheck if u have created any groups|||Also check the relationships between the tables used in the report.|||Thanks for your help.
I turned out that the link I had inserted wasn't completely unique and attracted too many records.
Regards
Becki
Detail Section Limit Records
I have limited my detail section output to print 20 records per page, but if have total of 108 records ,First 100 records are printing 5 pages and the 6 thpage prints 8 records .
I want that the 6 th page to print 8 records , plus 12 lines filled with dashes (---).Making the page to appear having 20 lines .
Can anybody help
thanks
ShaliniI had resolved something like that by modifying the data source, I mean, generating the extra lines when writing the output file