| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2004-11-11 : 16:48:31
|
| I see page headers, I see group headers...But wheres the darn Report Header kind of like what Access has ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 16:51:00
|
| I just added another table to the top of the definition. This table doesn't have any grouping. But doing it this way, it won't repeat page to page.Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 16:52:21
|
| hmm ?So in the page header you have a table ? And you have set it to page break after this ?Tara, all I need is a report front cover page with some data from the database..but it should be only on the cover.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 16:57:21
|
| Not in a page header. In the body, I have two tables. The first one has no grouping and contains the data that I need for the header of the report. I then have another table that groups the data by date. So that, in essence, serves as the details. You can set a page break in the properties of the first table. This may not be what you want, but it's what I did.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 16:58:44
|
| Hmm...I dont know if this will work...Your "report header" only shows up on one single page ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 17:04:35
|
| Yep. I actually had to set the option to insert a page break before this table on the second table. It didn't work for me when I set page break after table on first table.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 17:19:29
|
| Ok I will look at this more tomorrow, RS is kinda buggy on some things, Ive noticed that too...You know what I really like..is being able to look at the XML like code of the RDL and modify the report right from there.I create all my parameters right from there...much easier.Jon |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 17:25:59
|
| Yeah I've noticed RS having issues. I am having to use CInt() in a few places to avoid some warnings or errors. It's a known problem. Mark (AjarnMark) mentions on his weblog that it's rumored there's SP2 coming out soon for RS. Hopefully, it's ready before we go to production with this. We're already in QA and Performance testing, but I'm able to work around everything so far. I just don't want to have to deal with this hack after hack approach to avoid RS bugs.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 17:45:51
|
| Ya I can tell MS was rushing some of their work, I'll admit I like it much more than crystal only cause I can actually follow it and it has a flow. I've been able to create some really nice reports...however I can see that some of the things thatMS worked on are buggy and not supported (calendar controls for datetime types, reuse of datasources across various reports, errors that dont really mean much). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-11 : 17:50:07
|
| Yeah the errors are horrid. I'm confused about "reuse of datasources across various reports". I only have one datesource that all of the reports access. You just have to set it up as shared and you can reuse it.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 17:51:06
|
| Sorry I meant the dataset not the datasources...I guess this part is even reusable since 99.9% of mine have been stored procedures.Bad vocab I have :-).Jon |
|
|
|
|
Report Header ?