Another query problem

I am using Dreamweaver for the following:
Hi,
I have a problem with a search/results page, one of the fields is a date, I
want to display all results if the date is not entered in the search page
and display the records that match the date entered if any.
My problem is that if in the results page recordset I enter:
Lastworked = 'MMColParam7'
and I enter MMColParam7 01/01/1950 Request("Date")
Then the result is that if the date is entered I DO get the correct results,
but if the date is not entered I don't get any results at all becasue it
takes 01/01/1950 as default date.
Then I try to use
Lastworked LIKE 'MMColParam7'
and I enter MMColParam7 % Request("Date")
Then If i enter the date I get NO results, even where there are records that
match.
Any ideas ?
ACould you enter more info... Like the table structures of the two SQL tables
you are referring to, and the exact SQL Query you are sending to the databas
e
that is producing "incorrect" results? Some parts of Your post, specificall
y
Lastworked = 'MMColParam7'
are confusing. Lastworked sounds like a name for a column with dates in it,
but 'MMColParam7' is a string, not a date, and IT sopunds like the name for
another column...
"Aleks" wrote:

> I am using Dreamweaver for the following:
> Hi,
> I have a problem with a search/results page, one of the fields is a date,
I
> want to display all results if the date is not entered in the search page
> and display the records that match the date entered if any.
> My problem is that if in the results page recordset I enter:
> Lastworked = 'MMColParam7'
> and I enter MMColParam7 01/01/1950 Request("Date")
> Then the result is that if the date is entered I DO get the correct result
s,
> but if the date is not entered I don't get any results at all becasue it
> takes 01/01/1950 as default date.
>
> Then I try to use
> Lastworked LIKE 'MMColParam7'
> and I enter MMColParam7 % Request("Date")
> Then If i enter the date I get NO results, even where there are records th
at
> match.
> Any ideas ?
>
> A
>
>

Another fts question - after page faults

Sorry for the repost, but this really should have been the start of a new
thread.
Ok, that brings up another question, our server is set to boost SQL Server
priority, would this slow down msftesql? We are running 4 3.2 Xeon's with 8
GB RAM (Maxmem is set to 7168 MB). We have 14 fulltext indexes with
approximately a million rows each, but within the next month we will be
adding 12 more fulltext indexes which, I believe, will be slightly larger,
and doubling our db size (currently we have 63 tables, the largest being 10
million rows, and total used mdf size is 17 GB). Do you think the boost SQL
Server setting will be slowing fulltext indexing? Or does this setting also
boost the priority of msftesql? Do you think the max memory setting above is
giving msftesql the room it needs?
Thanks.
CR
I would give Search 1/2 Gig, I would not use the priority boost. I have some
optimal settings for you to use which I will post as soon as I find them.
How many catalogs do you have? This is actually more important than the
number of indexes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CR" <me@.work.com> wrote in message
news:u1yNTAxOHHA.324@.TK2MSFTNGP06.phx.gbl...
> Sorry for the repost, but this really should have been the start of a new
> thread.
> Ok, that brings up another question, our server is set to boost SQL Server
> priority, would this slow down msftesql? We are running 4 3.2 Xeon's with
> 8
> GB RAM (Maxmem is set to 7168 MB). We have 14 fulltext indexes with
> approximately a million rows each, but within the next month we will be
> adding 12 more fulltext indexes which, I believe, will be slightly larger,
> and doubling our db size (currently we have 63 tables, the largest being
> 10
> million rows, and total used mdf size is 17 GB). Do you think the boost
> SQL
> Server setting will be slowing fulltext indexing? Or does this setting
> also
> boost the priority of msftesql? Do you think the max memory setting above
> is
> giving msftesql the room it needs?
> Thanks.
> CR
>
|||We have 4 catalogs, and will be adding 6 more.
Thanks.
CR
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Oru5lSxOHHA.4372@.TK2MSFTNGP04.phx.gbl...
>I would give Search 1/2 Gig, I would not use the priority boost. I have
>some optimal settings for you to use which I will post as soon as I find
>them.
> How many catalogs do you have? This is actually more important than the
> number of indexes.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "CR" <me@.work.com> wrote in message
> news:u1yNTAxOHHA.324@.TK2MSFTNGP06.phx.gbl...
>
|||Ideally each large table should have its own catalog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CR" <me@.work.com> wrote in message
news:eTJr$VxOHHA.320@.TK2MSFTNGP06.phx.gbl...
> We have 4 catalogs, and will be adding 6 more.
> Thanks.
> CR
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:Oru5lSxOHHA.4372@.TK2MSFTNGP04.phx.gbl...
>

Annoying issue with PDF rendering

