Sql Calculated: control

Showing posts with label control. Show all posts

Thursday, March 22, 2012

Calling remote batch file using 'Execute process task'

I have a remote batch file on machine B that I need to execute using 'Execute process task' control from a package on machine A. The batch file uses pgp software and encrypts a file sitting on machine B itself. The reason why my batch file is sitting on machine B, is because the PGP software is on machine B.

If I execute the batch file by itself from machine B, the script runs fine. I refer the same batch file as a UNC path from my package on machine A. But that does not work since the 'Working directory' is still machine A. I can not set machine B's folder as the working dir because it does not accept UNC path. So I say, ok , let me map a path to that UNC location and map it as drive 'Z:\'. Certainly if I do so, I will be running the process on machine A and the batch file will look for the pgp software on machine A, and hence fail.

I have tried third party remote batch execution tools (PSEXEC) but have not had success, not because of SSIS limitations, but simply because the PGP executable when run through the PSEXEC tool, does not identify the location of the public keys on machine B and hence gives an encrytion failure.

How do I get the remote batch file to execute such that it executes with its own env? Is there a better remote execution tool I can try or are there any other features of SSIS I can use to get around this issue? I need the results of the batch file and hence do not want to make it an asyncronous process.

Thanks

Sumeet

PsExec will work for this purpose, and so will rsh and ssh implementation for Win32. Psexec is easier and you can use the "-e" parameter to configure alternate profile loading. Even if the environment from psexec were the minimal default user environment, just execute a remote command/script/executable which sets up the environment necessary prior to the pgp call.|||

Thanks. That helps. PsExec sends the alternate profile username/password as clear text. Can this be avoided in any way? I can not send account information to the PGP server as clear text. I am thinking about web service, but that has its own set of issues in executing a batch process, since the identiy of the executing process can not be changed (in 1.1)...

If someone can direct me to the user group where these questions can be better addressed, please let me know!

Thanks,

Sumeet

calling javascript on OnSelectedIndexChanged of a drop downlistbox

I have a dropdownlist and a text box.

Once i select the item on a dropdownlist, the control should skip to text box.

Here is the code and i get the error.

'onFocus' is not a member of 'ASP.test_aspx'.

can u plz help me out.

<htmlxmlns="http://www.w3.org/1999/xhtml">

<headrunat="server">

<title>Untitled Page</title>

<scriptlanguage="javascript">

function onFocus()

{

var control = document.getElementById("TextBox1");

if( control != null ) control.focus();

}

</script>

</head>

<body>

<formid="form1"runat="server">

<div>

<asp:DropDownListID="DropDownList1"runat="server"Width="161px"OnSelectedIndexChanged="onFocus()">

<asp:ListItem>Javed</asp:ListItem>

<asp:ListItem>Abid</asp:ListItem>

<asp:ListItem>sajid</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

<asp:TextBoxID="TextBox1"runat="server"></asp:TextBox></div>

</form>

</body>

</html>

The reason you are getting this type of error is because you try to associate (link) JS function with ASP event. when you declare event such as OnSelectedIndexChanged ASP searchs the code behind or C#/VB section for a handler to invoke once this event fires.

A very simple way to diffrentiate between HTML DOM events and ASP events is the case. Note that ASP is always MixCase.

sql

Saturday, February 25, 2012

Calender in Reports 2K

One of my report has 2 input variables, StartDate and EndDate. Is that
possible that I can include a calender control in the report interface such
that user can choose the date rather than typing it in?
I come to know that :
That is not an option today (sure would be a nice improvement). If you
need this then you need to create your own web page and then integrate with
RS using URL or SOAP.
If it is so then can anyone help me with example how to use it.
will be very helpful if i get any attachment.
Thanks & Regards
Labhesh Shrimali
Bangalore -Cross posting to microsoft.public.sqlserver.reportingsvcs since this
question isn't related to security.
Hope this helps.
Dan Guzman
SQL Server MVP
"Labhesh Shrimali - Bangalore"
<LabheshShrimaliBangalore@.discussions.microsoft.com> wrote in message
news:86E50086-C732-4B90-B9F9-881A9EC0FD42@.microsoft.com...
> One of my report has 2 input variables, StartDate and EndDate. Is that
> possible that I can include a calender control in the report interface
> such
> that user can choose the date rather than typing it in?
> I come to know that :
> That is not an option today (sure would be a nice improvement). If you
> need this then you need to create your own web page and then integrate
> with
> RS using URL or SOAP.
> If it is so then can anyone help me with example how to use it.
> will be very helpful if i get any attachment.
> Thanks & Regards
> Labhesh Shrimali
> Bangalore -
>

