Resetting Key Column Numeration from SQL Tables

I used a lot of fictitious data in order to test the code of my web site. But I noticed that when I deleted all fictitious data from the tables, the primary key columns keep creating automatically numbers that are above the last one before all data was erased instead of starting again from number 1. How do I reset this automatic numeration in order to restart from 1 again ?

You have to use the DBCC Checkpoint command

Refer this: http://www.sqlteam.com/item.asp?ItemID=8003

|||Check out BOL for DBCC CHECKIDENT command.|||

Another way to do this is to use Truncate Table Command rather than delete.

This will reset identity.

Reseting the unique id if a table.

I'm building a web site. there is a database.

I've set a primary key and unique of a field.also I set it to auto numbering.

Everytime I insert a record , that field will increase 1 (type bigint , start from 1).

After lots time of inserting record , the id going to be larger number.. I wondering how can I reset that to zero?

Run query Truncate Table YuorTableName

Requirements for installing this product on a W2003 server?

I wanted to try a test drive of the product on my new web server, but I get
a warning that it won't install. Warning is worthless because it says that
something isn't present, but fails to mention what that is. No # to cross
reference.
So what do you need to have on a fresh install of W2003 ?
This is a web box only, and my SQL boxes all have no IIS installed.
TIA
__StephenSystem requirements can be found at
http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx
Hope this helps
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"__Stephen" wrote:
> I wanted to try a test drive of the product on my new web server, but I get
> a warning that it won't install. Warning is worthless because it says that
> something isn't present, but fails to mention what that is. No # to cross
> reference.
> So what do you need to have on a fresh install of W2003 ?
> This is a web box only, and my SQL boxes all have no IIS installed.
> TIA
> __Stephen
>
>

Required Security for Report Viewer on Windows 2003 SP1 Web Server