Are there some guidlines on setting the page and body sizes as well as
laying out objects such that PDF doesn't throw blank pages between or pages
or on the first page.
My page is standard A4 which in landscape means it is 29.7cm wide - and this
is what I have set the report width to. I have margins of 1cm on the right
and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
for this, the report body and footer (no header) are 27.5cm wide.
Body contains two tables. One table is stand alone the other Table is
imbedded in a List grouped on user Id - there are no pagebreak checkboxes
checked.
In the footer I have a few textboxes detailing various things such as print
date and time, page number etc. The objects in the Footer and Body are
indented slightly and nothing overlaps.
Why am I getting these blank pages spilled in to Acrobat?
thanks
MattMatt
I would be really interested to know the answer to this as I am
experiencing the exact same problem. Looking back at past responses,
it looks like this is something that cannot be solved until the next
version. To overcome the problem, I am having to export to excel, copy
to word and print to pdf. Please if anyone has a better solution, lets
us know...
Lisa
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and this
> is what I have set the report width to. I have margins of 1cm on the right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as print
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt|||I believe I ran into this on a report I had to export to pdf and if I recall
correctly, I was able to resolve it by playing around with the 'Size'
properties of the Body and the 'PageSize' properties of the Report.
You see the Body properties by clicking on an empty area of your report in
Report Designer, the white part with the grid lines or dots on it.
You see the Report properties by clicking on the thin beige area in Report
Designer just to the right or left of the Body of the report I just
described above.
I found that by playing around with these #'s I was able to control the pdf
rendering a bit better. I think one set of #'s had to be bigger than the
other to stop the blank page thing from happening. And please don't ask
which way it goes 'cause I don't remember :-) And I don't have that project
open right now and don't want to wait 10 minutes for it to open. Our
solution is getting rather large and seems to take forever to open.
Hope that helps.
Dale
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or
pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> is what I have set the report width to. I have margins of 1cm on the
right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as
print
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt
>|||Hi Lisa,
You may have found as Dale suggests, that by playing with the formatting,
you can get it to export correctly to PDF.
Probably like you Lisa I was after something a bit more concrete to take the
guesswork out of it, but thanks to Dale for responding.
For what it's worth, this is where I'm at.
1) The page width needs to be either 21cm or 29.7cm for portrait and
landscape respectively. I am really only using Landscape, so I'm using
measurements relative to that.
2) The parts of the report, Body, Header and Footer cannot be wider than the
page width less margins. I typically have 1cm margins so my B, H and F need
to be in theory no wider than 27.7 - in practice, I have found that I can't
get over 27cm - although I've done quite a bit of playing, my testing is by
no means exhaustive.
3) Make sure objects don't overlap. In Crystal, you could pop things on top
of each other, in RS this is not the case.
The above ones are pretty obvious so you are probably on top of them
4) This is the grey area. I have two tables. One stand alone, I can set to
the width of the report body. A second table resides in a list. Even
though I'd reduced the width of this table to about 20cm it was still
spilling over to a new page. I found setting Can Grow property to True for
some of the longer fields resolved this. Even so, I cannot get the table
any wider than 25.5cm. The table is sitting within a List, which is 26.5cm
wide an has no padding.
Perhaps we can refine this as we come across more ideas
regards
Matt
"Lisa" <budgenlj@.willis.com> wrote in message
news:9abd1432.0407140649.3a7717f8@.posting.google.com...
> Matt
> I would be really interested to know the answer to this as I am
> experiencing the exact same problem. Looking back at past responses,
> it looks like this is something that cannot be solved until the next
> version. To overcome the problem, I am having to export to excel, copy
> to word and print to pdf. Please if anyone has a better solution, lets
> us know...
> Lisa
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> > is what I have set the report width to. I have margins of 1cm on the
right
> > and 1cm on the left, the top and bottom margins are both 1.5cm.
Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak
checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
print
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt|||Dale/Matt
Thank you for your responses. I have managed to get this to work now
and pdf correcly by altering the page widths. Thank you both so much.
Lisa
"Dale" <dale@.NoSpamPlease.ca> wrote in message news:<ewSzN1daEHA.752@.TK2MSFTNGP09.phx.gbl>...
> I believe I ran into this on a report I had to export to pdf and if I recall
> correctly, I was able to resolve it by playing around with the 'Size'
> properties of the Body and the 'PageSize' properties of the Report.
> You see the Body properties by clicking on an empty area of your report in
> Report Designer, the white part with the grid lines or dots on it.
> You see the Report properties by clicking on the thin beige area in Report
> Designer just to the right or left of the Body of the report I just
> described above.
> I found that by playing around with these #'s I was able to control the pdf
> rendering a bit better. I think one set of #'s had to be bigger than the
> other to stop the blank page thing from happening. And please don't ask
> which way it goes 'cause I don't remember :-) And I don't have that project
> open right now and don't want to wait 10 minutes for it to open. Our
> solution is getting rather large and seems to take forever to open.
> Hope that helps.
> Dale
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
> pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
> this
> > is what I have set the report width to. I have margins of 1cm on the
> right
> > and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
> print
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt
> >
> >

Anchoring textbox to a page.

Hi,

In our project I have a matrix report. In that I need to anchor a textbox to the right end of the page, so that the textbox will always be at the right end of the report/page.

I also need to place the textbox at the page header. (but I am also open to solution / workarounds which does not include page header!!)

Thanks in advance

Arun.

any ideas?|||

If you just place a new textbox to the right hand side of your matrix control this will always display at the right hand side of the information displayed, also that textbox can live in the page header.....

Unless you are after something more complex it should be that simple, please provide more info if this is not quite what you are looking for.

|||

thanks for the reply,that works..

but we need soemthing more!!

| textbox | <-- textbox alligned here.

--|

Matrix |

|

--|

we need the matix report and the textbox right aligned to the right margin of the page. ( the textbox's right edge and the matrix right edge edge should align).

thanks in advance...

Arun

|||within the properties page of the matrix control you have an option to grow content right to left or left to right, the default is left to right so change this and it may give you what you are looking for, Otherwise you would have to code the position based on screen width less size of control but this is another task all together, I would assume the property should fix you issues, then the textbox place will be pushed out by the matrix.|||

sorry Andy.. that too doesnt work.. it give a mirror image of the matix that is what we dont need!!..

any other ideas?

thanks

arun

|||

Hi

After much time trying to get this to happen unfortuantely there is no automated way to right align your matrix automatically, It is certianly something i would like to see MS put in as a feature as i would find it useful, The onyl thing you can do is to place the matrix as far right as possible within the designer.

Sorry I dont have a better solution for you here.

Andy

|||

thanks Andy. i would also like to see that in SSRS as a feature!!..

for now i will try to anchor the textbox using some expression..

mean while if anyone comeacross any other ideas please keep me posted!!

thanks

Arun

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.