Report Being Generated Never Shows Second Report
Feb 23, 2007
I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?
Thanks in advance.
View 4 Replies
ADVERTISEMENT
Nov 29, 2006
I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:
1. Deployed the report using Visual Studio
2. updated the rsreportserver.config file with the following entry:
<ReportItems>
<ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
</ReportItems>
3. Updated the rssrvpolicy.config file with the following entry.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
</CodeGroup>
I've also tried using the StrongNameMembershipCondition with no better results.
4. The dll and its dependencies are copied to the bin directory of the report server.
5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.
This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.
View 6 Replies
View Related
Apr 26, 2006
I get this error message:
Semantic query execution failed.
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
The report model does have a perspective.
Anyone else seen this?
View 9 Replies
View Related
Mar 6, 2007
I followed the tutorial http://msdn2.microsoft.com/en-us/library/ms167305.aspx with no problem but when I tried to preview the report the green circle just kept spinning and spinning.
I'm able to execute the command under the data tab with no problems. I'm able to view built in reports for SQL Server 2005. I've tried restarting Visual Studio and the entire PC but the report will still no generate.
Thoughts or ideas about what my problem is?
SQL Server 2005 SP1
Thanks,
Mike
View 3 Replies
View Related
Oct 10, 2007
The last page of the report has a table or rectangle (tried both) which is supposed to be invisible based on a parameter. However, the page still shows up with only the header! Apparently the report knows that the next element (table or rectangle) has to be on a new page, and only too late figures out that the element is invisible.
Anybody else encountered this, or has a solution?
Thanks
View 2 Replies
View Related
Aug 28, 2007
Hi
I have a windows application. I am using following code right after setting the LocalReport ReportPath. Report rendering is too slow if use following line of code and Report viewer does not show spiny and the text that says €œReport is being generated.€?
Me.ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout)
Me.ReportViewer1.ZoomMode = ZoomMode.Percent
Me.ReportViewer1.ZoomPercent = 80
Please advise how can make it fast and show spiny.
Thanks in advance.
View 8 Replies
View Related
Aug 17, 2006
I have created a report and deployed it successfully to a seperate machine with SSRS on. Both my dev machine and the SSRS machine are in the same workgroup. I can then Browse to the Report Manager though IE and click & run the report (The connection is using integrated security). The report requires a single parameter to be entered which once done works successfully. The report has a single table, an inbedded image and a few static fields in the report header.
If I however add a report viewer control to an aspx test form all is not well. As soon as the page opens I am prompted to enter the parameter which is good news as it shows there has been some communication with the SSRS metabase. I then click the view report button. Using Profiler I have proved that the report Stored Proc. is running with the correct parameter value. The report viewer however seems to hang and only displays "Report is being generated" without displaying the results. It does this even with a timeout set of 1000ms.
I don't think this is a security issue as both the Report Manager works and the test form prompts me for the parameter and effectively runs the report SP. I can only assume it is a problem with returning the report to the browser.
Does anyone have any insight?
Regards
Anthony Kay
View 3 Replies
View Related
Jan 16, 2008
Hi,
I have a report which doesn't work. It has a datatset based on a store procedure. The store-procedure take 10 to 50 second to execute, depending on the parameters.
But, I can't never see my report as i wait more than 10 minutes and it's never generated.
So, I have think that maybe it could be because of the matrix inside the report, so I have try to create another report which have the same dataset but with nothing inside, just a textbox, and it doesn't work too !!
So now, i'm very disapointed and I don't know what to do !
Someone can help me please ? It's very important.
Thank you.
View 2 Replies
View Related
Oct 29, 2007
I have created a report with a stored proc which takes a parameter whose default value is null. Now when I run my stored proc in Enterprise Manager without any params I get 4 rows otherwise with proper parameter I get 2 rows.
Now I set the params value to allow for Null and blank values. When I run the report if I provide parameter value it works fine but if i try to run it without any param it shows an empty report while the stored proc running without params shows 4 rows.
I have earlier sucessfully created reports where stored procs had 4 params out of which 3 where defaulted to null. And so I set the allow nulls, Allow Blanks values to be true for those params in Rep services. So when I selected value for 1st param and ran the report I got the desired report. But this time I have only one param which can be null. But its not working.
Thanks in advance.
View 1 Replies
View Related
Mar 9, 2007
Hi all. My name is Guilherme and I'm a Braziliam software developer.
I've installed on my computer all the software required to work with MS SQL RS. I log on this computer using my domain user. and a few days ago i needed to change my password (network policy)
Now, when I open the adress http://localhost/reports on my computer, I can't see the installed reports, neither the configuration page.
What should I do?
Thanks in advance.
View 1 Replies
View Related
Feb 14, 2007
Is it possible to reposition the "Report is being generated" graphic?
I have most of my reports set to 1000 px by 1000 px which forces the graphic off of the screen. I would like to be able to see it without having to scroll to it.
Also, is there any way to change the properties of that image? I would think a progress bar that actually showed how far along the report was before completion would be better.
View 4 Replies
View Related
Feb 20, 2006
Hello,
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,
View 17 Replies
View Related
Mar 13, 2008
Hi,
I want to remove default animated gif report is being generated, how can i achieve it when i upload the rdl to share point, Need to remove actions and print option avialble when i upload my rdl to share point.
Regards,
Navin
View 1 Replies
View Related
Aug 7, 2015
I have deployed a report in our server. After few days I tried accessing the report in Internet Explorer. It shows old data. Then I verified the .rdl file in BIDS. There it show actual data. So I deleted the Deployed report in Report manager and done the fresh report deployment.But Still it shows wrong / Incorrect data.Then I tried accessing the same Report link through Mozilla Browser.There it shows the perfect value.
All users are accessing the report in IE only. How to fix this issue.
Additional Info: The same link works fine in One of my colleague system (IE). Then I verified his IE version. He was using IE 11.But I'm also using same version.
Then I verified with some other systems. There they found the same issue which I faced. They were also using IE 11.
View 11 Replies
View Related
Jul 3, 2007
Code Snippet
' DataSet element
writer.WriteStartElement("DataSets")
writer.WriteStartElement("DataSet")
writer.WriteAttributeString("Name", Nothing, "DataSet1")
' Query element
writer.WriteStartElement("Query")
writer.WriteElementString("DataSourceName", "DataSource1")
writer.WriteElementString("CommandType", "Text")
writer.WriteElementString("CommandText", m_commandText)
writer.WriteElementString("Timeout", "30")
writer.WriteEndElement() ' Query
writer.WriteStartElement("Parameters")
writer.WriteStartElement("Parameter")
writer.WriteAttributeString("Name", Nothing, "GlLayoutNo")
writer.WriteEndElement() ' Parameter
writer.WriteEndElement() ' Parameters
' Fields elements
writer.WriteStartElement("Fields")
Dim fieldName As String
For Each fieldName In m_fields
writer.WriteStartElement("Field")
writer.WriteAttributeString("Name", Nothing, fieldName)
writer.WriteElementString("DataField", Nothing, fieldName)
writer.WriteEndElement() ' Field
Next fieldName
' End previous elements
writer.WriteEndElement() ' Fields
writer.WriteEndElement() ' DataSet
writer.WriteEndElement() ' DataSets
In the above code, the XML parser does not understand the Parameters element. I've also tried ReportParameters as the name of the element. I don't seem to understand why, because in the SQL data tab, Parameters is a subelement of DataSet. Why am I getting this error and how do I programmatically specify that I want a report created on the fly to have parameters?
Deserialization failed: The element 'DataSet' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'Parameters' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Fields http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Query http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:CaseSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Collation http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:AccentSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:KanatypeSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:WidthSensitivity http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Filters ##other:*'. Line 21, position 8.
View 1 Replies
View Related
Sep 1, 2015
I need to calculate the success rate of our OS Patch deployments. the data from system is stored in SQL with corresponding states (installed, missing, ...)
I would need to provide monthly report that shows how successful the deployment was for particular patchgroup. I have the following 2 dummy tables (just used as example)
table5 ==> Table containing patch groups + patches
table6 ==> Table with machines names, patches and patch state
select * from table5
pgrouppatch
GROUP1PATCH1
GROUP1PATCH2
GROUP1PATCH3
GROUP1PATCH4
[Code] ....
Result would be
pgroup install missing
group1 80% 20%
group2 50% 50%
group3 55% 45%
Ideally I would like to do this in T-SQL but if necessary can also do this in .NET Function. Only mention this but both Patchgroup and machines are dynamic each month can be different.
below are the sql scripts to create tables and populate with data
CREATE TABLE [dbo].[table5](
[pgroup] [varchar](128) NOT NULL,
[patch] [nvarchar](128) NOT NULL
)
CREATE TABLE [dbo].[table6](
[machinename] [varchar](128) NOT NULL,
[Code] ...
View 9 Replies
View Related
Jul 7, 2015
We run std 2008.  In my ssrs log I see this for one of our most critical reports...
library!ReportServer_0-64!2244!07/07/2015-08:24:53:: Call to GetPermissionsAction(/somedirectory/somedirectory1).... which I assume is an indication of a report starting to render by first checking permissions.
Around the time my user says he still saw the revolving arrow and he stopped the report because he felt it was running too long, I see...
webserver!ReportServer_0-64!1dbc!07/07/2015-08:54:44:: i INFO: Processed report. Report='/somedirectory/somedirectory1/importantreport', Stream=''
How can it be true that he stopped it and ssrs reports that it processed the report?
About 4 minutes later I see this entry in the log...
webserver!ReportServer_0-64!15e4!07/07/2015-08:58:34:: i INFO: Processed report. Report='/somedirectory/somedirectory1/importantreport', Stream=''
Which processed report message is right? Could there be multiples cuz of subreports? I see a number of errors and exceptions around these same times but do not know how to tie either to a specific report. Is there a way?
View 3 Replies
View Related
May 16, 2006
Hello
I have created a report that works how I want it in the visual studio 2003 designer. I have deployed it to our test box (sql server 2k, reporting services with sp2) and when we preview the report, there is a giant white space between the graph in the report and the matrix object below it. This white space was not in the designer. It only shows when previewing the report. If you print from the report manager, it does not print the white space.
Is there a way to remove it from the report manager when the report is previewed? I am sure users will complain when they see this.
Thanks.
Ben
View 2 Replies
View Related
Jun 11, 2015
I have a rdl where its working fine while report preview, for parameter  it shows <Select a value> only first select . for next select its just showing dropdown list of values .
How can i get <select a value> for all selections. I referred few links which says only for first select you will get <select a value> ,from second select it just shows dropdown.
If we want <select a value> again then we should go back design part and then preview again. But I don't want. What is the possible way to see <select a value> for every select without going back to design.
View 3 Replies
View Related
Dec 28, 2006
I'm trying to create a .htm file (a report from query results) on a webserver using SQL code.
TBL_LOGGEDIN_USERS_PERHOUR has just two columns. It gives the number of users logging in for hour.
HOURdatetime
NUMBER_OF_USERSsmallint
HOURNUMBER_OF_USERS
2006-12-28 15:00:00.000 15
2006-12-28 14:00:00.000 29
2006-12-28 13:00:00.000 30
2006-12-28 12:00:00.000 23
2006-12-28 11:00:00.000 23
2006-12-28 10:00:00.000 21
2006-12-28 09:00:00.000 31
2006-12-28 08:00:00.000 30
This is the actual code which generates one .htm file every 24 hours with the count of hourly logins. So the entries (as per the below logic) start at 12:00 AM everyday and end at 11:00 PM. The catch is - the entries come up fine upto 10:00 PM. The '11:00 PM entry' is missing in all the .htm files. I tried several options and later, I 'force added' an ELSE IF condition especially for the 11:00 PM case, indicated in the code below but it doesn't seem to help...
Also, I'm not really sure if this is a row limitation in the .htm file - like x no: of rows per .htm file.
Am I missing something here?.. Please advise. Let me know if I'm not clear. Thank you.
CREATE PROC CONDOR_CLIENT_LOGINS_PERHOUR
AS
BEGIN
IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[DBO].[TBL_CUSTOM_LOGINSPERHOUR]')
AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
DROP TABLE [DBO].[TBL_CUSTOM_LOGINSPERHOUR]
CREATE TABLE [DBO].[TBL_CUSTOM_LOGINSPERHOUR] (
ROW1 NVARCHAR (30),
ROW2 NVARCHAR(30)
) ON [PRIMARY]
DECLARE @FLAG SMALLINT
DECLARE @REPFLAG SMALLINT
SET @FLAG = 0
SET @REPFLAG = 0
IF DATEPART(HH,GETDATE()) = 0
BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1],
CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR1 FROM TBL_LOGGEDIN_USERS_PERHOUR
WITH (NOLOCK)
WHERE HOUR = DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0)
ORDER BY HOUR
SET @FLAG = 1
END
-- this is added for 11:00 PM entry START
ELSE IF DATEPART(HH,GETDATE()) = 23
BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1],
CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR2 FROM TBL_LOGGEDIN_USERS_PERHOUR
WITH (NOLOCK)
WHERE HOUR >= DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0)
ORDER BY HOUR
SET @FLAG = 2
END
-- the above is added for 11:00 PM entry END
ELSE
BEGIN
SELECT CONVERT(NVARCHAR,HOUR,100)AS [ROW1],
CONVERT(NVARCHAR,NUMBER_OF_USERS) AS [ROW2] INTO #TEMP_LOGINSPERHOUR3 FROM TBL_LOGGEDIN_USERS_PERHOUR
WITH (NOLOCK)
WHERE HOUR >= DATEADD(DAY,(DATEDIFF(DAY,0,GETDATE())),0)
ORDER BY HOUR
END
INSERT INTO TBL_CUSTOM_LOGINSPERHOUR
SELECT 'HOUR', 'NUMBER OF CLIENT LOGINS'
UNION ALL
SELECT '' , ''
UNION ALL
SELECT '' , ''
IF @FLAG = 1
BEGIN
INSERT INTO TBL_CUSTOM_LOGINSPERHOUR
SELECT * FROM #TEMP_LOGINSPERHOUR1
SET @REPFLAG = 1
END
ELSE IF @FLAG = 2
BEGIN
INSERT INTO TBL_CUSTOM_LOGINSPERHOUR
SELECT * FROM #TEMP_LOGINSPERHOUR2
SET @REPFLAG = 2
END
ELSE
BEGIN
INSERT INTO TBL_CUSTOM_LOGINSPERHOUR
SELECT * FROM #TEMP_LOGINSPERHOUR3
END
SELECT '' , ''
UNION ALL
SELECT '' , ''
DECLARE @REPPATH AS NVARCHAR(50)
SET @REPPATH = '\TKESTIIS5LOGINSPERHOUR' + REPLACE(CONVERT(NVARCHAR(10), GETDATE(), 101),'/', '') + '.HTM'
EXEC SP_MAKEWEBTASK @REPPATH , 'SELECT * FROM TBL_CUSTOM_LOGINSPERHOUR' ,
@COLHEADERS = 0 , @RESULTSTITLE = 'Client Logins Per Hour Report',
@WEBPAGETITLE = 'Client Logins Per Hour Report' ,@LASTUPDATED = 1
DROP TABLE TBL_CUSTOM_LOGINSPERHOUR
IF @REPFLAG = 1
DROP TABLE #TEMP_LOGINSPERHOUR1
ELSE IF @REPFLAG = 2
DROP TABLE #TEMP_LOGINSPERHOUR2
ELSE
DROP TABLE #TEMP_LOGINSPERHOUR3
END
View 6 Replies
View Related
Apr 16, 2007
I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.
Specifics:
=========
I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.
Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.
Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.
By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.
View 1 Replies
View Related
Jul 9, 2013
I am creating a SSRS report which would be executed by User manually through ReportServer URL.User would be generating the SSRS report for different Customer ID based on ad-hoc basis.
I am passing CustomerID as input parameter to the report. Is there any way to get the manually generated SSRS report name as 'Report_CustomerID_TodayDate.xls'.
E.g.If User is generating report for Customer ID 123 today then report name should be 'Report_123_07092013.xls'
View 2 Replies
View Related
Apr 23, 2008
i need to get the result of two different queries into 2 different sheets of the same excel file while exporting a report to excel using reporting services..
somebody please help
View 1 Replies
View Related
Jun 16, 2006
SQL server 2005 express reporting problem.
error message:
This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service
I got this error message when I try to connect to database hosted in another PC running SQL server 2000.
Is it true that SQlL server Express can only use Local Database Engine to host the database?
View 5 Replies
View Related
Dec 9, 2014
I have the below data. I need to produce a report that shows customer and total sales who had the max sales by year.
Order ID Cust ID Year Sales
O1 C1 2000 100
O2 C1 2000 150
O1 C2 2000 50
O1 C1 2001 150
O2 C3 2001 200
Report:
Cust ID Year Sales
C1 2000 250
C3 2001 200
View 1 Replies
View Related
Sep 9, 2015
I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my .rdl file to be use as my sub report.
View 5 Replies
View Related
Jun 30, 2006
After I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly?
The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type.
Any suggestions would be appreciated. Thanks
View 3 Replies
View Related
May 3, 2007
How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.
View 7 Replies
View Related
Feb 6, 2008
Hi,
When i select datasource in Report Builder, i am able to see all the available DataSources.
Eg: I have selected one datasource from the list and which has 3 tables(table1, table2, table3) associated to that datasource.
when i drag and drop table1 fields to report, i am not able to see the other 2 tables(table2 & table3)
Is there any property or relationship do i need to maintain?
Thanks,
SR.
View 5 Replies
View Related
Jul 1, 2015
I have a SQL Agent job that runs at 4:15 in the morning. The job has 5 steps, each step only runs if the preceding step succeeds. The second step, which calls an SSIS package that does the main processing, appears to finish as it goes on to the next step; however, when looking in 'View History' there are 2 entries for this step - the first one shows it as still running (Circled Green Arrow) but with a start and end time. The second entry says the job succeeded.
I have been seeing conflicts, such as deadlocks, with later jobs. I suspect this job is causing the conflicts - maybe the package is still running in the background instead of having actually completed?
what conditions a job step my be showing in the job history as both running AND completed successfully?
View 6 Replies
View Related
Sep 6, 2007
I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:
sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'
I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:
create view MyExcel
as
select * from XL_SPS_1...Sheet1$
Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."
I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?
Thanks,
--Stan
View 3 Replies
View Related
Oct 9, 2015
I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting.Â
View 6 Replies
View Related
Apr 30, 2007
Hi,
I have created a report with the report server project template.
the report is created from stoked procedure having defaut input parameters.
With visual studio, i publish my report on reportserver. whenever i access to my report on this url :
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render. the created report is with the default parameters.
I would like to know if i can transmet parameters for the stocked procedure to build the report with the request i want.
I tried to put parameter directly in the url in this way
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project4%2fReport4&rs:Command=Render&@region='toto'
but without success.
my error message is that one
An attempt was made to set a report parameter '@region' that is not defined in this report. (rsUnknownReportParameter)
My stocked procedure is :
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[akli] @region varchar ='m'
as
select * from dbo.Report2 where region=@region
The request used to buid the report ?
DECLARE @region varchar
EXECUTE dbo.akli @region
What is wrong in that ?
Thanks for your help.
Arioule
View 1 Replies
View Related