When trying to run a local report using the RS Report Viewer for VS
2005 we get the below exception when the User Account for the
Application Pool we are using is not in the Administrators Group of the
web server.
Does anybody have any suggestions as to what specific security is
needed to use the Report Viewer?
Could this be because we built the application as a "Web Project"
instead of a "Web Site"?
Microsoft.Reporting.WebForms.LocalProcessingException: An error
occurred during local report processing. -->
Microsoft.Reporting.DefinitionInvalidException: The definition of the
report 'Main Report' is invalid. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred while compiling expressions. Native
compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
could not be found'. -- End of inner exception stack trace -- at
AMR.AdvertiserClientList.RefreshReport() in C:\Documents and
Settings\god\My Documents\Visual Studio
2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 192 at
AMR.AdvertiserClientList.RUNREPORT_Click(Object sender, EventArgs e) in
C:\Documents and Settings\God\My Documents\Visual Studio
2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 50 ::
InnerException: Microsoft.Reporting.DefinitionInvalidException: The
definition of the report 'Main Report' is invalid. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred while compiling expressions. Native
compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
could not be found'.This error is also logged in the system event viewer, however granting
access NETMAN in the DCOM manager only keeps the errors from showing
and does not fix the problem. The CLSID refers to tthe Network
Connection Manager Class (under the NETMAN application).
The application-specific permission settings do not grant Local
Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user AMI\srvAcctAppAccessDEV SID
(S-1-5-21-2975352776-793034493-3225607600-10632). This security
permission can be modified using the Component Services administrative
tool.
tfelber@.gmail.com wrote:
> When trying to run a local report using the RS Report Viewer for VS
> 2005 we get the below exception when the User Account for the
> Application Pool we are using is not in the Administrators Group of the
> web server.
> Does anybody have any suggestions as to what specific security is
> needed to use the Report Viewer?
> Could this be because we built the application as a "Web Project"
> instead of a "Web Site"?
> Microsoft.Reporting.WebForms.LocalProcessingException: An error
> occurred during local report processing. -->
> Microsoft.Reporting.DefinitionInvalidException: The definition of the
> report 'Main Report' is invalid. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> An unexpected error occurred while compiling expressions. Native
> compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
> could not be found'. -- End of inner exception stack trace -- at
> AMR.AdvertiserClientList.RefreshReport() in C:\Documents and
> Settings\god\My Documents\Visual Studio
> 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 192 at
> AMR.AdvertiserClientList.RUNREPORT_Click(Object sender, EventArgs e) in
> C:\Documents and Settings\God\My Documents\Visual Studio
> 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 50 ::
> InnerException: Microsoft.Reporting.DefinitionInvalidException: The
> definition of the report 'Main Report' is invalid. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> An unexpected error occurred while compiling expressions. Native
> compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
> could not be found'.|||Finally figured it out.
The configurable identity that our application pool was using under
IIS 6.0 needed read/write access to the c:\Windows\Temp directory.
(Explains why we could get this to work when the account was part of
the Administrators or Power Users Group). I suppose this is to give it
temp space when rendering large reports.
Hopefully this helps somebody else out one day.
tfelber@.gmail.com wrote:
> This error is also logged in the system event viewer, however granting
> access NETMAN in the DCOM manager only keeps the errors from showing
> and does not fix the problem. The CLSID refers to tthe Network
> Connection Manager Class (under the NETMAN application).
> The application-specific permission settings do not grant Local
> Activation permission for the COM Server application with CLSID
> {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> to the user AMI\srvAcctAppAccessDEV SID
> (S-1-5-21-2975352776-793034493-3225607600-10632). This security
> permission can be modified using the Component Services administrative
> tool.
>
> tfelber@.gmail.com wrote:
> > When trying to run a local report using the RS Report Viewer for VS
> > 2005 we get the below exception when the User Account for the
> > Application Pool we are using is not in the Administrators Group of the
> > web server.
> >
> > Does anybody have any suggestions as to what specific security is
> > needed to use the Report Viewer?
> >
> > Could this be because we built the application as a "Web Project"
> > instead of a "Web Site"?
> >
> > Microsoft.Reporting.WebForms.LocalProcessingException: An error
> > occurred during local report processing. -->
> > Microsoft.Reporting.DefinitionInvalidException: The definition of the
> > report 'Main Report' is invalid. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > An unexpected error occurred while compiling expressions. Native
> > compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
> > could not be found'. -- End of inner exception stack trace -- at
> > AMR.AdvertiserClientList.RefreshReport() in C:\Documents and
> > Settings\god\My Documents\Visual Studio
> > 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 192 at
> > AMR.AdvertiserClientList.RUNREPORT_Click(Object sender, EventArgs e) in
> > C:\Documents and Settings\God\My Documents\Visual Studio
> > 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 50 ::
> > InnerException: Microsoft.Reporting.DefinitionInvalidException: The
> > definition of the report 'Main Report' is invalid. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > An unexpected error occurred while compiling expressions. Native
> > compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb'
> > could not be found'.

Request a web page from SQL Server

Hi,

I want to request a webpage from sql server every hour.

I tried to make a job which contains a single ActiveX step.
I select VBScript and type

Dim Http
Set Http = CreateObject("Microsoft.XMLHTTP")
Http.Open "GET", "http://localhost/updater_watch.aspx", False
Http.Send
Set Http = Nothing

I set a schedule and on every execution I get an error in the event log.

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/11/2003
Time: 8:15:00 PM
User: N/A
Computer: NEXUS
Description:
SQL Server Scheduled Job 'updater' (0x444D7F519E70534C9EF81B1570382AEE) - Status: Failed - Invoked on: 2003-08-11 20:15:00 - Message: The job failed. The Job was invoked by Schedule 1 (s1). The last step to run was step 1 (invoke).

Is this the right way to do this task? When I execute the VBScript without the sql server, it runs without a problem.

Thanks, PanayotWhy not set it up as a ongoing job?|||Thanks for the reply garrydawkins,

that is what I have done.
I open eterprise manager and go to management-sql server agent-jobs-new job.
Then create the job, set a its type to activex, make a schedule to execute it every hour. it executes but exits with error. I suspect that it cannot create the xmlhttp object properly in the VB code.

If I only leave two simple statements:

dim somevar
set somevar = nothing

then the job exits with success.

Reprot description not getting updated.

I publish an RDL to report server using web service, then later i have a
modified RDL which has the the report description changed. I republish with
"Overwrite" on my existing reprot using webservice. The description is not
getting updated in report manager.
If i edit the new report form report manager and look at the rdl it show the
new description but it will always dispalys the old description in the
description textbox.
Any idea how i could force it to update?Try manually deleting the description via the report manager interface and
then re-deploy.
Colin
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>I publish an RDL to report server using web service, then later i have a
> modified RDL which has the the report description changed. I republish
> with
> "Overwrite" on my existing reprot using webservice. The description is not
> getting updated in report manager.
> If i edit the new report form report manager and look at the rdl it show
> the
> new description but it will always dispalys the old description in the
> description textbox.
> Any idea how i could force it to update?|||Users cannot access report manager. They have to do this through our custom
interface that uses webservice to update reports.
"Microsoft" wrote:
> Try manually deleting the description via the report manager interface and
> then re-deploy.
> Colin
>
> "vRam" <vRam@.discussions.microsoft.com> wrote in message
> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
> >I publish an RDL to report server using web service, then later i have a
> > modified RDL which has the the report description changed. I republish
> > with
> > "Overwrite" on my existing reprot using webservice. The description is not
> > getting updated in report manager.
> >
> > If i edit the new report form report manager and look at the rdl it show
> > the
> > new description but it will always dispalys the old description in the
> > description textbox.
> >
> > Any idea how i could force it to update?
>
>|||Delete and redeploy is the only way. I assume through the web service you
can delete it as part of the deploy process.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:9E62EE10-0652-4E70-BFD5-54FB410AAE70@.microsoft.com...
> Users cannot access report manager. They have to do this through our
> custom
> interface that uses webservice to update reports.
>
> "Microsoft" wrote:
>> Try manually deleting the description via the report manager interface
>> and
>> then re-deploy.
>> Colin
>>
>> "vRam" <vRam@.discussions.microsoft.com> wrote in message
>> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>> >I publish an RDL to report server using web service, then later i have a
>> > modified RDL which has the the report description changed. I republish
>> > with
>> > "Overwrite" on my existing reprot using webservice. The description is
>> > not
>> > getting updated in report manager.
>> >
>> > If i edit the new report form report manager and look at the rdl it
>> > show
>> > the
>> > new description but it will always dispalys the old description in the
>> > description textbox.
>> >
>> > Any idea how i could force it to update?
>>

Repost: Calculated default parameters not visible in Web UI

Repost of a question / bug I reported one week ago. As I am an MSDN
universal member, I think I have the right of an MS employee answer.
I want to set report parameters to the first day of the previous month.
In order to do so, I calculate a parameter value by entering the
following into the Report Parameter Dialog (Default Values - Non
Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
This seems to work fine. But the Web UI doesn't display the standard
value if I go to Report Properties - Parameters. Instead, only a check
mark is displayed in the "Has default value" checkbox, the "default
value" textbox is empty. If I click on "apply", I get an error "a value
has to be supported".
If I type in the same calculation function again into the text box, I
get the exception "rsReportParameterTypeMismatch".
What I actually want to do: To create multiple linked reports with
differing calculated standard values, e.g. previous week, previous
month, previous day. If I can't change to calucation formula in the Web
UI interface, it seems there is no way of doing this.
Am I missing something here, or is that a bug? How can I accomplish this?
Thanks for any help
UrsHi, Urs
Please check the list of newsgroups which are supported as part of the MSDN
program at http://msdn.microsoft.com/newsgroups/managed/. This newsgroup
is not currently part of the program and hence posts here are no eligible
for our response commitment.
I hope this clarifies things for you
John Eikanger
Microsoft Developer Support
This posting is provided ?AS IS? with no warranties, and confers no rights.
--
| Date: Wed, 29 Sep 2004 12:18:28 +0200
| From: Urs Eichmann <ursli@.online.nospam>
| Subject: Repost: Calculated default parameters not visible in Web UI
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Repost of a question / bug I reported one week ago. As I am an MSDN
| universal member, I think I have the right of an MS employee answer.
|
| I want to set report parameters to the first day of the previous month.
| In order to do so, I calculate a parameter value by entering the
| following into the Report Parameter Dialog (Default Values - Non
| Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
|
| This seems to work fine. But the Web UI doesn't display the standard
| value if I go to Report Properties - Parameters. Instead, only a check
| mark is displayed in the "Has default value" checkbox, the "default
| value" textbox is empty. If I click on "apply", I get an error "a value
| has to be supported".
|
| If I type in the same calculation function again into the text box, I
| get the exception "rsReportParameterTypeMismatch".
|
| What I actually want to do: To create multiple linked reports with
| differing calculated standard values, e.g. previous week, previous
| month, previous day. If I can't change to calucation formula in the Web
| UI interface, it seems there is no way of doing this.
|
| Am I missing something here, or is that a bug? How can I accomplish this?
|
| Thanks for any help
| Urs
|

Repost: Calculated default parameters not visible in Web UI

Repost of a question / bug I reported one month ago. I try it again
since as of 10/13/2004, this is a MSDN Managed newsgroup, so I hope I'll
receive an answer from an MS employee.
I want to set report parameters to the first day of the previous month.
In order to do so, I calculate a parameter value by entering the
following into the Report Parameter Dialog (Default Values - Non
Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
This seems to work fine. But the Web UI doesn't display the standard
value if I go to Report Properties - Parameters. Instead, only a check
mark is displayed in the "Has default value" checkbox, the "default
value" textbox is empty. If I click on "apply", I get an error "a value
has to be supported".
If I type in the same calculation function again into the text box, I
get the exception "rsReportParameterTypeMismatch".
What I actually want to do: To create multiple linked reports with
differing calculated standard values, e.g. previous week, previous
month, previous day. If I can't change to calucation formula in the Web
UI interface, it seems there is no way of doing this.
Am I missing something here, or is that a bug? How can I accomplish this?
Thanks for any help
UrsHi, Urs
Please refer to my response to your post on the 29th:
http://msdn.microsoft.com/newsgroups/managed/default.aspx?&lang=en&cr=US&gui
d=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=290388f9-b
627-4ffe-bb36-a0104a6e62ae&mid=b0ff2328-8f9e-48e9-8466-13d6395c5135
Since then microsoft.public.sqlserver.reportingsvcs has been added to the
newsgroups included in the MSDN managed newsgroups program. I have
forwarded your post to the attention of the support team.
John Eikanger
Microsoft Developer Support
This posting is provided ?AS IS? with no warranties, and confers no rights.
--
| Date: Tue, 19 Oct 2004 12:36:11 +0200
| From: Urs Eichmann <ursli@.online.nospam>
| Subject: Repost: Calculated default parameters not visible in Web UI
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Repost of a question / bug I reported one month ago. I try it again
| since as of 10/13/2004, this is a MSDN Managed newsgroup, so I hope I'll
| receive an answer from an MS employee.
|
| I want to set report parameters to the first day of the previous month.
| In order to do so, I calculate a parameter value by entering the
| following into the Report Parameter Dialog (Default Values - Non
| Queried): =New Date(Now.Year,Now.Month,1).AddMonths(-1)
|
| This seems to work fine. But the Web UI doesn't display the standard
| value if I go to Report Properties - Parameters. Instead, only a check
| mark is displayed in the "Has default value" checkbox, the "default
| value" textbox is empty. If I click on "apply", I get an error "a value
| has to be supported".
|
| If I type in the same calculation function again into the text box, I
| get the exception "rsReportParameterTypeMismatch".
|
| What I actually want to do: To create multiple linked reports with
| differing calculated standard values, e.g. previous week, previous
| month, previous day. If I can't change to calucation formula in the Web
| UI interface, it seems there is no way of doing this.
|
| Am I missing something here, or is that a bug? How can I accomplish this?
|
| Thanks for any help
| Urs
||||Hi Uri,
Thanks for your post.
From your descriptions, I understood that you cannot set the default value
in the Web UI even you have defined it in Report Designer. Have I
understood you? Correct me if I was wrong.
Based on my knowledge, unfortuantely, this is an known issue of us. It will
only work when set in Report Designer. The latest news from development
team is that they are working on this and no hotfix available now. I am
afraid you will have to do the settings in the Report Designer.
I am sincerely sorry for any inconvenience it may cause for your business
and thank you for your patience and corperation. If you have any questions
or concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Mingqing,
Yes, you understood me correctly. What I want to do is design one report
and use it multiple times with different default values for the selection
i.e.
Report #1 Sales Current Month
report #2 Sales Current Month -1
report #3 Sales Current Month -2
...
report #12 Sales Current Month -11
...
I want to design only one report, and use it with different default
values, using a linked report. With the current implementation it seems
necessary to copy the report 11 times in the Designer and set the
default values there... of course I'll have to redo this every time I
change my report. A nightmare to maintain!
As I understand you, I don't have another option? I hope this will
improve soon!
Regards,
Urs
Mingqing Cheng [MSFT] wrote:
> Hi Uri,
> Thanks for your post.
> From your descriptions, I understood that you cannot set the default value
> in the Web UI even you have defined it in Report Designer. Have I
> understood you? Correct me if I was wrong.
> Based on my knowledge, unfortuantely, this is an known issue of us. It will
> only work when set in Report Designer. The latest news from development
> team is that they are working on this and no hotfix available now. I am
> afraid you will have to do the settings in the Report Designer.
> I am sincerely sorry for any inconvenience it may cause for your business
> and thank you for your patience and corperation. If you have any questions
> or concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Urs,
Hope the development team will fix it and we will announce it as soon as
possible.
For now, I am afraid you will have to use 12 reports with different default
values as workaround or change the business logic.
Thank you for your patience and corperation.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Urs
I wanted to post a quick note to see if you would like additional
assistance regarding the information MSFT John H. Miller had sent to you on
this particular issue. We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Repost - Forms Auth and the ReportServer web

I have an interesting issue. I setup my RS to use Forms Auth. I created a
logon page for the Reports web and and a logon page for the ReportServer
web. The page displays a
company logo, textboxes to enter credentials, logon button, etc. Nothing
extremely fancy.
The issue is this. When I navigate to the Reports web (Report Manager) the
logon page displays with the logo. When I navigate to the
ReportServer web, the logo image doesn't show.
What gives?
--
Adrian Maull
[MCP]Adrian M. wrote:
> The issue is this. When I navigate to the Reports web (Report
> Manager) the logon page displays with the logo. When I navigate to
> the
> ReportServer web, the logo image doesn't show.
> What gives?
It seems that you use a wrong virtual path to your image (i.e.
/images/logo.gif)
Try to use a "full" virtual path (i.e. http://localhost/images/logo.gif)
regards
frank

ReportViewerWebControl Problem in ASP.net 2.0

hi,

i have used one of the project ReportViewer Web Control , it works fine in local system, but when i put into the server it say

Reserved.ReportViewerWebControl.axd was not found on this server.,

to rectify

i putted blank Reserved.ReportViewerWebControl.axd file into root of the project and i checked

in config file

<httpHandlers>
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
validate="false" />
</httpHandlers>

this is exist ,

Please can any body help me , i will be thankful to you .

thanks

Dipesh

Hi Dipesh,

You should have report viewer installed on your web server in order to make the report viewer in your pages to work.

Install theMicrosoft Report Viewer Redistributable 2005 SP1 (Full Installation), you can download it from -http://www.microsoft.com/downloads/details.aspx?familyid=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en

and I am having these two setions related to report viewer -

<compilationdebug="true">

<buildProviders>

<addextension=".rdlc"type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

</buildProviders>

</compilation>

<httpHandlers>

<addpath="Reserved.ReportViewerWebControl.axd"verb="*"type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"validate="false"/>

</httpHandlers>

I think it will solve your problem....

ReportViewer's checked dropdown list control?

I would like to create my own parameter area for my reports which are displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer control (i.e. I have the ShowParameterPrompts property on my Report Viewer control set to False).

I would like to use the Checked Dropdown List control that allows you to check off each item individually or to check the (Select All) option for my multi-valued parameters.

Is there a way I can create an instance of this checked dropdown control or is there another component out there that is similar to it?

Thanks!!!

Brian

The control is not a public control and can not be created outside of the control. You would need to write your own.

-Daniel

ReportViewer's checked dropdown list control?

I would like to create my own parameter area for my reports which are
displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer control
(i.e. I have the ShowParameterPrompts property on my Report Viewer control
set to False).
I would like to use the Checked Dropdown List control that allows you to
check off each item individually or to check the (Select All) option for my
multi-valued parameters.
Is there a way I can create an instance of this checked dropdown control or
is there another component out there that is similar to it?
Thanks!!!
BrianMy understanding is that the only extensibility area the Report Viewer
supports is hiding the menus you don't need and writing your own. So, the
short answer is to your question is no. To re-confirm, please post your
question to
http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1. This
newsgroup is monitored by Rajeev Karunakaran who is the Program Manager of
the Report Viewer controls.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:72596A04-35ED-434A-B30C-186F3ABB7CAA@.microsoft.com...
>I would like to create my own parameter area for my reports which are
> displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer
> control
> (i.e. I have the ShowParameterPrompts property on my Report Viewer control
> set to False).
> I would like to use the Checked Dropdown List control that allows you to
> check off each item individually or to check the (Select All) option for
> my
> multi-valued parameters.
> Is there a way I can create an instance of this checked dropdown control
> or
> is there another component out there that is similar to it?
> Thanks!!!
> Brian
>|||Teo,
Thanks for your help. I have posted to the Report Viewer's newsgroup, but
no response...
Any other ways I might be able to see if this "checked dropdown" control is
available for use in an asp.net page?
-Brian
"Teo Lachev [MVP]" wrote:
> My understanding is that the only extensibility area the Report Viewer
> supports is hiding the menus you don't need and writing your own. So, the
> short answer is to your question is no. To re-confirm, please post your
> question to
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1. This
> newsgroup is monitored by Rajeev Karunakaran who is the Program Manager of
> the Report Viewer controls.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "brianpmccullough" <bmccullough11@.comcast.net> wrote in message
> news:72596A04-35ED-434A-B30C-186F3ABB7CAA@.microsoft.com...
> >I would like to create my own parameter area for my reports which are
> > displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer
> > control
> > (i.e. I have the ShowParameterPrompts property on my Report Viewer control
> > set to False).
> >
> > I would like to use the Checked Dropdown List control that allows you to
> > check off each item individually or to check the (Select All) option for
> > my
> > multi-valued parameters.
> >
> > Is there a way I can create an instance of this checked dropdown control
> > or
> > is there another component out there that is similar to it?
> >
> > Thanks!!!
> >
> > Brian
> >
>
>

ReportViewer: creating PDF on the fly

Hi all,

I'm writing a offer web page using ReportViewer control.
This offer page will be shown in PDF format.

I understood that the ReportViewer control can't work without any DataSource, but for my needs I use report parameters and not DataSet (or somesimilar object). So, I defined the unreal DataSet just for deceive the ReportViewer (I don't know if this solution is wise, but probably it's what I able).

<rsweb:ReportViewer runat="server" ID="ReportViewer1" Font-Names="Verdana" Font-Size="8pt" Height="400px" ShowToolBar="False" Width="685px"> <LocalReport ReportPath="Offer.rdlc" > <DataSources> <rsweb:ReportDataSource DataSourceId="objectDataSource" Name="DataSet1" /> </DataSources> </LocalReport></rsweb:ReportViewer><asp:ObjectDataSource runat="server" ID="objectDataSource" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="DataSet1TableAdapters.MyTableAdapter"></asp:ObjectDataSource>

So far so good. When I activate the offer page, it shown properly, but when I add the following code for create the PFD document from the page, I get an error:
A data source instance has not been supplied for the data source "DataSet1"

protected void Page_Load(object sender, EventArgs e){ Warning[] warnings;string[] streamids;string mimeType;string encoding;string extension;byte[] myBytes =this.ReportViewer1.LocalReport.Render("PDF",null,out mimeType,out encoding,out extension,out streamids,out warnings); Response.Buffer =true; Response.Clear(); Response.ContentType = mimeType; Response.BinaryWrite(myBytes); Response.Flush(); Response.End();}

Please help!

Thanks in advance!

Hi,

Take a look over here :

http://blogs.msdn.com/bimusings/archive/2005/07/01/434659.aspx

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Hi Suprotim Agarwal,

Thank you for the quick response.
I already saw this short article, but it not exactly answers to my case - the error appears only when I create a PDF document from my predefined ReportViewer. If I delete an aforementioned code, the Offer.aspx page work properly.

|||

Hi,

Based on the code you provided, you are going to render the report in the code behind, right?

I think you should declare and add the report datasource explicitly in your code-behind file before you are invoking the render method, see the following code snippet:

protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer1.ProcessingMode = ProcessingMode.Local;
this.ReportViewer1.LocalReport.ReportPath =
@."c:\Reports\Report1.rdl";
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Sales", LoadSalesData())); declare and add the datasource explicitly.

}
protected void Button1_Click(object sender, EventArgs e)
{
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;

byte[] bytes = ReportViewer1.LocalReport.Render(
"Excel", null, out mimeType, out encoding,
out extension,
out streamids, out warnings);

FileStream fs = new FileStream(@."c:\output.xls",
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();

Label1.Text = "Report exported to output.xls";

}
}

Thanks.

|||

The problem solved when I moved a code that creates a PDF document from Page_Load to Page_SaveStateComplete event.

Thanks to all of you!

ReportViewer, VS2005 and SSRS 2005

I have developed a web app that uses forms authentication. I wrote it in asp.net 2.0. My server is running windows 2003 server standard and IIS. I have also installed on the same machine SQL Server 2005 with Reporting Services.

From my webapplication, I have a button that the user can click and then I have the Report Viewer control generate a report. However, I do not know how to pass the proper credentials to the report server. I would like to pass one username and password that has permissions to run that report. My code is follows:

Private Sub saveRptAs(ByVal s_rptType As String)
Dim warnings As Microsoft.Reporting.WebForms.Warning()
Dim streamids As String()
Dim mimeType As String
Dim encoding As String
Dim extension As String

ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://myserver/reportserver")
ReportViewer1.ServerReport.ReportPath = "/reports/Individual Report"

Dim test As New NetworkCredential("localuser", "password", "domain")

ReportViewer1.ServerReport.ReportServerCredentials = test

Dim rprameter As ReportParameter = New ReportParameter("user_no", Profile.DTGVariables.SelectedYMNo)
Me.ReportViewer1.ServerReport.SetParameters(New ReportParameter() {rprameter})

Dim bytes As Byte() = ReportViewer1.ServerReport.Render(s_rptType, Nothing, mimeType, encoding, extension, streamids, warnings)
Response.Buffer = True
Response.Clear()
Response.ContentType = mimeType
Response.AddHeader("content-disposition", "attachment; filename=sample." + extension)
Response.BinaryWrite(bytes)
Response.Flush()
Response.End()
End Sub

When I click on the button I get the following message:

Unable to cast object of type 'System.Net.NetworkCredential' to type 'Microsoft.Reporting.WebForms.IReportServerCredentials'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.InvalidCastException: Unable to cast object of type 'System.Net.NetworkCredential' to type 'Microsoft.Reporting.WebForms.IReportServerCredentials'.

Can someone help me with the credentials issue? Do I need to change Reporting Services to use Forms Authentication?

Your help and insight is greatly appreciated.

Thanks

Nate Dogg

put your credentials in web.config, that's how i worked around it

<identityimpersonate="true"userName="Domain\user"password="password"/>

|||try this - works for me

... ServerReport report = ReportViewer1.ServerReport; report.ReportServerCredentials = new MyReportServerCredentials(); ... class MyReportServerCredentials : IReportServerCredentials{ public MyReportServerCredentials() { } public System.Security.Principal.WindowsIdentity ImpersonationUser { get { return null; // Use default identity. } } public System.Net.ICredentials NetworkCredentials { get { return new System.Net.NetworkCredential("user", "pass", "domain"); } } public bool GetFormsCredentials(out System.Net.Cookie authCookie, out string user, out string password, out string authority) { authCookie = null; user = password = authority = null; return false; // Not use forms credentials to authenticate. } }

|||

Hey guys this is killing me also. I am using webhosting4life.com as my hosting company and have reporting services. I am trying the same thing the original poster is doing and getting the same error message. When I try the impersonate user I get the following error message. All I truly want is for the report viewer to pull open the report and display to the end user...but I need to pass my user name and password over....PLEASE HELP!! I have read several books and none of them touch on this.

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:Could not create Windows user token from the credentials specified in the config file. Error from the operating system 'Unspecified error
'

|||

It appears the error is in the web.config. Implementing theIReportServerCredentials as shown in the previous article works and is a good solution to only having the SRS work under that user context.

ReportViewer's checked dropdown list control?

I would like to create my own parameter area for my reports which are displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer control (i.e. I have the ShowParameterPrompts property on my Report Viewer control set to False).

I would like to use the Checked Dropdown List control that allows you to check off each item individually or to check the (Select All) option for my multi-valued parameters.

Is there a way I can create an instance of this checked dropdown control or is there another component out there that is similar to it?

Thanks!!!

Brian

The control is not a public control and can not be created outside of the control. You would need to write your own.

-Daniel