Calender

Calendar slow to load

Is anyone else experiencing performance problems with reports that use the calendar control for date parameters? Whenever we load a report that uses a calendar it takes several seconds to fully load the form (you can see something like this in the status bar:"...ReportViewerWebControl.axd?OpType=Calendar..."). This is not a serious problem, but if the user tries to use the control before it fully loads then the page throws javascript errors. I am wondering if this is a issue with the report itself or the server configuration, or if it is just something we have to live with.

The calendar control works by loading a years worth of dates to allow you to browse through the months more quickly. This is not a overly large amount of data and I have not seen it take a significant amount of time myself. The is, however, no way to change the behavior of this control. Things that might cause this behavior are a slow network connection or a slow server, however you would notice everything having longer load times then.

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

We have the same problem with calendar control. I have a filter with a date that should be greater than a value given by the user in the report. If I have a default value on the date the report loads very slow, in about 10 seconds. When I change the value in the report and click view report it still load slow.

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

The two behaviors I notice are an incredible amount of sluggishness associated with having a default value and that each time you change the value it makes a server round-trip even though you haven't clicked on the View Report button.

|||

Can you file a bug on this issue along with your report definition that makes this happen? When you do so, please include infomration on the SQL Server Reporting Services version you're using and what browser and it's version you're using.

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

When you have an expression based default value, we need to do a round trip to the server to determine the new value for the parameter. If the parameter depends on a previous parameter, whenever you change the upstream parameter we'll do a round trip. What I'd like to know is if the slowness persists if you were to substitute a string parameter for your datatime parameter. If it does, it is probably that the server is taking a long time to process your request - is it adequately resourced for the work load? Otherwise it might be specific to the data picker control.

Hope that helps,

-Lukasz

Calendar slow to load

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

|||

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

Hope that helps,

-Lukasz

Calendar slow to load

-Daniel

|||

I have a new RS2005 server in production and the speed at which the calendar control loads is also painfully slow.

On the initial rounds of testing it was so slow that my Business Analysts / QA person reported *bugs* with the calendar control refreshing the page or displaying blank and so forth.

Is there a way to limit how much date information it pulls down initially or to possibly build a custom control based on the out of the box control and then limit the date range loaded by default?

For my users at least the date range is going to be from minus 3 months to present for about 95% of the runs.

|||Just to add to this, I have the same problem, I thought it was a bug too but there doesnt seem to be a way of fixing this....at least none that I know of.|||

On the other hand if I dont give a default value in the filter the report loads within 2 seconds. It also loads within seconds if I change the value in the report?

Any suggestions?

/Stefan

|||

I wonder if this isn't related to bugs in the control?

|||

You can file the bug here: http://lab.msdn.microsoft.com/productfeedback/

Hope that helps,

-Lukasz

Calendar Reporting Control

I have a request to have a report created in a calendar layout. Does anyone
know of a charting component that can do this or an example that would help
me get started.
Thanks,
DavidHi David,
Welcome to MSDN Managed Newsgroup!
Unfortunately, I am afraid we do not have direct solution for this calendar
layout report in Microsoft. You may have to handle the layout yourself and
write custom code if required.
Let's wait to see whether other community members have such experience. You
may also search the google.com for related information.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, February 24, 2012

Calendar Control issues

Hi all,

When I click on a calendar control for date parameters the page will freeze or throw a java script error. This does not happen all the time, and is not isolated to one PC. It happens randomly on several PCs. Is there any known issue with this control?

regards,

Bill

The only issue that I have seen is if you try to open the calendar control while it is still loading the iframe for the calendar. Next time it happens see if the IE status bar is still showing the page loading.|||It is in the process of loading. There are times though, when it takes 10 seconds or more to load locally, and much longer if a user is accessing the page outside of the local LAN. If the user clicks on the control during the load, a java error occurs and the page is disabled. This cant be by design , could it? :-)|||

