Crystal Reports - Two stub check detail section repeating on multiple pages -


i have crystal reports - ap check report in format stub-check-stub:

  • the 2 stubs present identical details of check (invoices paid, etc.), total of invoices @ bottom of each detail section.
  • the actual check sandwiched between them in report.

if there more 10 detail line items, additional line items should appear on subsequent pages check section voided.

the report has first stub subreport in details section within group check number. check page footer - a, , second stub subreport in page footer - c. (page footer - b suppressed)

i have checked new page after - 10 visible records checkbox in details section of main report, , in details section of both subreports.

the report works except second stub subreport details section repeating same 10 detail lines on every page of each check.

this same question asked here: (crystal reports) break page after # of details? , answer provided didn't work second stub details.

does have suggestions on this?

the "new page after - 10 visible records" start new page after 10th records. it's similar solution provided. if want 10 lines on first page, can use same solution on link change formula on point 5. after record 10 start new page.

  1. open report in design view

  2. right click on details section , select section expert

  3. make sure details section selected in section expert dialog box. check box says "new page after"

  4. click formula editor button right of checkbox.

  5. enter following formula:

    recordnumber = 10

  6. click save , close , click ok


Comments

Post a Comment

Popular posts from this blog

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

i have detailsview control on page used edit various fields of record, works in respect. i looking way add 1 column (and if works, why not more) right, absolutely read-only, show same fields of record comparison purposes. i aware there no obvious way such thing out of box detailsview . have looked other controls (transposed gridview , recommended formview , listview ), nothing satisfies. have special data binding setup using detailsview , can't out of without losing features. anyone on how "hack in" additional columns (for display only) on detailsview ? the solution have now, use second detailsview , visible set false in aspx. in code, make sure databind hidden detailsview hosts data third column first, initial detailsview named itemdetails . and in item created event, pass third column html rendering of hidden controls (in last code block) : protected void itemdetails_itemcreated(object sender, eventargs e) { if (dataite
Read more

javascript - firefox memory leak -

i have following script (i use raphaeljs also) draws circle, waits 1 second, draws circle again, etc (you can copy paste - functional, need include raphael raphaeljs.com): <div id="holder"> </div> <script src="raphael.js" type="text/javascript"></script> <script> var paper = raphael(10, 50, 320, 200); var rad = math.pi / 180; var finangle = 0; function sector(cx, cy, r, startangle, endangle, params) { var x1 = cx + r * math.cos(-startangle * rad), x2 = cx + r * math.cos(-endangle * rad), y1 = cy + r * math.sin(-startangle * rad), y2 = cy + r * math.sin(-endangle * rad); return ["m", cx, cy, "l", x1, y1, "a", r, r, 0, +(endangle - startangle > 180), 0, x2, y2]; } var path = sector(100,100,50,0,180); var arc = paper.path(path); function draw() { path = sector(100,100,50,0,finangle);
Read more

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -

i student , quite new programming, , given task using asp.net , c#, without being taught either. plan learn teach ourselves. the task stuck on making website import csv file sql server database of last year's room bookings around campus. the table has following columns: request_id; priority; module_id; day; start_time; length; park; students; room_code; status; semester_id; linked_request; week_1; week_2; week_3; week_4; week_5; week_6; week_7; week_8; week_9; week_10; week_11; week_12; week_13; week_14; week_15; ) in code, try make work 3 columns (request_id,priority,module) starters. when press import button, want read .csv file (with fixed name @ fixed directory) eg "1,2,3" - comma separating fields [delimiter] - , import sql server datab
Read more