SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Displaying start and end dates in the report header


Displaying start and end dates in the report header

Author
Message
paucann
paucann
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 112
Hi,

As a follow up to my previous posting, my SRS report requires the start and end dates to be displayed in the header. I have these values available as fields in my dataset. But I get an error that I can't display fields in the header. Is this right? Does anyone know how I can do this so that my start and end dates can display in the report header?

thanks,
Paul
Dave K-596875
Dave K-596875
Say Hey Kid
Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)Say Hey Kid (700 reputation)

Group: General Forum Members
Points: 700 Visits: 535
Are they parameters? If so, use the parameters object (Parameters! .Value).
Niraj-627298
Niraj-627298
SSC-Addicted
SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)

Group: General Forum Members
Points: 495 Visits: 719
Hi...

If you are using SSRS 2005, then it is not possible to use Fields Values in Header / Footer(being a limitation in SSRS 2005)......So...to make it work..you can do 1 thing...you can access concerned values inside two textboxes any where on Report Body, make them in visible and refer those in Report Header / Footer...using ReportItems property...

I hope, it may help you...Smile

Thanks,

Niraj
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search