No it is not by design. :) I am surprised that it does take so long to load. Is this happening the first time you view the report or when navigating through calendar months? If it is the first time, the calendar is one of the last things loaded on the page, if the entire page is still loading (IE will render objects and allow interaction even though the page hasn't finished loading) the calander may not be loaded until the page is loaded. Are you viewing the reports through Report Manager or your own pages? If they are your own pages, perhaps there is some improvement that can be made there to speed up the page load.

As far as anything you can do to Report Server, there isn't anything that can currently be done to affect this behavior. We are aware of the issue and are looking to fix it in a future version. In the meantime users need to be aware of the issue and wait to open the drop down until the page has fully loaded.

|||Thank you for your answer. The page is displayed through report services, not my own page. I hope you have a fix soon, as it is making report services for my company very difficult to use. On a side note, report services displayed in IE7 with a calendar control will not work at all.|||

There have been quite a few reports of problems with the calendar control (just search the forums) and the basic answer seems to be "we cant replicate any problem" so I think MS dont know what to fix.

Certainly I have the same issue as you, the calendar controls throwing script errors and taking ages to load.

|||I am just hoping that some sort of hot fix is available soon. Like I said though, it does not work at all with IE7 so if MS is planning to release IE7 as a critical update like it is rumored, it will break all RS sites.|||IE7 is only in beta 3 mode, I believe the issues with IE7 and RS will be resolved but there is no fix for IE7 Beta 3.|||So I guess the answer is "deal with it" At least most companies dont use parameters in reporting , so it should not be a big issue.

|||Just to clarify, we are aware of the issue with the script errors and how to fix it. In order to be fixed in a QFE, a customer will need to contact CSS and request the fix, otherwise look for the fix in a future release. If your are hindered by this issue, your best course of action is to contact Customer Support and request a fix.|||It appears it is an IE issue. I am able to work with the calendar control fine with Firefox. Can anyone verify this?

Calendar Control issues

Hi all,

regards,

Bill

Certainly I have the same issue as you, the calendar controls throwing script errors and taking ages to load.

Calendar control in SP2

I know that the SP2 Beta is around for testing. Does anyone know if in
this version the Calendar control is made available for use for date
parameter input ? I believe the Calendar control is the most needed
control in any kind of reporting. Comments Please.
thanks,
Anand Sagar
IN4VelocityAnand Sagar wrote:
> I know that the SP2 Beta is around for testing. Does anyone know if in
> this version the Calendar control is made available for use for date
> parameter input ? I believe the Calendar control is the most needed
> control in any kind of reporting. Comments Please.
For what?
I use a calendar-control in a normal aspx-page and open the report in my
aspx-page
regards
Frank|||It is not SP2. Look for it in the upcoming version Yukon of SQL Server and
Reporting Services.
--
| From: anandsagar@.gmail.com (Anand Sagar)
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Calendar control in SP2
| Date: 27 Jan 2005 01:50:02 -0800
| Organization: http://groups.google.com
| Lines: 8
| Message-ID: <3f76a771.0501270150.17a13aea@.posting.google.com>
| NNTP-Posting-Host: 61.95.202.80
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1106819402 1467 127.0.0.1 (27 Jan 2005
09:50:02 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Thu, 27 Jan 2005 09:50:02 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA02.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08|||Oh, and I was so wanting it in SP2 :(
--
Adrian M.
MCP
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:ZHvXhpJBFHA.1092@.cpmsftngxa10.phx.gbl...
> It is not SP2. Look for it in the upcoming version Yukon of SQL Server and
> Reporting Services.
> --
> | From: anandsagar@.gmail.com (Anand Sagar)
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | Subject: Calendar control in SP2
> | Date: 27 Jan 2005 01:50:02 -0800
> | Organization: http://groups.google.com
> | Lines: 8
> | Message-ID: <3f76a771.0501270150.17a13aea@.posting.google.com>
> | NNTP-Posting-Host: 61.95.202.80
> | Content-Type: text/plain; charset=ISO-8859-1
> | Content-Transfer-Encoding: 8bit
> | X-Trace: posting.google.com 1106819402 1467 127.0.0.1 (27 Jan 2005
> 09:50:02 GMT)
> | X-Complaints-To: groups-abuse@.google.com
> | NNTP-Posting-Date: Thu, 27 Jan 2005 09:50:02 +0000 (UTC)
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA02.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
> phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news.glorb.com!postnews.goog
> le.com!not-for-mail
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:41015
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I know that the SP2 Beta is around for testing. Does anyone know if in
> | this version the Calendar control is made available for use for date
> | parameter input ? I believe the Calendar control is the most needed
> | control in any kind of reporting. Comments Please.
> |
> | thanks,
> | Anand Sagar
> | IN4Velocity
> |
>

calendar control in reporting services?

Is there anyway to use a calendar control in reporting services 2000? how?
thanksNo. RS 2005 has a calendar control. As well as multi-select parameters and
end user sorting. Plus better performance etc.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"netasp" <netasp@.newsgroups.nospam> wrote in message
news:utaMRWppGHA.3288@.TK2MSFTNGP03.phx.gbl...
> Is there anyway to use a calendar control in reporting services 2000? how?
> thanks
>|||Hello Netasp,
As Bruce has said, the Calendar control is not available in SQL Server
reporting service 2000. In addition to the Reporting Service 2005 option,
I'm wondering what's the functionality you want to add in your SQL Server
2000 reporting service report(through the calendar control). Are you going
to use the calender to provide datetime parameter? If so, do you think it
possible that we create an ASP.NET web application and dynamically request
the reporting service report in the ASP.NET page and display it. Thus, we
can use the ASP.NET web calender control on the page to get datetime input
from client user and send report request (with the datetime paramter get
from the calender).
Please feel free to post here if you have any other concerns or have any
other consideration on this.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Netasp,
How are you doing on this issue? Have you got any progress or does my last
reply helps you a little? If you think the approach I mentioned doable or
need any further assistance on this, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may
learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Calendar Control in Reporting Services 2000

Hi All

Is it possible to add datetime picker (Calendar Control)

in 2000 reporting services

Cheers

The calendar control came out with Reporting Services 2005. It can't be used in 2000 as far as I know.|||I can second that.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Calendar Control in Reporting Services 2000

Hi All

Is it possible to add datetime picker (Calendar Control)

in 2000 reporting services

Cheers

The calendar control came out with Reporting Services 2005. It can't be used in 2000 as far as I know.|||I can second that.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

calendar control for parameters in SQL 2000 Reporting?

As the subject says, I'd like to know if calendar controls are available for
reporting creating using VS2003 running on SQL 2000 (for internal reasons we
cannot upgrade to SQL 2005 for some time)No. You need RS 2005. Note that you can go to RS 2005 without upgrading your
database to SQL 2000. You need a SQL Server 2005 license but you can keep
your database at 2000 and just upgrade RS to RS 2005. I did this (although I
have since upgrade the db) and it works and is fully supported.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KBlount" <KBlount@.discussions.microsoft.com> wrote in message
news:B87C7B57-AF42-4C88-B762-69F3522F20FB@.microsoft.com...
> As the subject says, I'd like to know if calendar controls are available
> for
> reporting creating using VS2003 running on SQL 2000 (for internal reasons
> we
> cannot upgrade to SQL 2005 for some time)|||Thanks for the response Bruce. I'm currently investigating using .NET
calendar controls and integrating them with SSRS 2000 - we'll see how hairy
that gets! heh
Thanks for the info about being able to use RS 2005 on SQL 2000. I'll pass
on your post to my IT team and let them investigate that further. It would be
so convenient to simply change a paramter type to DateTime ;)
Cheers
Kevin
"Bruce L-C [MVP]" wrote:
> No. You need RS 2005. Note that you can go to RS 2005 without upgrading your
> database to SQL 2000. You need a SQL Server 2005 license but you can keep
> your database at 2000 and just upgrade RS to RS 2005. I did this (although I
> have since upgrade the db) and it works and is fully supported.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "KBlount" <KBlount@.discussions.microsoft.com> wrote in message
> news:B87C7B57-AF42-4C88-B762-69F3522F20FB@.microsoft.com...
> > As the subject says, I'd like to know if calendar controls are available
> > for
> > reporting creating using VS2003 running on SQL 2000 (for internal reasons
> > we
> > cannot upgrade to SQL 2005 for some time)
>
>|||For further ammunition. RS 2005 has end user sorting, renders to pdf and
excel much better (I used to regularly have my server lock up and that does
not happen anymore). It also has multi-select parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KBlount" <KBlount@.discussions.microsoft.com> wrote in message
news:2C79A69D-226E-4D64-BF0A-20AE98D76FFE@.microsoft.com...
> Thanks for the response Bruce. I'm currently investigating using .NET
> calendar controls and integrating them with SSRS 2000 - we'll see how
> hairy
> that gets! heh
> Thanks for the info about being able to use RS 2005 on SQL 2000. I'll pass
> on your post to my IT team and let them investigate that further. It would
> be
> so convenient to simply change a paramter type to DateTime ;)
> Cheers
> Kevin
> "Bruce L-C [MVP]" wrote:
>> No. You need RS 2005. Note that you can go to RS 2005 without upgrading
>> your
>> database to SQL 2000. You need a SQL Server 2005 license but you can keep
>> your database at 2000 and just upgrade RS to RS 2005. I did this
>> (although I
>> have since upgrade the db) and it works and is fully supported.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "KBlount" <KBlount@.discussions.microsoft.com> wrote in message
>> news:B87C7B57-AF42-4C88-B762-69F3522F20FB@.microsoft.com...
>> > As the subject says, I'd like to know if calendar controls are
>> > available
>> > for
>> > reporting creating using VS2003 running on SQL 2000 (for internal
>> > reasons
>> > we
>> > cannot upgrade to SQL 2005 for some time)
>>|||Thanks for the extra info, Bruce.
I attended (and passed: 88%! hehe wooo) the LearningTree "SQL Server
Reporting Services: Hands-On" course this time last year, and naturally I've
not had a project to use what I learned since.. until now. Now that you've
mention those other benefits, especially the multi-select parameter, I can
definitely see a need for the upgrade, rather than just a :wouldn't it be
nice".. the email to my IT team was sent earlier today... time will tell.
"Bruce L-C [MVP]" wrote:
> For further ammunition. RS 2005 has end user sorting, renders to pdf and
> excel much better (I used to regularly have my server lock up and that does
> not happen anymore). It also has multi-select parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "KBlount" <KBlount@.discussions.microsoft.com> wrote in message
> news:2C79A69D-226E-4D64-BF0A-20AE98D76FFE@.microsoft.com...
> > Thanks for the response Bruce. I'm currently investigating using .NET
> > calendar controls and integrating them with SSRS 2000 - we'll see how
> > hairy
> > that gets! heh
> >
> > Thanks for the info about being able to use RS 2005 on SQL 2000. I'll pass
> > on your post to my IT team and let them investigate that further. It would
> > be
> > so convenient to simply change a paramter type to DateTime ;)
> >
> > Cheers
> >
> > Kevin
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No. You need RS 2005. Note that you can go to RS 2005 without upgrading
> >> your
> >> database to SQL 2000. You need a SQL Server 2005 license but you can keep
> >> your database at 2000 and just upgrade RS to RS 2005. I did this
> >> (although I
> >> have since upgrade the db) and it works and is fully supported.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "KBlount" <KBlount@.discussions.microsoft.com> wrote in message
> >> news:B87C7B57-AF42-4C88-B762-69F3522F20FB@.microsoft.com...
> >> > As the subject says, I'd like to know if calendar controls are
> >> > available
> >> > for
> >> > reporting creating using VS2003 running on SQL 2000 (for internal
> >> > reasons
> >> > we
> >> > cannot upgrade to SQL 2005 for some time)
> >>
> >>
> >>
>
>

