Tuesday, March 27, 2012
HistoryID Problem?
Error: -2147221504
For ' snapshotID ' indicated parameter value does not correspond to the type of parameter.
I passed an empty String for the optional Value HistoryID.
I dont know where the problem is.
Can anybody help me ?
CODE:
Dim ReportName As String
Dim RenderFormat As String
Dim HistoryID As Variant
Dim DeviceInfo As String
Dim Parameters(2) As struct_ParameterValue
Dim Credentials() As struct_DataSourceCredential
Dim ShowHideToggle As String
Dim resultFile() As Byte
Dim resultEncoding As String
Dim resultMimeType As String
Dim resultParametersUsed() As struct_ParameterValue
Dim resultWarnings() As struct_Warning
Dim resultStreamIds() As String
Set RS = New clsws_ReportingService
ReportName = "/SampleReports/Employee Sales Summary"
RenderFormat = "mhmtl"
HistoryID = 0
DeviceInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
ShowHideToggle = ""
Set Parameters(0) = New struct_ParameterValue
Parameters(0).Name = "EmpID"
Parameters(0).Value = "38"
Set Parameters(1) = New struct_ParameterValue
Parameters(1).Name = "ReportMonth"
Parameters(1).Value = "6" ' June
Set Parameters(2) = New struct_ParameterValue
Parameters(2).Name = "ReportYear"
Parameters(2).Value = "2004"
resultFile = RS.wsm_Render( _
ReportName, _
RenderFormat, _
nil, _
DeviceInfo, _
Parameters, _
Credentials, _
ShowHideToggle, _
resultEncoding, _
resultMimeType, _
resultParametersUsed, _
resultWarnings, _
resultStreamIds)
thx for your helpSorry for double posting... but there was an error maeesage so i tryed again.sql
Sunday, February 26, 2012
Hiding SQL Server Reporting Services Header
manager UI to Certain Folders.
Is it possible to hide the header which display SQL Server Reporting
Services, Home, My Subscriptions etc.?
thxHave you tried simply using the ReportServer URL? //SERVERNAME/ReportServer/
Let me know if this helps...
-David.
"nkg" wrote:
> we published some reports and want to give user access to these via report
> manager UI to Certain Folders.
> Is it possible to hide the header which display SQL Server Reporting
> Services, Home, My Subscriptions etc.?
> thx
>
>
Friday, February 24, 2012
hiding folders and list view
Hello I have a few questions hoping someone can help
Any way to hide a report completely ? ie data source folders, subreports called from hyperlinks etc
Anyway off hiding the List view and restrict the user from selecting list view ?
Anyway off customising the reporting services top area which is in yellow and black ie put a logo in this area ?
thanks
Hi,
You cannot hide a report completly in the SSRS. It is not a problem to see the reports in details view. It is a communication issue with the end users not to use the subreports. Also, you cannot remove the "show details" button.
For custom look, you should create your ASP.NET application and use the ReportViewer control. In this case you can hide your reports
Regards,
Janos
|||Do you want to hide the report or subreports?
If report,why do you want to hide a report,when permissions can play a role in this task.
Do you want to show the hyperlink conditionally.you have the option to write act as hyperlink as a function in the navigation property fx itself.
Why not,you can place a picture in the header? make it as template and use it when ever you want