Showing posts with label box. Show all posts
Showing posts with label box. Show all posts

Tuesday, March 20, 2012

/3GB not working

Hi,

I am on a box with 4 GB of memory that only runs SQL Server. SQL Server is using 1.7 GB as per task manager. There are a lot of databases on this box. I looked at the boot.ini and /3GB was not set. I have done this at least 50 times before: turn on the /3GB switch and SQL Server will use up to 2.7 GB per task manager. (I know it is actually 2GB and 3GB but it seems that in task manager it shows up as 1.7-1.8 and 2.7-2.8)

Anyway back to the story. So I set /3GB, rebooted the server and SQL Server still only consumes up to 1.7GB. I realize that SQL Server might not actually need more memory, but I have a distinct feeling that it wants more but is being constrained; that is, the the /3GB switch is not working. More relevant information:

1) the boot.ini line:
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB

2) max server memory (MB) = 3000

3) min server memory (MB) = 3000

4) awe enabled = 0

5) @.@.version = 8.00.2039 which is SQL Server 2000 SP4

Has anyone seen this before? Any ideas on how to troubleshoot this?Just figured out the problem: This server is using SQL Server 2000 Standard Edition. For the benefit of all future readers of this thread, the maximum amount of memory that SQL Server 2000 Standard Edition and SQL Server 2000 Personal Edition can ever use is 2GB. SQL Server 2000 Developer's Edition and SQL Server 2000 Enterprise Edition will both go higher. The actual amount of memory is dependent on the operating system.

Sunday, March 11, 2012

.rdlc reports - add values through textbox name?

hi all

have a .rdlc report like an invoice.

how can i add the values in my textboxes by the Name property of the Text Box.

like txtSubTotal.Text + txtTax.Text + txtShipping.Text. ?

all those fields are populated with calculations that run on the dataset and all have values. I just cant seem to write the proper syntax to add by control names, rather than field names.

well youshould use this syntax

ReportItems!txtSubTotal.Value + ReportItems!txtTax.Value + ReportItems!txtShipping.Value

NB: this wouldn't work whih agregiate functions unless used in a header or footer

Hope this help

|||

Yes I couldn't for the LIFE OF ME find any information on the

ReportItems! < identifier. AFter much searching i found it buried in a MSDN doc somewhere called "The 5 Elements of a Microsoft Report"

Anyways got it working fine now.

thanks,

mcm

|||

hi

Please tell me how to add Runtime value into Report.rdlc. I have two date(for start & end date) Controls on web page. I want to display those date on Report.rdlc using c#.

thanking you in advance

|||

here is a code fragment that could help you :

List<ReportParameter> par=new List<ReportParameter>();ReportParameter p=newReportParameter("saleid","43660");par.Add(p);this.reportViewer1.ServerReport.SetParameters(par);this.reportViewer1.RefreshReport();
Hope this helps

Sunday, February 19, 2012

...is null or not an object error

I am working in html/asp within VisInterDev 6.0. Everything was working fine until I moved a text box from one page to another. I took it from within a form on one page to a form on another (and made the necessary changes in the two pages).

Here is the code that is generating the error:

<body onload="java script:eventreg3.dist.focus();">

However I am using syntactically indentical code on other pages that work fine so I know the problem is not with that line.

It appears that it is not able to find the "dist" text box, but I have been over and over the html and can't find an issue. If I take that line out (keeping the <body> of course) it doesn't generate an error but my submit button doesn't work.

I have also noted that VisInterDev appears to eliminate, or not put in, double quotes around tag attributes. For instance, size="2" appears as size=2. I thought the double quotes were a requirement?

ANy help here? Thanks a ton!!!could it be the space between java and script?

rudy|||but that wasn't it. That space didn't actually exist in the code itself. Sorry for wasting your time. I have no idea what the deal is.

Thursday, February 16, 2012

**linked server**