Calendar control for date selection ?

Hello,
I have a very simple report...
SELECT AmountDue from Table where DueDate Between @.Dt1 and @.Dt2...
So in above case i will see two parameter in my report. Is there any way so
that i can select dates from calendar control in Reporting Service ?
ThxHi,
Not yet. In SQL RS 2000, the date parameters default to using a text box for
input.
In SQL RS 2005, you will be able to use date pickers for date parameters.
In the meantime, it is possible to write your own ASP-type front ends to
allow users to pick parameters. These parameters can then be passed to your
report using query string parameters. (See RS books online for details...)
"mvp" wrote:
> Hello,
> I have a very simple report...
> SELECT AmountDue from Table where DueDate Between @.Dt1 and @.Dt2...
>
> So in above case i will see two parameter in my report. Is there any way so
> that i can select dates from calendar control in Reporting Service ?
> Thx

Calendar Control and Database Connection

Hi,
I m trying to implement a calendar, where you can select certain dates and view list of events for that day. The list is generated from database. I found a script on the web that is quite similar to what i want to achieve. I tried to run this script, however I get an exeption saying:

An error has occurred while establishing a connection to the server. ... error: 40 - Could not open a connection to SQL Server)

This is the code:
SqlConnection mycn;
SqlDataAdapter myda;
DataSet ds = new DataSet();
DataSet dsSelDate;
String strConn;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
strConn = "Data Source=localhost;Initial Catalog=pubs";

