Jump to Report & Multi Value vs. Single Value

I have a parameterized main report that contains a link to a sub report with parameters. Then from the sub report I have a link that takes you back to main report. If I use multi value parameters or single value parameters the links going back and forth between the two reports works just dandy, when I run it on my PC. However when I deploy the reports to the Web Server, the link going from the sub report back to the main report only works if the parameters are single select. Going from the Main to the Sub it doesn’t matter.

This is the error I get using multi select parameters going from the sub report back to the main.

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

Any suggestions?

By any chance, are the drillthrough links located in the page header or page footer?

-- Robert

jump back from drill through generates blank page

Hello,
I have a main report that calls a subreport. In report manager, when I
drill from the main report to the subreport, everything is fine. However,
when I hit the IE back button I get a blank page. If I hit back again the
main report displays. This problem just started happening within the last
2 weeks. In the past I only had to hit back once. This problem occurs in
every report.

I have discovered that security patch KB916281
(http://support.microsoft.com/kb/916281) has caused this problem. It was
originally installed on June 19th. After I removed this hot fix, the back
button functioned as desired. Uninstalling this patch is not a feasable
solution. Does anyone know of a solution? Microsoft?

FYI: Report Server is on windows server 2003 with SQL SERVER/RS 2000 with latest service packs. I access the reports from IE on a MS 2000 professional OS.

Thanks,
Dan

Hi All,

I am also having the same problem. Somebody pls reply with a solution to it. This is an urgent issue.

Thanks

Deb
sql

jump back from drill through generates a blank page

Hello,
I have a main report that calls a subreport. In report manager, when I
drill from the main report to the subreport, everything is fine. However,
when I hit the IE back button I get a blank page. If I hit back again the
main report displays. This problem just started happening within the last
month. In the past I only had to hit back once. This problem occurs in
every report. Does anyone know why this is happening all of a sudden?
Maybe a MS patch is the cause?
FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
service packs.
Thanks,
Dan
--
___________________________
Daniel J. Zaccarine
Hanford Bay Associates, Ltd.
dan_zaccarine@.hanfordbay.com
http://www.hanfordbay.com
___________________________I have discovered that security patch KB916281
(http://support.microsoft.com/kb/916281) has caused this problem. It was
originally installed on June 19th. After I removed this hot fix, the back
button functioned as desired. Uninstalling this patch is not a feasable
solution. Does anyone know of a solution? Microsoft?
Thanks,
Dan
--
___________________________
Daniel J. Zaccarine
Hanford Bay Associates, Ltd.
dan_zaccarine@.hanfordbay.com
http://www.hanfordbay.com
___________________________
"Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
news:ups4dbmmGHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I have a main report that calls a subreport. In report manager, when I
> drill from the main report to the subreport, everything is fine. However,
> when I hit the IE back button I get a blank page. If I hit back again the
> main report displays. This problem just started happening within the last
> month. In the past I only had to hit back once. This problem occurs in
> every report. Does anyone know why this is happening all of a sudden?
> Maybe a MS patch is the cause?
> FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
> service packs.
> Thanks,
> Dan
> --
> ___________________________
> Daniel J. Zaccarine
> Hanford Bay Associates, Ltd.
> dan_zaccarine@.hanfordbay.com
> http://www.hanfordbay.com
> ___________________________
>|||I am having the same problem, but have not tried uninstalling the patch.
Has anyone seen a fix for this?
Regards,
Steve
"Dan" wrote:
> I have discovered that security patch KB916281
> (http://support.microsoft.com/kb/916281) has caused this problem. It was
> originally installed on June 19th. After I removed this hot fix, the back
> button functioned as desired. Uninstalling this patch is not a feasable
> solution. Does anyone know of a solution? Microsoft?
> Thanks,
> Dan
> --
> ___________________________
> Daniel J. Zaccarine
> Hanford Bay Associates, Ltd.
> dan_zaccarine@.hanfordbay.com
> http://www.hanfordbay.com
> ___________________________
> "Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
> news:ups4dbmmGHA.4064@.TK2MSFTNGP02.phx.gbl...
> > Hello,
> > I have a main report that calls a subreport. In report manager, when I
> > drill from the main report to the subreport, everything is fine. However,
> > when I hit the IE back button I get a blank page. If I hit back again the
> > main report displays. This problem just started happening within the last
> > month. In the past I only had to hit back once. This problem occurs in
> > every report. Does anyone know why this is happening all of a sudden?
> > Maybe a MS patch is the cause?
> > FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
> > service packs.
> >
> > Thanks,
> > Dan
> >
> > --
> > ___________________________
> >
> > Daniel J. Zaccarine
> > Hanford Bay Associates, Ltd.
> > dan_zaccarine@.hanfordbay.com
> > http://www.hanfordbay.com
> > ___________________________
> >
> >
>
>|||Un-installing the security fix does correct the problem, however our network
guys aren't hip to un-installing it. We called Microsoft with one of our
calls but they don't consider it a bug.
If anybody comes up with something, let me know.
"Steve" wrote:
> I am having the same problem, but have not tried uninstalling the patch.
> Has anyone seen a fix for this?
> Regards,
> Steve
> "Dan" wrote:
> > I have discovered that security patch KB916281
> > (http://support.microsoft.com/kb/916281) has caused this problem. It was
> > originally installed on June 19th. After I removed this hot fix, the back
> > button functioned as desired. Uninstalling this patch is not a feasable
> > solution. Does anyone know of a solution? Microsoft?
> >
> > Thanks,
> > Dan
> >
> > --
> > ___________________________
> >
> > Daniel J. Zaccarine
> > Hanford Bay Associates, Ltd.
> > dan_zaccarine@.hanfordbay.com
> > http://www.hanfordbay.com
> > ___________________________
> > "Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
> > news:ups4dbmmGHA.4064@.TK2MSFTNGP02.phx.gbl...
> > > Hello,
> > > I have a main report that calls a subreport. In report manager, when I
> > > drill from the main report to the subreport, everything is fine. However,
> > > when I hit the IE back button I get a blank page. If I hit back again the
> > > main report displays. This problem just started happening within the last
> > > month. In the past I only had to hit back once. This problem occurs in
> > > every report. Does anyone know why this is happening all of a sudden?
> > > Maybe a MS patch is the cause?
> > > FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
> > > service packs.
> > >
> > > Thanks,
> > > Dan
> > >
> > > --
> > > ___________________________
> > >
> > > Daniel J. Zaccarine
> > > Hanford Bay Associates, Ltd.
> > > dan_zaccarine@.hanfordbay.com
> > > http://www.hanfordbay.com
> > > ___________________________
> > >
> > >
> >
> >
> >|||Alec,
Now that's amusing.. You hit the back button, get a blank page and it's not
a bug.
Thanks for the info.
Good luck...
Regards,
Steve
"Alec Hardy" wrote:
> Un-installing the security fix does correct the problem, however our network
> guys aren't hip to un-installing it. We called Microsoft with one of our
> calls but they don't consider it a bug.
> If anybody comes up with something, let me know.
>
> "Steve" wrote:
> > I am having the same problem, but have not tried uninstalling the patch.
> >
> > Has anyone seen a fix for this?
> >
> > Regards,
> > Steve
> >
> > "Dan" wrote:
> >
> > > I have discovered that security patch KB916281
> > > (http://support.microsoft.com/kb/916281) has caused this problem. It was
> > > originally installed on June 19th. After I removed this hot fix, the back
> > > button functioned as desired. Uninstalling this patch is not a feasable
> > > solution. Does anyone know of a solution? Microsoft?
> > >
> > > Thanks,
> > > Dan
> > >
> > > --
> > > ___________________________
> > >
> > > Daniel J. Zaccarine
> > > Hanford Bay Associates, Ltd.
> > > dan_zaccarine@.hanfordbay.com
> > > http://www.hanfordbay.com
> > > ___________________________
> > > "Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
> > > news:ups4dbmmGHA.4064@.TK2MSFTNGP02.phx.gbl...
> > > > Hello,
> > > > I have a main report that calls a subreport. In report manager, when I
> > > > drill from the main report to the subreport, everything is fine. However,
> > > > when I hit the IE back button I get a blank page. If I hit back again the
> > > > main report displays. This problem just started happening within the last
> > > > month. In the past I only had to hit back once. This problem occurs in
> > > > every report. Does anyone know why this is happening all of a sudden?
> > > > Maybe a MS patch is the cause?
> > > > FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
> > > > service packs.
> > > >
> > > > Thanks,
> > > > Dan
> > > >
> > > > --
> > > > ___________________________
> > > >
> > > > Daniel J. Zaccarine
> > > > Hanford Bay Associates, Ltd.
> > > > dan_zaccarine@.hanfordbay.com
> > > > http://www.hanfordbay.com
> > > > ___________________________
> > > >
> > > >
> > >
> > >
> > >|||Does anyone know of an update that will fix this?
It really does detract from the overall feel of the product.
Thanks...
Regards,
Steve
"Steve" wrote:
> Alec,
> Now that's amusing.. You hit the back button, get a blank page and it's not
> a bug.
> Thanks for the info.
> Good luck...
> Regards,
> Steve
> "Alec Hardy" wrote:
> > Un-installing the security fix does correct the problem, however our network
> > guys aren't hip to un-installing it. We called Microsoft with one of our
> > calls but they don't consider it a bug.
> >
> > If anybody comes up with something, let me know.
> >
> >
> > "Steve" wrote:
> >
> > > I am having the same problem, but have not tried uninstalling the patch.
> > >
> > > Has anyone seen a fix for this?
> > >
> > > Regards,
> > > Steve
> > >
> > > "Dan" wrote:
> > >
> > > > I have discovered that security patch KB916281
> > > > (http://support.microsoft.com/kb/916281) has caused this problem. It was
> > > > originally installed on June 19th. After I removed this hot fix, the back
> > > > button functioned as desired. Uninstalling this patch is not a feasable
> > > > solution. Does anyone know of a solution? Microsoft?
> > > >
> > > > Thanks,
> > > > Dan
> > > >
> > > > --
> > > > ___________________________
> > > >
> > > > Daniel J. Zaccarine
> > > > Hanford Bay Associates, Ltd.
> > > > dan_zaccarine@.hanfordbay.com
> > > > http://www.hanfordbay.com
> > > > ___________________________
> > > > "Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
> > > > news:ups4dbmmGHA.4064@.TK2MSFTNGP02.phx.gbl...
> > > > > Hello,
> > > > > I have a main report that calls a subreport. In report manager, when I
> > > > > drill from the main report to the subreport, everything is fine. However,
> > > > > when I hit the IE back button I get a blank page. If I hit back again the
> > > > > main report displays. This problem just started happening within the last
> > > > > month. In the past I only had to hit back once. This problem occurs in
> > > > > every report. Does anyone know why this is happening all of a sudden?
> > > > > Maybe a MS patch is the cause?
> > > > > FYI: I am using windows server 2003 with SQL SERVER/RS 2000 with latest
> > > > > service packs.
> > > > >
> > > > > Thanks,
> > > > > Dan
> > > > >
> > > > > --
> > > > > ___________________________
> > > > >
> > > > > Daniel J. Zaccarine
> > > > > Hanford Bay Associates, Ltd.
> > > > > dan_zaccarine@.hanfordbay.com
> > > > > http://www.hanfordbay.com
> > > > > ___________________________
> > > > >
> > > > >
> > > >
> > > >
> > > >

Julian to Gregorian and Gregorian to Julian

Are there SQL functions to convert back and forth between these two?
TIA for the help.
-- Posted with NewsLeecher v3.0 Beta 6
-- http://www.newsleecher.com/?usenetmyob@.beatles.com wrote:

> Are there SQL functions to convert back and forth between these two?
> TIA for the help.
> -- Posted with NewsLeecher v3.0 Beta 6
> -- http://www.newsleecher.com/?usenet
Not in SQL Server. This is a hard problem because no single,
universally valid conversion between Julian and Gregorian is possible.
The answer depends on what time, place and proleptic calendar you take
as your reference point. I suggest you create your own Calendar table
to do the conversion.
The last word on all the messy details can be found here:
http://www.tondering.dk/claus/calendar.html
David Portas
SQL Server MVP
--|||David Portas wrote:
> Not in SQL Server. This is a hard problem because no single,
> universally valid conversion between Julian and Gregorian is possible.
Clarification: What I mean is that any conversion you choose to apply
may or may not be factually, historically or legally accurate dependent
on geography and the date in question. You can of course choose to use
a single conversion but its validity may be only theoretical.
David Portas
SQL Server MVP
--

Joining tables

I have two tables one table T1 only have one result per date table 2 T2 can
range from 0 to 8 results per date,
I want to pull back all of the results in T2 and sum the totals, in my
example it will be summing "Stafftime" and "items", in T1 I need to sum the
"Contrctaed_Hours" and the OverTime. when I do sum the contracted Time I am
getting 61200, as there ate 2 rows in T1.
How can I sum my four colums but only get results for one Date in the T1
table'
Cheers
Mark
Select *
From T1
T1
Row_Date Contracted_Hours OverTime Ext_No
20050209 30600 0 4227
Select *
From T2
T2
RowDate Area Ext_No StaffTime Items
20050209 1 4227 24656 50
20050209 2 4227 6164 10
Select T1.RowDate, T1.Ext_No, sum(Contracted_Hours) as Con_Hrs,
Sum(OverTime) as OT, Sum(Items) as Completed_Work
From T1
Inner Join T2
On T1.Ext_No = T2.Ext_No
Where RowDate = '20050209' and Ext = 4227Try,
Select
T1.RowDate,
T1.Ext_No,
sum(distinct T1.Contracted_Hours) as Con_Hrs,
Sum(distinct T1.OverTime) as OT,
(select Sum(T2.Items) from T2 where T2.RowDate = T1.RowDate and T1.Ext_No =
T2.Ext_No) as Completed_Work
From
T1
Where
T1.RowDate = '20050209' and T1.Ext_No = 4227
go
AMB
"sh0t2bts" wrote:

> I have two tables one table T1 only have one result per date table 2 T2 ca
n
> range from 0 to 8 results per date,
> I want to pull back all of the results in T2 and sum the totals, in my
> example it will be summing "Stafftime" and "items", in T1 I need to sum th
e
> "Contrctaed_Hours" and the OverTime. when I do sum the contracted Time I a
m
> getting 61200, as there ate 2 rows in T1.
>
> How can I sum my four colums but only get results for one Date in the T1
> table'
>
> Cheers
> Mark
> Select *
> From T1
> T1
> Row_Date Contracted_Hours OverTime Ext_No
> 20050209 30600 0 4227
> Select *
> From T2
> T2
> RowDate Area Ext_No StaffTime Items
> 20050209 1 4227 24656 50
> 20050209 2 4227 6164 10
> Select T1.RowDate, T1.Ext_No, sum(Contracted_Hours) as Con_Hrs,
> Sum(OverTime) as OT, Sum(Items) as Completed_Work
> From T1
> Inner Join T2
> On T1.Ext_No = T2.Ext_No
> Where RowDate = '20050209' and Ext = 4227
>
>|||I think you have to use LEFT OUTER JOIN.
"sh0t2bts" wrote:

> I have two tables one table T1 only have one result per date table 2 T2 ca
n
> range from 0 to 8 results per date,
> I want to pull back all of the results in T2 and sum the totals, in my
> example it will be summing "Stafftime" and "items", in T1 I need to sum th
e
> "Contrctaed_Hours" and the OverTime. when I do sum the contracted Time I a
m
> getting 61200, as there ate 2 rows in T1.
>
> How can I sum my four colums but only get results for one Date in the T1
> table'
>
> Cheers
> Mark
> Select *
> From T1
> T1
> Row_Date Contracted_Hours OverTime Ext_No
> 20050209 30600 0 4227
> Select *
> From T2
> T2
> RowDate Area Ext_No StaffTime Items
> 20050209 1 4227 24656 50
> 20050209 2 4227 6164 10
> Select T1.RowDate, T1.Ext_No, sum(Contracted_Hours) as Con_Hrs,
> Sum(OverTime) as OT, Sum(Items) as Completed_Work
> From T1
> Inner Join T2
> On T1.Ext_No = T2.Ext_No
> Where RowDate = '20050209' and Ext = 4227
>
>|||SELECT
T1.RowDate,
T1.Ext_No,
T1.Contracted_Hours,
T1.OverTime,
T2.StaffTime,
T2.Items
FROM
T1
INNER JOIN
(
SELECT
T2.RowDate,
T2.Ext_No,
SUM(StaffTime),
SUM(Items)
FROM
T2
GROUP BY
T2.RowDate,
T2.Ext_No
) T2group
ON T2group.Ext_No = T1.Ext_No
AND T2group.RowDate = T1.Row_Date
"sh0t2bts" wrote:

> I have two tables one table T1 only have one result per date table 2 T2 ca
n
> range from 0 to 8 results per date,
> I want to pull back all of the results in T2 and sum the totals, in my
> example it will be summing "Stafftime" and "items", in T1 I need to sum th
e
> "Contrctaed_Hours" and the OverTime. when I do sum the contracted Time I a
m
> getting 61200, as there ate 2 rows in T1.
>
> How can I sum my four colums but only get results for one Date in the T1
> table'
>
> Cheers
> Mark
> Select *
> From T1
> T1
> Row_Date Contracted_Hours OverTime Ext_No
> 20050209 30600 0 4227
> Select *
> From T2
> T2
> RowDate Area Ext_No StaffTime Items
> 20050209 1 4227 24656 50
> 20050209 2 4227 6164 10
> Select T1.RowDate, T1.Ext_No, sum(Contracted_Hours) as Con_Hrs,
> Sum(OverTime) as OT, Sum(Items) as Completed_Work
> From T1
> Inner Join T2
> On T1.Ext_No = T2.Ext_No
> Where RowDate = '20050209' and Ext = 4227
>
>