Hi
I'm working with MS sql server 2000 and I want to add a linked server. but
there is an empty "provider name" combo box, with following message at the
bottom "Provider Name is one of the providers installed on the server"
what programs should I install in order to get a complete names of
providers and be able to continue?
(I have no problem on my personal client(WinXP) in our LAN, but this is a
problem in our server.)
my second question:
Is it possible to have a remote server throught VPN by a linked server?
(now I have the remote SQL server through a new SQL server registration
but I want to have it in a linked server in order to easily join its table
with my local network tables and ...)
Any help would be greatly appreciated.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/1) Do you try to create a linked server to another SQL Server? Check SQL
Server under Server Type option
2) I think it is permission issue, I have never tried it. Have you tried to
create a linked server?
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tk5uxesen9ig5y@.system109.parskhazar.net...
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/|||Hi
Try adding the linked server through T-SQL using something like:
EXEC sp_addlinkedserver @.server='RemoteSQLServer', @.srvproduct='',
@.provider='SQLOLEDB',
@.datasrc='RemoteSvr\SQLInstance'
If you can register the remote server you should be ok to define it as a
linked server. Response over the VPN may be quite slow.
John
"M" wrote:
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>

Monday, February 13, 2012

*** DTS Error Messages ***

Hello,
I'd like to know if I use DTS. If I use it immediately, I can see the error
in the dialog box, instead, if I use it with scheduling, where Can I check
the error ?

Thanks

Saimon(Florence)There are actually a few places you can look at errors. There are the
error logs you would have specified in your package under Options.
Another place is when you right click on the Scheduled Job and View
Job History and then check the box that says Show Step Details. Then
click on the details. I know there are a few other places, but these
should get you in the right direction.

"Saimon" <saimon181072@.supereva.it> wrote in message news:<c5bbkr$3rf$1@.newsreader.mailgate.org>...
> Hello,
> I'd like to know if I use DTS. If I use it immediately, I can see the error
> in the dialog box, instead, if I use it with scheduling, where Can I check
> the error ?
> Thanks
> Saimon(Florence)|||There are actually a few places you can look at errors. There are the
error logs you would have specified in your package under Options.
Another place is when you right click on the Scheduled Job and View
Job History and then check the box that says Show Step Details. Then
click on the details. I know there are a few other places, but these
should get you in the right direction.

"Saimon" <saimon181072@.supereva.it> wrote in message news:<c5bbkr$3rf$1@.newsreader.mailgate.org>...
> Hello,
> I'd like to know if I use DTS. If I use it immediately, I can see the error
> in the dialog box, instead, if I use it with scheduling, where Can I check
> the error ?
> Thanks
> Saimon(Florence)

Thursday, February 9, 2012

(Select All) value

