Hi,
I have problem with &rs:Parameters=false it's not working if reports in a
iframe;
same url working well on a normal page; any trick? here is my url:
http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and
Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=false&date1=2006-05-01&date2=2006-05-02&unit_id=-1147471730&children=Y
thanks in advance! /Tomsorry, my bad, I mess up with rc: and rs in iframe url: everything is OK now,
thanks!
"TomKang2000" wrote:
> Hi,
> I have problem with &rs:Parameters=false it's not working if reports in a
> iframe;
> same url working well on a normal page; any trick? here is my url:
> http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and
> Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=false&date1=2006-05-01&date2=2006-05-02&unit_id=-1147471730&children=Y
> thanks in advance! /Tom
Showing posts with label page. Show all posts
Showing posts with label page. Show all posts
Thursday, March 22, 2012
Tuesday, March 6, 2012
"Either the computer running IIS is out of memory, or an incorrect session ID was sent in a
Has anyone ever seen this error? It's listed as SSCE_M_INVALIDRSCBID on this page.
That site also advises very clearly:
"If you experience any errors with the prefix "Internal error" while you use SQL Server Compact Edition, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques."
IIS 6.0 is located on a separate server from SQL Server 2005. Installation instructions from Microsoft.com were followed to a "T". I've spent a full day with our client's DBA enabling/disabling various settings on these two servers. Replication works fine if IIS is running on the same server. I'm confident our publication and web-sync settings are correct.
There is no firewall between these servers. They are on the same local network.
Have you been able to resolve this, noluck? I encountered the same problem. I posted it here before finding your post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1601966&SiteID=1
In my case, IIS and SQL Server are on the same machine.
"Either the computer running IIS is out of memory, or an incorrect session ID was sent in a
Has anyone ever seen this error? It's listed as SSCE_M_INVALIDRSCBID on this page.
That site also advises very clearly:
"If you experience any errors with the prefix "Internal error" while you use SQL Server Compact Edition, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques."
IIS 6.0 is located on a separate server from SQL Server 2005. Installation instructions from Microsoft.com were followed to a "T". I've spent a full day with our client's DBA enabling/disabling various settings on these two servers. Replication works fine if IIS is running on the same server. I'm confident our publication and web-sync settings are correct.
There is no firewall between these servers. They are on the same local network.
Have you been able to resolve this, noluck? I encountered the same problem. I posted it here before finding your post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1601966&SiteID=1
In my case, IIS and SQL Server are on the same machine.
Monday, February 13, 2012
%LIKE% GETDATE() query
Hi,
I'm building an ASP application in Dreamweaver MX2004 on the application the
user is aloud to inout a record. The following page has two recordsets, one
that returns the data that the user enterred in the previuos record and
another that identifies users who have requested that kind of information.
The first recordset however is where the problem lies as currently the
recordset is built based on two values - USERID and ADREFERENCE. The problem
with this is that it could return more than one record and then everything
becomes
. So I've thought about adding an additional parameter which
would be and Dateposted = GETDATE() obviously this wont work though as it
will be looking for a record posted the exact time, the question is would -
Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally withou
t
any complex SQL programming as i'm totaaly new to SQL
thanksYou can use DateDiff(dd, Dateposted , getdate())= 0 to do it.
Perayu
"GTN170777" <GTN170777@.discussions.microsoft.com> wrote in message
news:21F267E8-E6C6-4B78-AF25-CDB0B68B7137@.microsoft.com...
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application
> the
> user is aloud to inout a record. The following page has two recordsets,
> one
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The
> problem
> with this is that it could return more than one record and then everything
> becomes. So I've thought about adding an additional parameter
> which
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is
> would -
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally
> without
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||You can't use the LIKE comparison operator with datetime values, but you can
use BETWEEN. For example, if you wanted to find records within the last 5
minutes
SELECT ...
WHERE [Dateposted] BETWEEN DATEADD(mi, -5, GETDATE()) AND GETDATE()
For other ideas, take a look at the DATEADD and DATEDIFF functions in Books
Online.
"GTN170777" wrote:
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application t
he
> user is aloud to inout a record. The following page has two recordsets, on
e
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The probl
em
> with this is that it could return more than one record and then everything
> becomes. So I've thought about adding an additional parameter whi
ch
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is would
-
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally with
out
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The
> problem
> with this is that it could return more than one record and then everything
> becomes.
If you are using IDENTITY then after the insert you could select
SCOPE_IDENTITY() and keep track of that. Now, just
SELECT UserID, AdReference, DatePosted
FROM your_table
WHERE identity_column = whatever;
If you are not using IDENTITY and the key is UserID/AdReference/DateTime
then you could say:
SELECT TOP 1 UserID, AdReference, DatePosted
FROM your_table
ORDER BY DatePosted DESC;
> the question is would -
> Dateposted %LIKE% GETDATE work
No, there are all kinds of issues with this. First off, GETDATE() returns a
date, not a string. What you see when you SELECT GETDATE() or PRINT is not
how it's stored internally. So, you'd have to convert both sides to a
string, and this is not going to work well at all. Additionally, GETDATE()
when you run the select afterward is not going to contain the same value as
GETDATE() was when the insert happened. You could restrict the comparison
to the hour or to the day, but if they added two posts in that timeframe,
you would still get multiple rows back.
A|||"Perayu" wrote:
> You can use DateDiff(dd, Dateposted , getdate())= 0 to do it.
> Perayu
>
--The problem than can happen with this is
SELECT DATEDIFF(dd, '2006-01-24 23:59:59', '2006-01-25 00:00:01')
/*Returns 1, even though the two dates are only 2 seconds apart. Not a bug;
DATEDIFF counts the number of dividing boundaries crossed going from the
first date to the second date for the specified type of date differential */|||Thanks Mark, should have thought about that!!
"Mark Williams" wrote:
> You can't use the LIKE comparison operator with datetime values, but you c
an
> use BETWEEN. For example, if you wanted to find records within the last 5
> minutes
> SELECT ...
> WHERE [Dateposted] BETWEEN DATEADD(mi, -5, GETDATE()) AND GETDATE()
> For other ideas, take a look at the DATEADD and DATEDIFF functions in Book
s
> Online.
> --
>
> "GTN170777" wrote:
>|||But what if they had multiple posts in the last 5 minutes? You should be
designing your system so that you can identify a single row by more than the
fact that it fell within a certain time range. No matter how narrow you
make your window, it is possible that either (a) multiple rows will match or
(b) your window is too small to even capture the last insert.
> Thanks Mark, should have thought about that!!
> "Mark Williams" wrote:
>|||To compare datetime fields and ignore the time, do this
WHERE CONVERT(CHR(8), Dateposted ,112) = CONVERT(CHAR(8),GetDate(),112)
this would be the same as the following if Dateposted = 1/24/2006
WHERE '20060124' = '20060125'
But this probably would not solve your problem if the user could add more
than one record per day. The best solution is to use SCOPE_IDENTITY() as a
previous poster suggested.
kevin
"GTN170777" wrote:
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application t
he
> user is aloud to inout a record. The following page has two recordsets, on
e
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The probl
em
> with this is that it could return more than one record and then everything
> becomes. So I've thought about adding an additional parameter whi
ch
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is would
-
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally with
out
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||That sounded interesting, so I added IsLike(pattern) to my TDate UDT at
http://channel9.msdn.com/ShowPost.aspx?PostID=147390
Here is sample of usage:
DECLARE @.t table(
Date datetime
);
insert @.t SELECT '1/1/2005'
insert @.t select '1/2/2005'
insert @.t select '9/1/2005'
insert @.t select '4/4/2005'
insert @.t select '4/12/2005'
insert @.t select '10/20/2005'
insert @.t select '11/22/2005'
insert @.t select '12/25/2005'
-- Select any date in 2005 that has a day in the 20's.
select Date
from @.t
where TDate::FromSqlDateTime(Date).IsLike(''/2?/2005') = 1
-- Select any date that only has 1 digit in the month and 1 digit in the
day.
select Date
from @.t
where TDate::FromSqlDateTime(Date).IsLike('?/?/'') = 1
OUTPUT
Date
2005-10-20 00:00:00.000
2005-11-22 00:00:00.000
2005-12-25 00:00:00.000
Date
2005-01-01 00:00:00.000
2005-01-02 00:00:00.000
2005-09-01 00:00:00.000
2005-04-04 00:00:00.000
Kinda
.
--
William Stacey [MVP]
"GTN170777" <GTN170777@.discussions.microsoft.com> wrote in message
news:21F267E8-E6C6-4B78-AF25-CDB0B68B7137@.microsoft.com...
| Hi,
| I'm building an ASP application in Dreamweaver MX2004 on the application
the
| user is aloud to inout a record. The following page has two recordsets,
one
| that returns the data that the user enterred in the previuos record and
| another that identifies users who have requested that kind of information.
| The first recordset however is where the problem lies as currently the
| recordset is built based on two values - USERID and ADREFERENCE. The
problem
| with this is that it could return more than one record and then everything
| becomes. So I've thought about adding an additional parameter
which
| would be and Dateposted = GETDATE() obviously this wont work though as it
| will be looking for a record posted the exact time, the question is
would -
| Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally
without
| any complex SQL programming as i'm totaaly new to SQL
|
| thanks
I'm building an ASP application in Dreamweaver MX2004 on the application the
user is aloud to inout a record. The following page has two recordsets, one
that returns the data that the user enterred in the previuos record and
another that identifies users who have requested that kind of information.
The first recordset however is where the problem lies as currently the
recordset is built based on two values - USERID and ADREFERENCE. The problem
with this is that it could return more than one record and then everything
becomes
. So I've thought about adding an additional parameter whichwould be and Dateposted = GETDATE() obviously this wont work though as it
will be looking for a record posted the exact time, the question is would -
Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally withou
t
any complex SQL programming as i'm totaaly new to SQL
thanksYou can use DateDiff(dd, Dateposted , getdate())= 0 to do it.
Perayu
"GTN170777" <GTN170777@.discussions.microsoft.com> wrote in message
news:21F267E8-E6C6-4B78-AF25-CDB0B68B7137@.microsoft.com...
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application
> the
> user is aloud to inout a record. The following page has two recordsets,
> one
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The
> problem
> with this is that it could return more than one record and then everything
> becomes
. So I've thought about adding an additional parameter> which
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is
> would -
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally
> without
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||You can't use the LIKE comparison operator with datetime values, but you can
use BETWEEN. For example, if you wanted to find records within the last 5
minutes
SELECT ...
WHERE [Dateposted] BETWEEN DATEADD(mi, -5, GETDATE()) AND GETDATE()
For other ideas, take a look at the DATEADD and DATEDIFF functions in Books
Online.
"GTN170777" wrote:
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application t
he
> user is aloud to inout a record. The following page has two recordsets, on
e
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The probl
em
> with this is that it could return more than one record and then everything
> becomes
. So I've thought about adding an additional parameter which
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is would
-
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally with
out
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The
> problem
> with this is that it could return more than one record and then everything
> becomes
.If you are using IDENTITY then after the insert you could select
SCOPE_IDENTITY() and keep track of that. Now, just
SELECT UserID, AdReference, DatePosted
FROM your_table
WHERE identity_column = whatever;
If you are not using IDENTITY and the key is UserID/AdReference/DateTime
then you could say:
SELECT TOP 1 UserID, AdReference, DatePosted
FROM your_table
ORDER BY DatePosted DESC;
> the question is would -
> Dateposted %LIKE% GETDATE work
No, there are all kinds of issues with this. First off, GETDATE() returns a
date, not a string. What you see when you SELECT GETDATE() or PRINT is not
how it's stored internally. So, you'd have to convert both sides to a
string, and this is not going to work well at all. Additionally, GETDATE()
when you run the select afterward is not going to contain the same value as
GETDATE() was when the insert happened. You could restrict the comparison
to the hour or to the day, but if they added two posts in that timeframe,
you would still get multiple rows back.
A|||"Perayu" wrote:
> You can use DateDiff(dd, Dateposted , getdate())= 0 to do it.
> Perayu
>
--The problem than can happen with this is
SELECT DATEDIFF(dd, '2006-01-24 23:59:59', '2006-01-25 00:00:01')
/*Returns 1, even though the two dates are only 2 seconds apart. Not a bug;
DATEDIFF counts the number of dividing boundaries crossed going from the
first date to the second date for the specified type of date differential */|||Thanks Mark, should have thought about that!!
"Mark Williams" wrote:
> You can't use the LIKE comparison operator with datetime values, but you c
an
> use BETWEEN. For example, if you wanted to find records within the last 5
> minutes
> SELECT ...
> WHERE [Dateposted] BETWEEN DATEADD(mi, -5, GETDATE()) AND GETDATE()
> For other ideas, take a look at the DATEADD and DATEDIFF functions in Book
s
> Online.
> --
>
> "GTN170777" wrote:
>|||But what if they had multiple posts in the last 5 minutes? You should be
designing your system so that you can identify a single row by more than the
fact that it fell within a certain time range. No matter how narrow you
make your window, it is possible that either (a) multiple rows will match or
(b) your window is too small to even capture the last insert.
> Thanks Mark, should have thought about that!!
> "Mark Williams" wrote:
>|||To compare datetime fields and ignore the time, do this
WHERE CONVERT(CHR(8), Dateposted ,112) = CONVERT(CHAR(8),GetDate(),112)
this would be the same as the following if Dateposted = 1/24/2006
WHERE '20060124' = '20060125'
But this probably would not solve your problem if the user could add more
than one record per day. The best solution is to use SCOPE_IDENTITY() as a
previous poster suggested.
kevin
"GTN170777" wrote:
> Hi,
> I'm building an ASP application in Dreamweaver MX2004 on the application t
he
> user is aloud to inout a record. The following page has two recordsets, on
e
> that returns the data that the user enterred in the previuos record and
> another that identifies users who have requested that kind of information.
> The first recordset however is where the problem lies as currently the
> recordset is built based on two values - USERID and ADREFERENCE. The probl
em
> with this is that it could return more than one record and then everything
> becomes
. So I've thought about adding an additional parameter which
> would be and Dateposted = GETDATE() obviously this wont work though as it
> will be looking for a record posted the exact time, the question is would
-
> Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally with
out
> any complex SQL programming as i'm totaaly new to SQL
> thanks|||That sounded interesting, so I added IsLike(pattern) to my TDate UDT at
http://channel9.msdn.com/ShowPost.aspx?PostID=147390
Here is sample of usage:
DECLARE @.t table(
Date datetime
);
insert @.t SELECT '1/1/2005'
insert @.t select '1/2/2005'
insert @.t select '9/1/2005'
insert @.t select '4/4/2005'
insert @.t select '4/12/2005'
insert @.t select '10/20/2005'
insert @.t select '11/22/2005'
insert @.t select '12/25/2005'
-- Select any date in 2005 that has a day in the 20's.
select Date
from @.t
where TDate::FromSqlDateTime(Date).IsLike(''/2?/2005') = 1
-- Select any date that only has 1 digit in the month and 1 digit in the
day.
select Date
from @.t
where TDate::FromSqlDateTime(Date).IsLike('?/?/'') = 1
OUTPUT
Date
2005-10-20 00:00:00.000
2005-11-22 00:00:00.000
2005-12-25 00:00:00.000
Date
2005-01-01 00:00:00.000
2005-01-02 00:00:00.000
2005-09-01 00:00:00.000
2005-04-04 00:00:00.000
Kinda
.--
William Stacey [MVP]
"GTN170777" <GTN170777@.discussions.microsoft.com> wrote in message
news:21F267E8-E6C6-4B78-AF25-CDB0B68B7137@.microsoft.com...
| Hi,
| I'm building an ASP application in Dreamweaver MX2004 on the application
the
| user is aloud to inout a record. The following page has two recordsets,
one
| that returns the data that the user enterred in the previuos record and
| another that identifies users who have requested that kind of information.
| The first recordset however is where the problem lies as currently the
| recordset is built based on two values - USERID and ADREFERENCE. The
problem
| with this is that it could return more than one record and then everything
| becomes
. So I've thought about adding an additional parameterwhich
| would be and Dateposted = GETDATE() obviously this wont work though as it
| will be looking for a record posted the exact time, the question is
would -
| Dateposted %LIKE% GETDATE work, or is therer an alternative - ideally
without
| any complex SQL programming as i'm totaaly new to SQL
|
| thanks
Thursday, February 9, 2012
#### WISH LIST: next release #####
Hi:
I love SQL RS. Its awesome for a first release.
1) It would be nice to have a table of contents kind of thing on the report
manager home page. Something like a catalog, with the report names
hyperlinked, so that a user can browse through the catalog, instead of going
to each folder.
2) I love the matrix, but has a lot of bugs with subtotals/more than 3 row
groups. In these cases the export to excel doesnt work. Reports without excel
are no use. Hope these bugs get resolved in the next release.
3) HAve an option to open sub reports in a new window
4) Have access to the report pramaeter section, so that we can customize the
position.
5) Calender with dates parameters
6) Being able to hide parameters with the allow null option (SP1 fix doesnt
work on parameters whihc have the allow null option). Also why cant the allow
null have a fx (conditional).Thanks for the feedback. SQL 2005 Reporting Services will make you happier
in some areas of your feature list below but unfortunately not in some other
areas. Look for Beta 3 of SQL 2005 which will have a bunch of enhancements
for RS.
Any other feature requests, feel free to post or email me them.
Tom
"NI" <NI@.discussions.microsoft.com> wrote in message
news:405B957A-FEEF-4CA5-8E6A-8D74042D15E8@.microsoft.com...
> Hi:
> I love SQL RS. Its awesome for a first release.
> 1) It would be nice to have a table of contents kind of thing on the
> report
> manager home page. Something like a catalog, with the report names
> hyperlinked, so that a user can browse through the catalog, instead of
> going
> to each folder.
> 2) I love the matrix, but has a lot of bugs with subtotals/more than 3
> row
> groups. In these cases the export to excel doesnt work. Reports without
> excel
> are no use. Hope these bugs get resolved in the next release.
> 3) HAve an option to open sub reports in a new window
> 4) Have access to the report pramaeter section, so that we can customize
> the
> position.
> 5) Calender with dates parameters
> 6) Being able to hide parameters with the allow null option (SP1 fix
> doesnt
> work on parameters whihc have the allow null option). Also why cant the
> allow
> null have a fx (conditional).
>
I love SQL RS. Its awesome for a first release.
1) It would be nice to have a table of contents kind of thing on the report
manager home page. Something like a catalog, with the report names
hyperlinked, so that a user can browse through the catalog, instead of going
to each folder.
2) I love the matrix, but has a lot of bugs with subtotals/more than 3 row
groups. In these cases the export to excel doesnt work. Reports without excel
are no use. Hope these bugs get resolved in the next release.
3) HAve an option to open sub reports in a new window
4) Have access to the report pramaeter section, so that we can customize the
position.
5) Calender with dates parameters
6) Being able to hide parameters with the allow null option (SP1 fix doesnt
work on parameters whihc have the allow null option). Also why cant the allow
null have a fx (conditional).Thanks for the feedback. SQL 2005 Reporting Services will make you happier
in some areas of your feature list below but unfortunately not in some other
areas. Look for Beta 3 of SQL 2005 which will have a bunch of enhancements
for RS.
Any other feature requests, feel free to post or email me them.
Tom
"NI" <NI@.discussions.microsoft.com> wrote in message
news:405B957A-FEEF-4CA5-8E6A-8D74042D15E8@.microsoft.com...
> Hi:
> I love SQL RS. Its awesome for a first release.
> 1) It would be nice to have a table of contents kind of thing on the
> report
> manager home page. Something like a catalog, with the report names
> hyperlinked, so that a user can browse through the catalog, instead of
> going
> to each folder.
> 2) I love the matrix, but has a lot of bugs with subtotals/more than 3
> row
> groups. In these cases the export to excel doesnt work. Reports without
> excel
> are no use. Hope these bugs get resolved in the next release.
> 3) HAve an option to open sub reports in a new window
> 4) Have access to the report pramaeter section, so that we can customize
> the
> position.
> 5) Calender with dates parameters
> 6) Being able to hide parameters with the allow null option (SP1 fix
> doesnt
> work on parameters whihc have the allow null option). Also why cant the
> allow
> null have a fx (conditional).
>
Subscribe to:
Posts (Atom)