View Complete Post
Hi I am having a report with report parameter.In report parameter user will enter the number(number should be <=9) and then related data will display on screen as well as the number which user entered.When user enters the number which less than 9
digit on report I need to display that number with leading zero on report.for example if user enter 12345 the related data will be displayed on report as well as I need to add 000012345 and display that number on report.I am using a textbox to display
the user selected number (parameter!number.value).So can any one say how to add leading zero in SSRS.In sql we can use SELECT REPLICATE(’0′, 10 – DATALENGTH(col1)) + col1 AS NAME
but can any one say how can we display in SSRS.
Thanks in advance
Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )
sql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IUN & "'"
'Add Error Trapping Later con = Server.CreateObject("ADODB.Connection") con.Open(data_source)
'Execute the SQL Command con.Execute(sql_select)
'Close the connection con.Close() con = Nothing
Now this works and I was able to put the value into a dropdown list box, but I need the value returned placed into a label such as:
I am trying to run an ssrs 2005 report and receiving the error above.
I want to run custom code in the CODE tab.
Here is my code
Public Function GetDayName (dayIn as integer) as String
Select Case dayIn
What is wrong with my code?
I have a requirment to display the page number on each page with a total number of records per page like this
Page 1 of 2 ---------------------------Total records: 11
Then on the last page I need to display the page number, the page Total and the grand total records fields like this:
Page 2 of 2--------------------------- Total records: 10 ---------------------------Grand Total records: 21
I tried different combinations but got errors like global execution field cannot be used in the report body, a text box could not be used in the report footer etc.
Thanks for your help.
Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....
Is it possible in SSRS 2005 or is there any other way to do it???
I have a web application where users can authenticate using either SiteMinder or Windows domain accounts. This is actually configured as two separate virtual directories within IIS 6. Both applications need to use the same instance of SSRS. Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?