mycn = new SqlConnection(strConn);
myda = new SqlDataAdapter("Select * FROM EventsTable", mycn);
myda.Fill(ds, "Table"); //This where I get the exeption
}

protected void CalendarDRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e)
{
// If the month is CurrentMonth
if (!e.Day.IsOtherMonth)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if ((dr["EventDate"].ToString() != DBNull.Value.ToString()))
{
DateTime dtEvent = (DateTime)dr["EventDate"];
if (dtEvent.Equals(e.Day.Date))
{
e.Cell.BackColor = System.Drawing.Color.PaleVioletRed;
}
}
}
}
//If the month is not CurrentMonth then hide the Dates
else
{
e.Cell.Text = "";
}
}

private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
myda = new SqlDataAdapter("Select * from EventsTable where EventDate='" +
Calendar1.SelectedDate.ToString() + "'", mycn);
dsSelDate = new DataSet();
myda.Fill(dsSelDate, "AllTables");
if (dsSelDate.Tables[0].Rows.Count == 0)
{
DataGrid1.Visible = false;
}
else
{
DataGrid1.Visible = true;
DataGrid1.DataSource = dsSelDate;
DataGrid1.DataBind();
}
}

Can some one tell me what is wrong with the code.
Thank You

WATCH THIS SPACE

