September 25, 2007 at 5:45 am
Hi. This is my first post, so please go easy on me! 🙂
I am not a expert, but have always found that I can use SSRS for almost any reporting problems I have had. I have done some quite advanced reports, but in my latest task I am confused!
I am using SSRS 2005 on a SQL Server that is used for a Sage Line500 database.
They wanted a PO report. Easy. I have the lines on the order in a table and I have address lines and order no etc from the order header in the main body of the report above and below this. They enter the PO No as a parameter and the PO prints out as a very pretty report. Great! Everyone's happy. Except...
Now they want to re-print a range of PO's (Line500 does not allow this after intital printing). Okay - so I put a from and to range for PO Number.
Of course the table includes all data.
So I group and put a page break after.
Now I don't get any info from the body after page 1. After tearing out hair for ages find it's a bug in the viewer and when deployed it does show. Except it shows the same info on every page.
I can't put fields in page header and the body info doesn't seem to show records relating to the current table view.
What am I doing wrong? Is there a way? Am I (as I suspect) just being dumb and missing something?
Thanks very much in advance and sorry for wasting your time. Colin.
September 25, 2007 at 6:13 am
Actually I think I might have started working it out myself.
If I have a list with grouping and then place the table inside the list I think that might do it!
As I said - sorry for wasting everyone's time!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply