I have a crystal report im try to convert to sql reporting. This crystal rep
ort has a disclaimer banner which is a sub report which gets the text from t
he database. Also the sub report is in the footer.
Sql reports will not allow me to put a sub report/dataset in the footer or t
he header as i would like to do something
similar!!
I hate crystal so come on MS gives us the flexability we need!!!
Any ideas of workarounds etc
StuFirst thing is to change the subreport into a second dataset in the report.
You don't need a subreport for multiple queries. You could put the field in
a table footer, First(Fields!Dislaimer.Value, "Dataset2") and set the footer
to repeat on new pages.
The best place to post these types of questions is in the
microsoft.public.sqlserver.reportingsvcs newsgroup.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
"Stu" <s.dee@.cognatus.com> wrote in message
news:7AD51F5D-A7FA-4E80-9D05-2E826A676817@.microsoft.com...
quote:
> Hi,
> I have a crystal report im try to convert to sql reporting. This crystal
report has a disclaimer banner which is a sub report which gets the text
from the database. Also the sub report is in the footer.
quote:
> Sql reports will not allow me to put a sub report/dataset in the footer or
the header as i would like to do something
quote:|||Hi Brian,
> similar!!
> I hate crystal so come on MS gives us the flexability we need!!!
> Any ideas of workarounds etc
> Stu
>
I have tried that
And when i drag the field into the footer and compile it
says
the value for the textbox 'text_1' refers to a field. Fields cannot be
used int headers or footers
Stu
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Could you move this over to the reporting services newsgroup? There are more
people over there who can answer Reporting Services questions than this
group.
You actually can't put a field directly in the page footer. You can put it
in the body and then put a reference to it in the footer, e.g.
ReportItems!Textbox.Value.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
The Microsoft legal department would like me to remind you that this posting
is provided "AS IS" with no warranties, and confers no rights.
"stuart Dee" <s.dee@.cognatus.com> wrote in message
news:eRaIPfQ6DHA.2064@.TK2MSFTNGP11.phx.gbl...
quote:
> Hi Brian,
> I have tried that
> And when i drag the field into the footer and compile it
> says
> the value for the textbox 'text_1' refers to a field. Fields cannot be
> used int headers or footers
> Stu
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
No comments:
Post a Comment