I resolve the issue by correcting the connection string within the strCon.

WATCH THIS SPACE

Calendar Control

We use the RS 2005 Calendar control for date/time parameters on our
reporting. Unfortunatley we have been running into a performance problem
becuase the Calendar control does a round trip to the server once a date is
chosen. On many of our desktops, this round trip is very evident.
Is there any way to provent the round trip to the server when a date is
chosen?
Thanks,
EricNo way except you need to write a custom code.
Amarnath
"echeeze" wrote:
> We use the RS 2005 Calendar control for date/time parameters on our
> reporting. Unfortunatley we have been running into a performance problem
> becuase the Calendar control does a round trip to the server once a date is
> chosen. On many of our desktops, this round trip is very evident.
> Is there any way to provent the round trip to the server when a date is
> chosen?
> Thanks,
> Eric

Calendar Control

Is there a way to use calendar controls to select dates. I have a
report that requires a start date and an end date as parameters. I
would rather have a date selector then have the user type in the dates.
thanksIt will be in SQL 2005, otherwise you need to put an html page in front of
the report to do this
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<jeffj924@.gmail.com> wrote in message
news:1126119866.508176.4670@.g44g2000cwa.googlegroups.com...
> Is there a way to use calendar controls to select dates. I have a
> report that requires a start date and an end date as parameters. I
> would rather have a date selector then have the user type in the dates.
> thanks
>

Thursday, March 22, 2012

Calling remote batch file using 'Execute process task'

calling javascript on OnSelectedIndexChanged of a drop downlistbox

Saturday, February 25, 2012

Calender in Reports 2K

Calender

Calendar slow to load

Calendar slow to load

Calendar slow to load

Calendar Reporting Control

Friday, February 24, 2012

Calendar Control issues

Calendar Control issues

Calendar control in SP2

calendar control in reporting services?

Calendar Control in Reporting Services 2000

Calendar Control in Reporting Services 2000

calendar control for parameters in SQL 2000 Reporting?

Calendar control for date selection ?

Calendar Control and Database Connection

Calendar Control

Calendar Control

Sql Calculated

Blog Archive

About Me