field in the footer

Hello,

I am developing a statement for a dental practice. What I need to do is to list all the charges related to the patient and list patient name at the button of page so that she/he can tear it and return that part with the payment.

So I created a group based on patient name, and listed charges in the detail, now I need to list patient name at the footer but it says I can not use the field in the footer. How can I do this?

Ok. I used ReportItems!...
|||Yes it is one of the drawbacks with RS. We had to put copuright notes and some parameter values in the footer and couldnt do it due to the issue you stated. We eventually ended up moving eveything into the table footer in the body section of the RS. Thats the only workaround.|||I've just started using RS and this is one of the first things I've come across.
The one way to get around this is to create some fields in the body, and put your desired values in them. (I make the fields super small and invisible).
In the footer, you can reference the values in these fields.
So all in all, you get what you want, but it is a hacky way to do it.

Few repl questions

Dear friends,
I have some small questions related to the replication please see if you can
help me.
1. I want to add a article in the merge replicaiton which i can do with
sp_addmergearticle procedure but i want that the snapshot should
automatically run after the same. Please also suggest can user keep on
working while adding and rerunning the snapshot.
2. How can i drop the Article while the replication is on.
3. Which procedure will allow me to Chnage teh Defination of the fields
while the replication is on.
4. How can i drop the Column while replication is on.
Thanks and best regards
Sharad
Sharad,
to add the article, use sp_addmergearticle. This way, you can use
sp_start_job to initiate the snapshot agent.
to drop the article using transactional, use :
exec sp_dropsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
exec sp_droparticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
(for transactional).
For merge, this is not possible and you'd have to drop the publication to be
able to do it.
To change the field definition in SQL Server 2000 look at this:
http://www.replicationanswers.com/AddColumn.asp
In SQL Server 2005, this should help:
http://www.replicationanswers.com/AlterSchema2005.asp
To drop a column, look at sp_repldropcolumn
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)