I would like to display "ALL" in a text box if the (Select All) option is
selected as a parameter.
I can display 1, 2, 5 to every single selected value in the textbox using
the JOIN function. But if the (Select All) parameter is selected, I would
rather display "All" in my textbox instead of 50+ parameters.
I have tried something of the following
=IIf(Parameters!param.Value = "Select All" , "All",
Join(Parameters!param.Value, " | "))
But this does not work.
Any suggestions out there?
Thanks
RobRob,
I have an idea, but I don't know how good it is...
If there is a way to count the number of values selected, you could
compare that with a count of the records in the dataset. However, since
I don't know if that is possible, here is an idea...
You are using a dataset to generate the "Available Values" for one
parameter. Use this same dataset as the default value for a new,
internal parameter. This parameter will not be used for anything other
than holding all of the values that could be selected.
Then, use an expression to compare the 2 JOIN results.
Iif(JOIN(Parameters!mainParm.Value,",") =JOIN(Parameters!internalParm.Value,","), "All",
JOIN(Parameters!mainParm.Value,",") )
Hope this helps!
-Josh
Rob wrote:
> I would like to display "ALL" in a text box if the (Select All) option is
> selected as a parameter.
> I can display 1, 2, 5 to every single selected value in the textbox using
> the JOIN function. But if the (Select All) parameter is selected, I would
> rather display "All" in my textbox instead of 50+ parameters.
> I have tried something of the following
> =IIf(Parameters!param.Value = "Select All" , "All",
> Join(Parameters!param.Value, " | "))
> But this does not work.
> Any suggestions out there?
> Thanks
> Rob|||Ok, I figured it out and I wanted to put my solution here for others in the
same boat.
Problem: In SSRS 2005 (non SP1) there is the Multi-value option for a
parameter. If you want to display the parameter list in a text box, you use
something like:
=Join(Parameters!param_mso.Label, ", ") //this goes in textbox
and (m.mso_num IN (@.param_mso)) //this goes in the query
This will display every select parameter in a textbox. But what happens if
you have 100+ parameters? Then you have an unmanageable list of parameters
being displayed on the report.
So, if the user selects (Select All) from the dropdown list, only display
"All" in the textbox.
Solution: You need to create a new dataset that only returns the row count
of the parameter list. So, for example: this is the SQL query that returns a
list of MSO objects that are associated with a NETWORK parameter
SELECT s.network_id, ms.mso_num, m.mso_name
FROM service s, mso_service ms, mso m
WHERE s.service_id = ms.service_id
and ms.mso_num = m.mso_num
and s.network_id = @.param_network
GROUP BY s.network_id, ms.mso_num, m.mso_name
ORDER BY ms.mso_num
I create a new DATASET just to get the count of the above query:
SELECT count(*)
FROM(
SELECT s.network_id, ms.mso_num, m.mso_name
FROM service s, mso_service ms, mso m
WHERE s.service_id = ms.service_id
and ms.mso_num = m.mso_num
and s.network_id = :param_network
GROUP BY s.network_id, ms.mso_num, m.mso_name
ORDER BY ms.mso_num)x
This way I know the max number of row items that the original query is going
to return. I then use the following formula in my textbox:
=IIf(Parameters!param_mso.Count = Parameters!param_count.Value, "ALL",
Join(Parameters!param_mso.Label, ", "))
So if the count of my MSO parameter equals the total count of the query,
then display "ALL", otherwise display all of the parameters selected.
I hope that this helps out.
Rob
"Josh" wrote:
> Rob,
> I have an idea, but I don't know how good it is...
> If there is a way to count the number of values selected, you could
> compare that with a count of the records in the dataset. However, since
> I don't know if that is possible, here is an idea...
> You are using a dataset to generate the "Available Values" for one
> parameter. Use this same dataset as the default value for a new,
> internal parameter. This parameter will not be used for anything other
> than holding all of the values that could be selected.
> Then, use an expression to compare the 2 JOIN results.
> Iif(JOIN(Parameters!mainParm.Value,",") => JOIN(Parameters!internalParm.Value,","), "All",
> JOIN(Parameters!mainParm.Value,",") )
> Hope this helps!
> -Josh
>
> Rob wrote:
> > I would like to display "ALL" in a text box if the (Select All) option is
> > selected as a parameter.
> >
> > I can display 1, 2, 5 to every single selected value in the textbox using
> > the JOIN function. But if the (Select All) parameter is selected, I would
> > rather display "All" in my textbox instead of 50+ parameters.
> >
> > I have tried something of the following
> >
> > =IIf(Parameters!param.Value = "Select All" , "All",
> > Join(Parameters!param.Value, " | "))
> >
> > But this does not work.
> >
> > Any suggestions out there?
> >
> > Thanks
> > Rob
>|||You can just use Count(Fieldname, "Dataset") to retrieve the number instead
of creating a seperate dataset.
"Rob" wrote:
> Ok, I figured it out and I wanted to put my solution here for others in the
> same boat.
> Problem: In SSRS 2005 (non SP1) there is the Multi-value option for a
> parameter. If you want to display the parameter list in a text box, you use
> something like:
> =Join(Parameters!param_mso.Label, ", ") //this goes in textbox
> and (m.mso_num IN (@.param_mso)) //this goes in the query
> This will display every select parameter in a textbox. But what happens if
> you have 100+ parameters? Then you have an unmanageable list of parameters
> being displayed on the report.
> So, if the user selects (Select All) from the dropdown list, only display
> "All" in the textbox.
> Solution: You need to create a new dataset that only returns the row count
> of the parameter list. So, for example: this is the SQL query that returns a
> list of MSO objects that are associated with a NETWORK parameter
> SELECT s.network_id, ms.mso_num, m.mso_name
> FROM service s, mso_service ms, mso m
> WHERE s.service_id = ms.service_id
> and ms.mso_num = m.mso_num
> and s.network_id = @.param_network
> GROUP BY s.network_id, ms.mso_num, m.mso_name
> ORDER BY ms.mso_num
> I create a new DATASET just to get the count of the above query:
> SELECT count(*)
> FROM(
> SELECT s.network_id, ms.mso_num, m.mso_name
> FROM service s, mso_service ms, mso m
> WHERE s.service_id = ms.service_id
> and ms.mso_num = m.mso_num
> and s.network_id = :param_network
> GROUP BY s.network_id, ms.mso_num, m.mso_name
> ORDER BY ms.mso_num)x
> This way I know the max number of row items that the original query is going
> to return. I then use the following formula in my textbox:
> =IIf(Parameters!param_mso.Count = Parameters!param_count.Value, "ALL",
> Join(Parameters!param_mso.Label, ", "))
> So if the count of my MSO parameter equals the total count of the query,
> then display "ALL", otherwise display all of the parameters selected.
> I hope that this helps out.
> Rob
>
>
> "Josh" wrote:
> >
> > Rob,
> >
> > I have an idea, but I don't know how good it is...
> >
> > If there is a way to count the number of values selected, you could
> > compare that with a count of the records in the dataset. However, since
> > I don't know if that is possible, here is an idea...
> >
> > You are using a dataset to generate the "Available Values" for one
> > parameter. Use this same dataset as the default value for a new,
> > internal parameter. This parameter will not be used for anything other
> > than holding all of the values that could be selected.
> >
> > Then, use an expression to compare the 2 JOIN results.
> > Iif(JOIN(Parameters!mainParm.Value,",") => > JOIN(Parameters!internalParm.Value,","), "All",
> > JOIN(Parameters!mainParm.Value,",") )
> >
> > Hope this helps!
> >
> > -Josh
> >
> >
> > Rob wrote:
> > > I would like to display "ALL" in a text box if the (Select All) option is
> > > selected as a parameter.
> > >
> > > I can display 1, 2, 5 to every single selected value in the textbox using
> > > the JOIN function. But if the (Select All) parameter is selected, I would
> > > rather display "All" in my textbox instead of 50+ parameters.
> > >
> > > I have tried something of the following
> > >
> > > =IIf(Parameters!param.Value = "Select All" , "All",
> > > Join(Parameters!param.Value, " | "))
> > >
> > > But this does not work.
> > >
> > > Any suggestions out there?
> > >
> > > Thanks
> > > Rob
> >
> >|||Won't let me edit my post. Something like this.
=IIF(Count(Fields!AcctCode.Value, "AcctCode") =Parameters!AcctCode.Count,"All",Join(Parameters!AcctCode.Label,","))
"Rob" wrote:
> I would like to display "ALL" in a text box if the (Select All) option is
> selected as a parameter.
> I can display 1, 2, 5 to every single selected value in the textbox using
> the JOIN function. But if the (Select All) parameter is selected, I would
> rather display "All" in my textbox instead of 50+ parameters.
> I have tried something of the following
> =IIf(Parameters!param.Value = "Select All" , "All",
> Join(Parameters!param.Value, " | "))
> But this does not work.
> Any suggestions out there?
> Thanks
> Rob