Closing IE Window used for exporting...

Taken from Reporting Services 2000 Help - 'When you click Export, the report
opens in a new browser window, in a viewer that is associated with the export
format. If in Step 2 you clicked TIFF, the report is displayed in a viewer
that supports TIFF file types.'
Is there any way to close this new browser window so it does not stay behind
and make the user close it?
Thanks for any input!Hi rheath,
Welcome to use MSDN Managed Newsgroup Support.
It is a by design issue in Reporting Service 2000 and was resolved in
Reporting Service 2005. If you try to export a report in Reporting Services
2005, the browser window will close and do not need to manually close it.
Thanks for your understanding.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Wei,
Do the reports have to be designed using Visual Studio 2005. I ask because
we are developing the reports using Visual Studio 2003 and depolying to a
Reporting Services 2005 server and I still get the browser window that does
not close when exporting.
Thanks,
Russ
"Wei Lu" wrote:
> Hi rheath,
> Welcome to use MSDN Managed Newsgroup Support.
> It is a by design issue in Reporting Service 2000 and was resolved in
> Reporting Service 2005. If you try to export a report in Reporting Services
> 2005, the browser window will close and do not need to manually close it.
> Thanks for your understanding.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hi Russ,
Thanks for the update.
I have tested on my side. I deploy a report to Report Services 2005 using
VS 2003. I get the browser closed when exporting.
Would you please test on another machine to access the report server and
try to export the report?
Does this issue occur?
Sincerely,
Wei Lu
Microsoft Online Community 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.

close

Below, I have pasted a portion of an MS MSDN article dealing with a specific issue we are having with Report Server performance. The URL (http://support.microsoft.com/kb/821438/en-us) is the MS KB article on the described fix. The fix mentioned is for "ASP.NET 1.1" but our BP Report Server is using "ASP.NET 2.0".

Has anyone encountered and resolved and how?

Running on box:
ASP.NET 2.0.50727;
SSRS 2005 Sp1 + Hotfix#2175;
Win Server 2003, R2, x64, SP1
Trend Micro OfficeScan Cleint for Win 2003/xp v7.3
IIS Version (I cannot find this #) - ? IE 6.0

===========================
Report Manager or the report server runs very slowly

In some circumstances, ASP.NET applications run very slowly on computers that are running anti-virus software. If the Report Server Web service is restarting frequently, and you are running anti-virus software, you can obtain an ASP.NET fix from Microsoft Customer Support Services.

Symptoms include Web applications or Application Domains restarting for no apparent reason, slow performance, session restarts, and more. For more information about the symptoms, cause, and resolution, see Microsoft Knowledge Base article 821438.

You can find out whether there are excessive server restarts by viewing the number of reportserver_<timestamp>.log files. A new log is created each time the server starts. A large collection of logs created at very short intervals is an indication that the conditions described in article 821438 exist on your server
===========================

It appears the issue goes away with SQL2K5 SP-2 load. Thanks to whoever.....

Clocking Report

Hi,

I have to report the clocking for our company employees. The main clocking table is just employee number & Date/Time clocked. An employee can have any number of clockings per day.

Would it be possible to create a select statement so that there is just 1 row per day for each employee?

[Table Rows]

piet, 2007-02-23 07:59

piet, 2007-02-23 13:01

piet, 2007-02-23 13:55

piet, 2007-02-23 16:35

[Result for SQL statment]

Piet, 2007-02-23, 07:59, 13:01, 13:55, 16:35

Any help will appreciated.

Thanks

Search for Dynamic Pivot and you will find solutions for problems similiar to your post.

Client-side printing hangs IE

Hi,
When I try to print a report using client-side printing in SP2, I get the
Print dialog fine, then when I click 'OK' I get the 'Printing now...' popup,
but IE hangs instantly. I've tried removing the ActiveX component and
reregistering it but to no avail. However, it works fine on other machines
that we have. Rendering to PDF works fine, so the report itself must be OK.
Is anyone else seeing the same problem, or have any ideas about what could
be causing it?
Thanks,
Chris.I found that being logged in as Administrator works perfectly, so it seems
to be some sort of permissions issue on the server. Do I need to change any
security settings in IIS or folder security on the report server?
Interestingly, the Export feature doesn't work unless the user has
administrative rights on the local machine.
Any ideas?
Chris.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
> Hi,
> When I try to print a report using client-side printing in SP2, I get the
> Print dialog fine, then when I click 'OK' I get the 'Printing now...'
> popup, but IE hangs instantly. I've tried removing the ActiveX component
> and reregistering it but to no avail. However, it works fine on other
> machines that we have. Rendering to PDF works fine, so the report itself
> must be OK.
> Is anyone else seeing the same problem, or have any ideas about what could
> be causing it?
> Thanks,
> Chris.
>|||It sounds like a permissions issue. Can you export to Web Archive as a non
admin? Both of these features use the users temp directory for storing some
data, can you see if the users has write permission on his %temp% directory?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>I found that being logged in as Administrator works perfectly, so it seems
>to be some sort of permissions issue on the server. Do I need to change
>any security settings in IIS or folder security on the report server?
> Interestingly, the Export feature doesn't work unless the user has
> administrative rights on the local machine.
> Any ideas?
> Chris.
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get the
>> Print dialog fine, then when I click 'OK' I get the 'Printing now...'
>> popup, but IE hangs instantly. I've tried removing the ActiveX component
>> and reregistering it but to no avail. However, it works fine on other
>> machines that we have. Rendering to PDF works fine, so the report itself
>> must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>|||Even when the user has full administrative rights on the local machine,
client-side printing still doesn't work. The user has full access to the
temp directory, and can export to both PDF and Web Archive formats.
Client-side printing only works when the user has administrative rights to
the domain. Maybe it is a setting in IIS, any ideas?
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> It sounds like a permissions issue. Can you export to Web Archive as a
> non admin? Both of these features use the users temp directory for
> storing some data, can you see if the users has write permission on his
> %temp% directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it seems
>>to be some sort of permissions issue on the server. Do I need to change
>>any security settings in IIS or folder security on the report server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the ActiveX
>> component and reregistering it but to no avail. However, it works fine
>> on other machines that we have. Rendering to PDF works fine, so the
>> report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>|||It is doubtful that it is an IIS setting. Are there any policies that block
ActiveX controls?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
> Even when the user has full administrative rights on the local machine,
> client-side printing still doesn't work. The user has full access to the
> temp directory, and can export to both PDF and Web Archive formats.
> Client-side printing only works when the user has administrative rights to
> the domain. Maybe it is a setting in IIS, any ideas?
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
>> It sounds like a permissions issue. Can you export to Web Archive as a
>> non admin? Both of these features use the users temp directory for
>> storing some data, can you see if the users has write permission on his
>> %temp% directory?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it
>>seems to be some sort of permissions issue on the server. Do I need to
>>change any security settings in IIS or folder security on the report
>>server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the ActiveX
>> component and reregistering it but to no avail. However, it works fine
>> on other machines that we have. Rendering to PDF works fine, so the
>> report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>>
>|||No, the ActiveX control installs fine, and I get the print dialog, but then
it hangs when I print (or print preview) after that. We have no problems
with other ActiveX controls.
Chris.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:e$CvMMNTFHA.3848@.TK2MSFTNGP10.phx.gbl...
> It is doubtful that it is an IIS setting. Are there any policies that
> block ActiveX controls?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
>> Even when the user has full administrative rights on the local machine,
>> client-side printing still doesn't work. The user has full access to the
>> temp directory, and can export to both PDF and Web Archive formats.
>> Client-side printing only works when the user has administrative rights
>> to the domain. Maybe it is a setting in IIS, any ideas?
>> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
>> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
>> It sounds like a permissions issue. Can you export to Web Archive as a
>> non admin? Both of these features use the users temp directory for
>> storing some data, can you see if the users has write permission on his
>> %temp% directory?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it
>>seems to be some sort of permissions issue on the server. Do I need to
>>change any security settings in IIS or folder security on the report
>>server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the
>> ActiveX component and reregistering it but to no avail. However, it
>> works fine on other machines that we have. Rendering to PDF works
>> fine, so the report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>>
>>
>|||Try this...I think you may be missing RSClientPrint.Authenticate = false;
function Print()
{
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print('http://unisys1/reportserver',
'/Test/LMMISInquiry/RECIPIENTREIMBURSEMENT/ReportsAndLetters/AvgTurnaroundTime', 'AvgTurnaroundTime');
}
"Chris Childs" wrote:
> No, the ActiveX control installs fine, and I get the print dialog, but then
> it hangs when I print (or print preview) after that. We have no problems
> with other ActiveX controls.
> Chris.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:e$CvMMNTFHA.3848@.TK2MSFTNGP10.phx.gbl...
> > It is doubtful that it is an IIS setting. Are there any policies that
> > block ActiveX controls?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> > news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
> >> Even when the user has full administrative rights on the local machine,
> >> client-side printing still doesn't work. The user has full access to the
> >> temp directory, and can export to both PDF and Web Archive formats.
> >> Client-side printing only works when the user has administrative rights
> >> to the domain. Maybe it is a setting in IIS, any ideas?
> >>
> >> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> >> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> >> It sounds like a permissions issue. Can you export to Web Archive as a
> >> non admin? Both of these features use the users temp directory for
> >> storing some data, can you see if the users has write permission on his
> >> %temp% directory?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> >> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
> >>I found that being logged in as Administrator works perfectly, so it
> >>seems to be some sort of permissions issue on the server. Do I need to
> >>change any security settings in IIS or folder security on the report
> >>server?
> >>
> >> Interestingly, the Export feature doesn't work unless the user has
> >> administrative rights on the local machine.
> >>
> >> Any ideas?
> >>
> >> Chris.
> >>
> >> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> >> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
> >> Hi,
> >>
> >> When I try to print a report using client-side printing in SP2, I get
> >> the Print dialog fine, then when I click 'OK' I get the 'Printing
> >> now...' popup, but IE hangs instantly. I've tried removing the
> >> ActiveX component and reregistering it but to no avail. However, it
> >> works fine on other machines that we have. Rendering to PDF works
> >> fine, so the report itself must be OK.
> >>
> >> Is anyone else seeing the same problem, or have any ideas about what
> >> could be causing it?
> >>
> >> Thanks,
> >>
> >> Chris.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Client-side Printing and page hesitation

When printing reports from my normal computer to my default printer, all but
one report print without any hesitation between pages. My boss prints
reports and gets a lot of hesitation between pages for most of the reports.
If I print to a differnt printer I too get a lot of hesitation betwen pages.
Does SRS print pages as graphics or as text? Are there any settings on the
server that can alter printing performance? Anyone else having issues with
print hesitation and found a solution to the problem?When u want 2 controll the print properties u should set them at the Report
Properties->layout.
All properties in this tab are 4 the print setting.
"Rob 'Spike' Stevens" wrote:
> When printing reports from my normal computer to my default printer, all but
> one report print without any hesitation between pages. My boss prints
> reports and gets a lot of hesitation between pages for most of the reports.
> If I print to a differnt printer I too get a lot of hesitation betwen pages.
> Does SRS print pages as graphics or as text? Are there any settings on the
> server that can alter printing performance? Anyone else having issues with
> print hesitation and found a solution to the problem?

Client Side Printing SQL Report

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

We're using "OfficeWriter" by a company called SoftArtisans. Note, it's not cheap.|||

I see - I'm looking for the ability to print the report only no need for all the other features - Thanks for your reply...

rich

|||

rperreta wrote:

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

Why aren't you using the exporting features from RS? The client can preview and then export to the available formats, with the capability to save them AND print them.|||You can try Windows Script Host for clientside object creation and printing. It is Free by Microsoft.
http://msdn.microsoft.com/library/en-us/script56/html/wsconswitchingnetworkedprintersonoff.asp?frame=true
Regards,
Hemchand|||Hello!
I may not understand on "How To Print a Report in SQL Report in Asp.Net" but in the latest Service Pack 2 for Reporting Services there was an Active X control that displays an Icon on the toolbar that provides for direct printing of a Reporting Services report directly to any printer on your network.
From MS www site:
Key Functional EnhancementsReports can now be printed directly from within Internet Explorer. A Microsoft ActiveX control is provided to support a rich client-side printing experience including full page preview.|||

hi,

i would like to check where do u find the RSClientprint.dll? i try search my pc for the dll file but invalid.

if any1 can tell mi where to find it..greatly appreciated

your regards

angela

|||Hello:
There is a CAB file RSCLIENTPRINT in
(at least on my server) c:\Program files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
I just then moved the dll's to the bin directory within the same directory structure above.
Best Reagrds,
|||hi,
i know of the active x print that will call the print frm RSClientPrint but the main issue that i concern is how can i not display the print dialog box where by it prompt the user to select the printer and print. Because i want to print the report automatically once i evoke a print button on my .net application. is there any ways to do it?
cheers
Angela|||

hooligannes97 wrote:

rperreta wrote:

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

Why aren't you using the exporting features from RS? The client can preview and then export to the available formats, with the capability to save them AND print them.

RS? Microsoft Reporting Services?|||

rperreta wrote:

RS? Microsoft Reporting Services?

Correct

Client Side Print - An error occured during printing. (ox80070006)

When trying to print a report using the ActiveX control in Internet
Explorer I get the following error:
An error occured during printing. (ox80070006)
After some experimenting I found I was able to print (same client
computer / same server) to a file using the Generic / Text Only printer
driver and the Microsoft Office Document Image Writer.
So based on that I assumed the problem wasn't with the server.
Next I tried hooking my printer directly to my computer. The same
error occured.
I then tried a separate computer that printed to a separeate computer
and it worked.
Based on this I am assuming there is a issue with my printer / printer
driver and the ActiveX control.
My printer is a Samsung ML-1430.
I wanted to report this to the Reporting Services Team and see if
anyone else had any similar problems with other printers.
Thanks,
Warren Hales
P.S. I am new to Reporting Services and I have to say I am VERY
impressed. The Reporting Services Team has done a great job (IMHO).
It is an excellent example of an application with a SOA.Have you tried making sure you have a recent print driver? There have been
reports about printing problems going away once they updated the print
drivers.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Warren Hales" <warrenhales@.hotmail.com> wrote in message
news:1116604481.414270.179770@.g14g2000cwa.googlegroups.com...
> When trying to print a report using the ActiveX control in Internet
> Explorer I get the following error:
> An error occured during printing. (ox80070006)
> After some experimenting I found I was able to print (same client
> computer / same server) to a file using the Generic / Text Only printer
> driver and the Microsoft Office Document Image Writer.
> So based on that I assumed the problem wasn't with the server.
> Next I tried hooking my printer directly to my computer. The same
> error occured.
> I then tried a separate computer that printed to a separeate computer
> and it worked.
> Based on this I am assuming there is a issue with my printer / printer
> driver and the ActiveX control.
> My printer is a Samsung ML-1430.
> I wanted to report this to the Reporting Services Team and see if
> anyone else had any similar problems with other printers.
> Thanks,
> Warren Hales
> P.S. I am new to Reporting Services and I have to say I am VERY
> impressed. The Reporting Services Team has done a great job (IMHO).
> It is an excellent example of an application with a SOA.
>|||Hey Bruce.
I did download the latest print driver from Samsung and had the same
problem. I even tried a print driver from a compatible Samsung print
driver and that didn't work either.
One weird thing I found. If you click on the "printer" button in the
print dialog box, close it and then click print it gets a bit farther
along in the process. It prints a blank page and then shows the error
message.
Bruce L-C [MVP] wrote:
> Have you tried making sure you have a recent print driver? There have
been
> reports about printing problems going away once they updated the
print
> drivers.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Warren Hales" <warrenhales@.hotmail.com> wrote in message
> news:1116604481.414270.179770@.g14g2000cwa.googlegroups.com...
> > When trying to print a report using the ActiveX control in Internet
> > Explorer I get the following error:
> >
> > An error occured during printing. (ox80070006)
> >
> > After some experimenting I found I was able to print (same client
> > computer / same server) to a file using the Generic / Text Only
printer
> > driver and the Microsoft Office Document Image Writer.
> >
> > So based on that I assumed the problem wasn't with the server.
> >
> > Next I tried hooking my printer directly to my computer. The same
> > error occured.
> >
> > I then tried a separate computer that printed to a separeate
computer
> > and it worked.
> >
> > Based on this I am assuming there is a issue with my printer /
printer
> > driver and the ActiveX control.
> >
> > My printer is a Samsung ML-1430.
> >
> > I wanted to report this to the Reporting Services Team and see if
> > anyone else had any similar problems with other printers.
> >
> > Thanks,
> >
> > Warren Hales
> >
> > P.S. I am new to Reporting Services and I have to say I am VERY
> > impressed. The Reporting Services Team has done a great job
(IMHO).
> > It is an excellent example of an application with a SOA.
> >|||On of the problems might be the size of the print job that we send to the
printer. We are currently using a format called EMF + Dual which is pretty
hefty. We are looking whether we can trim it down in SQL 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Warren Hales" <warrenhales@.hotmail.com> wrote in message
news:1116688171.637976.68360@.g47g2000cwa.googlegroups.com...
> Hey Bruce.
> I did download the latest print driver from Samsung and had the same
> problem. I even tried a print driver from a compatible Samsung print
> driver and that didn't work either.
> One weird thing I found. If you click on the "printer" button in the
> print dialog box, close it and then click print it gets a bit farther
> along in the process. It prints a blank page and then shows the error
> message.
> Bruce L-C [MVP] wrote:
>> Have you tried making sure you have a recent print driver? There have
> been
>> reports about printing problems going away once they updated the
> print
>> drivers.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Warren Hales" <warrenhales@.hotmail.com> wrote in message
>> news:1116604481.414270.179770@.g14g2000cwa.googlegroups.com...
>> > When trying to print a report using the ActiveX control in Internet
>> > Explorer I get the following error:
>> >
>> > An error occured during printing. (ox80070006)
>> >
>> > After some experimenting I found I was able to print (same client
>> > computer / same server) to a file using the Generic / Text Only
> printer
>> > driver and the Microsoft Office Document Image Writer.
>> >
>> > So based on that I assumed the problem wasn't with the server.
>> >
>> > Next I tried hooking my printer directly to my computer. The same
>> > error occured.
>> >
>> > I then tried a separate computer that printed to a separeate
> computer
>> > and it worked.
>> >
>> > Based on this I am assuming there is a issue with my printer /
> printer
>> > driver and the ActiveX control.
>> >
>> > My printer is a Samsung ML-1430.
>> >
>> > I wanted to report this to the Reporting Services Team and see if
>> > anyone else had any similar problems with other printers.
>> >
>> > Thanks,
>> >
>> > Warren Hales
>> >
>> > P.S. I am new to Reporting Services and I have to say I am VERY
>> > impressed. The Reporting Services Team has done a great job
> (IMHO).
>> > It is an excellent example of an application with a SOA.
>> >
>|||FYI - I am seeing the same problem from one of our servers. The strange
thing is that I can print fine on two other servers that have SP2 installed
from the same reports on the same printers. One of the servers where the
printing is working was recently built (with SP2) and the other was upgraded
from SP1 to SP2 recently, so I can't see any pattern of when, where and why
this error is happening. It is failing on most of our reports that span 1
page (small reports as well as large ones). Any help is appreciated,
Brad Peterman
"Brian Welcker [MSFT]" wrote:
> On of the problems might be the size of the print job that we send to the
> printer. We are currently using a format called EMF + Dual which is pretty
> hefty. We are looking whether we can trim it down in SQL 2005.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Warren Hales" <warrenhales@.hotmail.com> wrote in message
> news:1116688171.637976.68360@.g47g2000cwa.googlegroups.com...
> > Hey Bruce.
> >
> > I did download the latest print driver from Samsung and had the same
> > problem. I even tried a print driver from a compatible Samsung print
> > driver and that didn't work either.
> >
> > One weird thing I found. If you click on the "printer" button in the
> > print dialog box, close it and then click print it gets a bit farther
> > along in the process. It prints a blank page and then shows the error
> > message.
> >
> > Bruce L-C [MVP] wrote:
> >> Have you tried making sure you have a recent print driver? There have
> > been
> >> reports about printing problems going away once they updated the
> > print
> >> drivers.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Warren Hales" <warrenhales@.hotmail.com> wrote in message
> >> news:1116604481.414270.179770@.g14g2000cwa.googlegroups.com...
> >> > When trying to print a report using the ActiveX control in Internet
> >> > Explorer I get the following error:
> >> >
> >> > An error occured during printing. (ox80070006)
> >> >
> >> > After some experimenting I found I was able to print (same client
> >> > computer / same server) to a file using the Generic / Text Only
> > printer
> >> > driver and the Microsoft Office Document Image Writer.
> >> >
> >> > So based on that I assumed the problem wasn't with the server.
> >> >
> >> > Next I tried hooking my printer directly to my computer. The same
> >> > error occured.
> >> >
> >> > I then tried a separate computer that printed to a separeate
> > computer
> >> > and it worked.
> >> >
> >> > Based on this I am assuming there is a issue with my printer /
> > printer
> >> > driver and the ActiveX control.
> >> >
> >> > My printer is a Samsung ML-1430.
> >> >
> >> > I wanted to report this to the Reporting Services Team and see if
> >> > anyone else had any similar problems with other printers.
> >> >
> >> > Thanks,
> >> >
> >> > Warren Hales
> >> >
> >> > P.S. I am new to Reporting Services and I have to say I am VERY
> >> > impressed. The Reporting Services Team has done a great job
> > (IMHO).
> >> > It is an excellent example of an application with a SOA.
> >> >
> >
>
>

Client Report Builder Framework not being picked up

Just a question regarding what is required to use report builder from a client pc.

If i sit at client pc, and then click on the report builder, it promts me that framework 2 is required to run report builder. I then proceed to click on the given link to install framework 2 beta 2 , but yet once the install is complete, even after a reboot, if i click on the report builder button again from within RS , it still prompts me to install the framework?

If i view the source, i see that its just a modal window with the message on the click of the button,i have even cleared cache and temp files but no luck, so it obviously does this check as the http://webserver/reports site loads.

Am i missing something here, any help would be appreciated

Thanks in advance
Shaun

Ok, i have managed to figure it out,

I am using the lastest CTP for SQL2005 on the server,
When the client gets sent to the microsoft site, it seems to install with a different framework version.

I read a bit about this on the following link, if any one else has any hassles.
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=82579

So basically, to fix it, i have made a copy of the correct framework redistributable and installed that onto the client machines , then everything seems to work.

Regards,
Shaun

Client Print To Dot Matrix Printer (Urgent)

I'm using ActiveX control to print report in client side, it's great for user. However, I have some reports which need to be printed to dotmatrix printer (Epson LQ 1600K III), they chould not be printed properly, all the fonts are always indouble width and half height.
But if I print those report to my laser printer or print them to dotmatrix printer in VS.NET, it's OK. See as below:
Print on laser priner
******************************
* * *
* * *
* *
* *
* *
******************************
Print on dotmatrix priner
======================================
= = =
= = =
= =
======================================

Is it a microsoft bug? Should I set something in my report or in printer driver (Printer Processer)?
Thanks in advance!

I'm having the same issue, did you get it working? Also wcich ActiveX control are you using?
Thanks
ma_flash

|||

No, I still have this issue, whatever I changed the processer in printer driver, it did not work.
I'm using new ActiveX Control in Reporting Service SP2, it is downloaded from report server when first time user load report. I think it is not consistent with VS.NET, because I can print reports to dotmatrix printer in VS.NET propoerly, but not in ActiveX Control.

|||

Can you kindly share the code of how to stream a report server directly to your local printer?

Thanks, Edmund

Client Logo is not display on client computer

We are using Crystal Report 11 with ASP.Net 2005 and Sql Server 2005 as database.
When the application is deployed to a client computer and the report is previewed, the report appears but the Client Logo (JEPG Imange) do not.
in place of logo it is displaying cross.

Kindly help me to solve this problem as soon as possible

Regards
Amit JoshiIs it a client server application.

If yes, you need to put the picture on client machine as well or access it from server.

check out the path you specified for image.

Hope this Helps you.|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.

Kindly help to solve this..

Regards
Amit|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.

Kindly help to solve this..

Regards
Amit

I would say 90% that it's going to be the file path. either the client PC can't see it or it can't access it.

Check you server logs for 404 errors coming from the client.

Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm

Hi,

I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.

Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.

Error message on browser:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.

Any ideas?

Thanks,

-waslam

Maybe this will help you:

http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

Client found response content type of ''text/html; charset=utf-8'', but expected ''text/xm

Hi,

I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.

Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.

Error message on browser:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.

Any ideas?

Thanks,

-waslam

Maybe this will help you:

http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

clickthrough report

What is a clickthrough report and how do you create it? THanks.
> What is a clickthrough report and how do you create it? THanks.
Do please check the "Working with Clickthrough Reports" topic in Books
OnLine
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/cf2c396e-b0c6-41f9-8c45-ddc8406f7e85.htm).
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
|||00KobeBrian wrote:

> What is a clickthrough report and how do you create it? THanks.
Please post this question at microsoft.public.sqlserver.reportingsvcs.
you will get better solution over there.
As per BOL
Using Report Builder, users can interactively explore the related data
within the report model. Clickthrough reports are automatically
generated so that report viewers can follow the report model's
navigation paths to explore the data. They can continue clicking
through the data as long as there is a relationship to follow from the
current item. When clicking through the data, queries are generated
automatically by passing information about which data that the user is
using to create their report, typically referred to as the context of
the current data location.
Regards
Amish Shah
http://shahamishm.tripod.com
|||> Please post this question at microsoft.public.sqlserver.reportingsvcs.
> you will get better solution over there.
It is there as well, I've jut seen it. So we should say - please do not
multi-post:-)
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

clickthrough report

What is a clickthrough report and how do you create it? THanks.00KobeBrian wrote:
> What is a clickthrough report and how do you create it? THanks.
Please post this question at microsoft.public.sqlserver.reportingsvcs.
you will get better solution over there.
As per BOL
Using Report Builder, users can interactively explore the related data
within the report model. Clickthrough reports are automatically
generated so that report viewers can follow the report model's
navigation paths to explore the data. They can continue clicking
through the data as long as there is a relationship to follow from the
current item. When clicking through the data, queries are generated
automatically by passing information about which data that the user is
using to create their report, typically referred to as the context of
the current data location.
Regards
Amish Shah
http://shahamishm.tripod.com|||> What is a clickthrough report and how do you create it? THanks.
Do please check the "Working with Clickthrough Reports" topic in Books
OnLine
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/cf2c396e-b0c6-41f9-8c45-ddc8406f7e85.htm).
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||> Please post this question at microsoft.public.sqlserver.reportingsvcs.
> you will get better solution over there.
It is there as well, I've jut seen it. So we should say - please do not
multi-post:-)
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

clickthrough report

What is a clickthrough report and how do you create it? THanks.> What is a clickthrough report and how do you create it? THanks.
Do please check the "Working with Clickthrough Reports" topic in Books
OnLine
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/cf2c396e-b0c6-41f9-8c45
-ddc8406f7e85.htm).
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||00KobeBrian wrote:

> What is a clickthrough report and how do you create it? THanks.
Please post this question at microsoft.public.sqlserver.reportingsvcs.
you will get better solution over there.
As per BOL
Using Report Builder, users can interactively explore the related data
within the report model. Clickthrough reports are automatically
generated so that report viewers can follow the report model's
navigation paths to explore the data. They can continue clicking
through the data as long as there is a relationship to follow from the
current item. When clicking through the data, queries are generated
automatically by passing information about which data that the user is
using to create their report, typically referred to as the context of
the current data location.
Regards
Amish Shah
http://shahamishm.tripod.com|||> Please post this question at microsoft.public.sqlserver.reportingsvcs.
> you will get better solution over there.
It is there as well, I've jut seen it. So we should say - please do not
multi-post:-)
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

clickthrough report

What is a clickthrough report and how do you create it? THanks.SQL Server 2005 Books Online
Working with Clickthrough Reports
http://msdn2.microsoft.com/en-us/library/ms345252.aspx
(Basically a search in google or live.com with "reporting services" and then
the thing you're wondering about will return quite a lot usefull
information. Like references to the Books Online, which is also quite a
usefull resource in itself.)
Kaisa M. Lindahl Lervik
"00KobeBrian" <a@.b.com> wrote in message
news:uisU7xn8GHA.2316@.TK2MSFTNGP04.phx.gbl...
> What is a clickthrough report and how do you create it? THanks.
>

Clicking print from Reporting Services report cause computer to re

I have a report developed using Reporting Services 2005 with SQL Server 2005.
It runs just fine, and printed fine up until a few days ago. Now, after I
run the report and it displays on the screen, clicking print causes the
computer to reboot. Not all the reports do this, just this one. I don't
know of anything that has changed that could cause this problem. Anyone have
a similar experience? The report uses a stored procedure to build a table.
But, again it did work o.k. until a few days ago.
ThanksSAME PROBLEM HERE !!
Our client called us yesterday, everything worked fine and now clicking the
print button on 1 or 2 reports just REBOOT the computer !
We are using Reporting Services 2000 with SQL Server 2000.
Please help!
"Glenna" wrote:
> I have a report developed using Reporting Services 2005 with SQL Server 2005.
> It runs just fine, and printed fine up until a few days ago. Now, after I
> run the report and it displays on the screen, clicking print causes the
> computer to reboot. Not all the reports do this, just this one. I don't
> know of anything that has changed that could cause this problem. Anyone have
> a similar experience? The report uses a stored procedure to build a table.
> But, again it did work o.k. until a few days ago.
> Thanks|||We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
patches?
"KhAoS" wrote:
> SAME PROBLEM HERE !!
> Our client called us yesterday, everything worked fine and now clicking the
> print button on 1 or 2 reports just REBOOT the computer !
> We are using Reporting Services 2000 with SQL Server 2000.
> Please help!
> "Glenna" wrote:
> > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > It runs just fine, and printed fine up until a few days ago. Now, after I
> > run the report and it displays on the screen, clicking print causes the
> > computer to reboot. Not all the reports do this, just this one. I don't
> > know of anything that has changed that could cause this problem. Anyone have
> > a similar experience? The report uses a stored procedure to build a table.
> > But, again it did work o.k. until a few days ago.
> >
> > Thanks|||On Apr 18, 10:36 am, pbriggsiberia
<pbriggsibe...@.discussions.microsoft.com> wrote:
> We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
> patches?
>
> "KhAoS" wrote:
> > SAME PROBLEM HERE !!
> > Our client called us yesterday, everything worked fine and now clicking the
> >printbutton on 1 or 2 reports justREBOOTthe computer !
> > We are using Reporting Services 2000 with SQL Server 2000.
> > Please help!
> > "Glenna" wrote:
> > > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > > It runs just fine, and printed fine up until a few days ago. Now, after I
> > > run the report and it displays on the screen, clickingprintcausesthe
> > > computer toreboot. Not all the reports do this, just this one. I don't
> > > know of anything that has changed that could cause this problem. Anyone have
> > > a similar experience? The report uses a stored procedure to build a table.
> > > But, again it did work o.k. until a few days ago.
> > > Thanks- Hide quoted text -
> - Show quoted text -
I am having the same problem. Has anyone found the solution to this?|||Found the solution on another forum!!
The problem come from a recent update patch from microsoft that affects some
printers drivers.
To get rid of the problem, install this hotfix (KB935843) :
http://www.microsoft.com/downloads/details.aspx?familyid=69443B00-F831-4785-B292-DBF8CF002C6A&displaylang=en
More infos : http://support.microsoft.com/?kbid=935843
"jrichardson2@.chkenergy.com" wrote:
> On Apr 18, 10:36 am, pbriggsiberia
> <pbriggsibe...@.discussions.microsoft.com> wrote:
> > We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
> > patches?
> >
> >
> >
> > "KhAoS" wrote:
> > > SAME PROBLEM HERE !!
> > > Our client called us yesterday, everything worked fine and now clicking the
> > >printbutton on 1 or 2 reports justREBOOTthe computer !
> > > We are using Reporting Services 2000 with SQL Server 2000.
> >
> > > Please help!
> >
> > > "Glenna" wrote:
> >
> > > > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > > > It runs just fine, and printed fine up until a few days ago. Now, after I
> > > > run the report and it displays on the screen, clickingprintcausesthe
> > > > computer toreboot. Not all the reports do this, just this one. I don't
> > > > know of anything that has changed that could cause this problem. Anyone have
> > > > a similar experience? The report uses a stored procedure to build a table.
> > > > But, again it did work o.k. until a few days ago.
> >
> > > > Thanks- Hide quoted text -
> >
> > - Show quoted text -
> I am having the same problem. Has anyone found the solution to this?
>

Click Through report/jump to a location

Anyone know how to make a report jump to a particular part of the
report when you open it.
Here's my situation. I have a summary commission report, that when you
click on the Sales reps name, it takes you to a detailed report about
the reps invoices. This report needs to have all reps on it, but i
want it to jump to the location of the rep that was clicked on in the
original report. Is this possible?Christhe,
I think you are looking for an anchor function. I don't think there is one,
unless you create your custom Report viewer. However, if you change your
report structure a bit, you may get the same effect. Click on the name, call
the same report with name parameter and display the results at the bottom.
By default, do not show any data related to sales.
How does it sound? Let me know, if you find a another solution for your
problem.
Thanks.
Cem Demircioglu
"ChristheGreat" <cfelkey@.gmail.com> wrote in message
news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> Anyone know how to make a report jump to a particular part of the
> report when you open it.
> Here's my situation. I have a summary commission report, that when you
> click on the Sales reps name, it takes you to a detailed report about
> the reps invoices. This report needs to have all reps on it, but i
> want it to jump to the location of the rep that was clicked on in the
> original report. Is this possible?
>|||There is a way to set and jump to a bookmark once you are in the report, the
question is whether this bookmark can be specified on the URL. This has
gotten me curious and I am going to investigate it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cem Demircioglu" <cem@.nospam.com> wrote in message
news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Christhe,
> I think you are looking for an anchor function. I don't think there is
one,
> unless you create your custom Report viewer. However, if you change your
> report structure a bit, you may get the same effect. Click on the name,
call
> the same report with name parameter and display the results at the bottom.
> By default, do not show any data related to sales.
> How does it sound? Let me know, if you find a another solution for your
> problem.
> Thanks.
> Cem Demircioglu
> "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > Anyone know how to make a report jump to a particular part of the
> > report when you open it.
> >
> > Here's my situation. I have a summary commission report, that when you
> > click on the Sales reps name, it takes you to a detailed report about
> > the reps invoices. This report needs to have all reps on it, but i
> > want it to jump to the location of the rep that was clicked on in the
> > original report. Is this possible?
> >
>|||Have you had any luck w/ this ? I saw in the reporting services books online
documentation that there is a "BookmarkID" property as an HTML device setting
when rendering to HTML.
I would like to just specify a BookMarkId using URL access something like - :
http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508
but it expects the BookmarkID as a report parameter.
"Bruce L-C [MVP]" wrote:
> There is a way to set and jump to a bookmark once you are in the report, the
> question is whether this bookmark can be specified on the URL. This has
> gotten me curious and I am going to investigate it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Cem Demircioglu" <cem@.nospam.com> wrote in message
> news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> >
> > Christhe,
> > I think you are looking for an anchor function. I don't think there is
> one,
> > unless you create your custom Report viewer. However, if you change your
> > report structure a bit, you may get the same effect. Click on the name,
> call
> > the same report with name parameter and display the results at the bottom.
> > By default, do not show any data related to sales.
> >
> > How does it sound? Let me know, if you find a another solution for your
> > problem.
> >
> > Thanks.
> > Cem Demircioglu
> >
> > "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> > news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > > Anyone know how to make a report jump to a particular part of the
> > > report when you open it.
> > >
> > > Here's my situation. I have a summary commission report, that when you
> > > click on the Sales reps name, it takes you to a detailed report about
> > > the reps invoices. This report needs to have all reps on it, but i
> > > want it to jump to the location of the rep that was clicked on in the
> > > original report. Is this possible?
> > >
> >
> >
>
>|||I thought this should be possible but same as you I was not able to get it
to work. I'll try my MS contacts and see if there is a way to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jj#10" <jj10@.discussions.microsoft.com> wrote in message
news:C2A778A3-352F-4E89-86B2-4A58044889BE@.microsoft.com...
> Have you had any luck w/ this ? I saw in the reporting services books
online
> documentation that there is a "BookmarkID" property as an HTML device
setting
> when rendering to HTML.
> I would like to just specify a BookMarkId using URL access something
like - :
>
http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508
> but it expects the BookmarkID as a report parameter.
> "Bruce L-C [MVP]" wrote:
> > There is a way to set and jump to a bookmark once you are in the report,
the
> > question is whether this bookmark can be specified on the URL. This has
> > gotten me curious and I am going to investigate it.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Cem Demircioglu" <cem@.nospam.com> wrote in message
> > news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> > >
> > > Christhe,
> > > I think you are looking for an anchor function. I don't think there is
> > one,
> > > unless you create your custom Report viewer. However, if you change
your
> > > report structure a bit, you may get the same effect. Click on the
name,
> > call
> > > the same report with name parameter and display the results at the
bottom.
> > > By default, do not show any data related to sales.
> > >
> > > How does it sound? Let me know, if you find a another solution for
your
> > > problem.
> > >
> > > Thanks.
> > > Cem Demircioglu
> > >
> > > "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> > > news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > > > Anyone know how to make a report jump to a particular part of the
> > > > report when you open it.
> > > >
> > > > Here's my situation. I have a summary commission report, that when
you
> > > > click on the Sales reps name, it takes you to a detailed report
about
> > > > the reps invoices. This report needs to have all reps on it, but i
> > > > want it to jump to the location of the rep that was clicked on in
the
> > > > original report. Is this possible?
> > > >
> > >
> > >
> >
> >
> >|||got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508"
This will get you to top of the page of the BookMark you are looking for,
but I suppose scrolling down to it on with browser would require client
scripting.
I will experiment with the Document map ID parameter to see if this works
any better.
"Bruce L-C [MVP]" wrote:
> I thought this should be possible but same as you I was not able to get it
> to work. I'll try my MS contacts and see if there is a way to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jj#10" <jj10@.discussions.microsoft.com> wrote in message
> news:C2A778A3-352F-4E89-86B2-4A58044889BE@.microsoft.com...
> > Have you had any luck w/ this ? I saw in the reporting services books
> online
> > documentation that there is a "BookmarkID" property as an HTML device
> setting
> > when rendering to HTML.
> >
> > I would like to just specify a BookMarkId using URL access something
> like - :
> >
> >
> http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508
> >
> > but it expects the BookmarkID as a report parameter.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > There is a way to set and jump to a bookmark once you are in the report,
> the
> > > question is whether this bookmark can be specified on the URL. This has
> > > gotten me curious and I am going to investigate it.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Cem Demircioglu" <cem@.nospam.com> wrote in message
> > > news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> > > >
> > > > Christhe,
> > > > I think you are looking for an anchor function. I don't think there is
> > > one,
> > > > unless you create your custom Report viewer. However, if you change
> your
> > > > report structure a bit, you may get the same effect. Click on the
> name,
> > > call
> > > > the same report with name parameter and display the results at the
> bottom.
> > > > By default, do not show any data related to sales.
> > > >
> > > > How does it sound? Let me know, if you find a another solution for
> your
> > > > problem.
> > > >
> > > > Thanks.
> > > > Cem Demircioglu
> > > >
> > > > "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> > > > news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > > > > Anyone know how to make a report jump to a particular part of the
> > > > > report when you open it.
> > > > >
> > > > > Here's my situation. I have a summary commission report, that when
> you
> > > > > click on the Sales reps name, it takes you to a detailed report
> about
> > > > > the reps invoices. This report needs to have all reps on it, but i
> > > > > want it to jump to the location of the rep that was clicked on in
> the
> > > > > original report. Is this possible?
> > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||I was having a single page in my tests and expected it to go to the bookmark
which it did not. So it sounds like it is partially implemented, that it
brought it to the appropriate page. Well, that is something. Let me know
what you find out with Document map if you don't mind. Thanks,
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jj#10" <jj10@.discussions.microsoft.com> wrote in message
news:33692470-7120-4A1B-A055-321F4C288B78@.microsoft.com...
> got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508"
> This will get you to top of the page of the BookMark you are looking for,
> but I suppose scrolling down to it on with browser would require client
> scripting.
> I will experiment with the Document map ID parameter to see if this works
> any better.
> "Bruce L-C [MVP]" wrote:
> > I thought this should be possible but same as you I was not able to get
it
> > to work. I'll try my MS contacts and see if there is a way to do this.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "jj#10" <jj10@.discussions.microsoft.com> wrote in message
> > news:C2A778A3-352F-4E89-86B2-4A58044889BE@.microsoft.com...
> > > Have you had any luck w/ this ? I saw in the reporting services books
> > online
> > > documentation that there is a "BookmarkID" property as an HTML device
> > setting
> > > when rendering to HTML.
> > >
> > > I would like to just specify a BookMarkId using URL access something
> > like - :
> > >
> > >
> >
http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508
> > >
> > > but it expects the BookmarkID as a report parameter.
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > There is a way to set and jump to a bookmark once you are in the
report,
> > the
> > > > question is whether this bookmark can be specified on the URL. This
has
> > > > gotten me curious and I am going to investigate it.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Cem Demircioglu" <cem@.nospam.com> wrote in message
> > > > news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> > > > >
> > > > > Christhe,
> > > > > I think you are looking for an anchor function. I don't think
there is
> > > > one,
> > > > > unless you create your custom Report viewer. However, if you
change
> > your
> > > > > report structure a bit, you may get the same effect. Click on the
> > name,
> > > > call
> > > > > the same report with name parameter and display the results at the
> > bottom.
> > > > > By default, do not show any data related to sales.
> > > > >
> > > > > How does it sound? Let me know, if you find a another solution for
> > your
> > > > > problem.
> > > > >
> > > > > Thanks.
> > > > > Cem Demircioglu
> > > > >
> > > > > "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> > > > > news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > > > > > Anyone know how to make a report jump to a particular part of
the
> > > > > > report when you open it.
> > > > > >
> > > > > > Here's my situation. I have a summary commission report, that
when
> > you
> > > > > > click on the Sales reps name, it takes you to a detailed report
> > about
> > > > > > the reps invoices. This report needs to have all reps on it,
but i
> > > > > > want it to jump to the location of the rep that was clicked on
in
> > the
> > > > > > original report. Is this possible?
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||I can't get the Doc Map Id to work at all. Not sure what I'm doing wrong - I
utilized it in the same way as the BooMarkID.
I'll probably stick with the BookMarkID.
"Bruce L-C [MVP]" wrote:
> I was having a single page in my tests and expected it to go to the bookmark
> which it did not. So it sounds like it is partially implemented, that it
> brought it to the appropriate page. Well, that is something. Let me know
> what you find out with Document map if you don't mind. Thanks,
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jj#10" <jj10@.discussions.microsoft.com> wrote in message
> news:33692470-7120-4A1B-A055-321F4C288B78@.microsoft.com...
> > got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508"
> >
> > This will get you to top of the page of the BookMark you are looking for,
> > but I suppose scrolling down to it on with browser would require client
> > scripting.
> >
> > I will experiment with the Document map ID parameter to see if this works
> > any better.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > I thought this should be possible but same as you I was not able to get
> it
> > > to work. I'll try my MS contacts and see if there is a way to do this.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "jj#10" <jj10@.discussions.microsoft.com> wrote in message
> > > news:C2A778A3-352F-4E89-86B2-4A58044889BE@.microsoft.com...
> > > > Have you had any luck w/ this ? I saw in the reporting services books
> > > online
> > > > documentation that there is a "BookmarkID" property as an HTML device
> > > setting
> > > > when rendering to HTML.
> > > >
> > > > I would like to just specify a BookMarkId using URL access something
> > > like - :
> > > >
> > > >
> > >
> http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508
> > > >
> > > > but it expects the BookmarkID as a report parameter.
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > There is a way to set and jump to a bookmark once you are in the
> report,
> > > the
> > > > > question is whether this bookmark can be specified on the URL. This
> has
> > > > > gotten me curious and I am going to investigate it.
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "Cem Demircioglu" <cem@.nospam.com> wrote in message
> > > > > news:OE40e$M9EHA.2540@.TK2MSFTNGP09.phx.gbl...
> > > > > >
> > > > > > Christhe,
> > > > > > I think you are looking for an anchor function. I don't think
> there is
> > > > > one,
> > > > > > unless you create your custom Report viewer. However, if you
> change
> > > your
> > > > > > report structure a bit, you may get the same effect. Click on the
> > > name,
> > > > > call
> > > > > > the same report with name parameter and display the results at the
> > > bottom.
> > > > > > By default, do not show any data related to sales.
> > > > > >
> > > > > > How does it sound? Let me know, if you find a another solution for
> > > your
> > > > > > problem.
> > > > > >
> > > > > > Thanks.
> > > > > > Cem Demircioglu
> > > > > >
> > > > > > "ChristheGreat" <cfelkey@.gmail.com> wrote in message
> > > > > > news:1105052689.824503.90710@.z14g2000cwz.googlegroups.com...
> > > > > > > Anyone know how to make a report jump to a particular part of
> the
> > > > > > > report when you open it.
> > > > > > >
> > > > > > > Here's my situation. I have a summary commission report, that
> when
> > > you
> > > > > > > click on the Sales reps name, it takes you to a detailed report
> > > about
> > > > > > > the reps invoices. This report needs to have all reps on it,
> but i
> > > > > > > want it to jump to the location of the rep that was clicked on
> in
> > > the
> > > > > > > original report. Is this possible?
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>

Click through Report Parameter

Hi there.

I am having a problem where I have a Summary Report for a Region that lists out data for each community in that region (sample below):

West Region Count Community 1 N/A Community 2 14 Community 3 41 Community 4 25 Community 5 38 Community 6 67 Community 7 40 Community 8 52

I have navigation setup such that when I click on a Community (like Community_1 above), the detailed community report is called. I am passing CommunityID as a parameter to the community report. The community report has a CommunityID (literally) parameter setup. This seems fine, but when I click on a community from the Region report (for example, Community_1 above), the community report does not automatically get rendered, it makes me select a community before it renders. I must have something setup incorrectly, but can't figure it out. Any ideas would be appreciated.

I want the community report to be rendered based on the selected community without having to select it again.

Thanks, Mike

Sounds like the detailed community report has a parameter that does not have a default value set. That would be why it is asking for an input when it starts up. There is a parameter button on the navagation tab of the textbox properties window to map the default parameter from the original report to the report you are jumping. If there is only one "CommunityID" parameter in the jump too report that should be it. Might also check for a duplicate parameter that could have been accidently added without a default.

|||

Thanks for the response.

I do not have a default parameter set on the community detail report, but how do I do that when the report is dual purpose - 1. A click through where you pass a community id AND 2. a standalone community report where you pick your community from a list. Is this possible? It seems like it should be and I have something setup wrong still.

I do not see a place to setup a default parameter on the navigation for the textbox. I assume this is what you mean:

I click on parameters button on the navigation tab (where I have the community report selected). I pick CommunityID from the dropdown and set it = to =Fields!CommunityID.Value.

I think that should do it.

Also, I checked and I do not have a duplicate parameter. Other ideas?

Thanks, Mike

|||

To set the default parameter of the "Jump to report" from the original report:

In the original report:

Right click on the textbox with the jump to feature.

Select properties from the drop down.

Click navagation tab.

In the hyperlink action section beside the jump to report field is a parameters button.

Click it to open a parameter mapping window.

On this window you select a value from the original report to default into the parameter of the "jump to" report.

When filled in there should be two fields with values; one the parameter name from the "jump to" report and the other a parameter value which is a field in the original report.

If the jump to report is receiving the value correctly it will not ask for the value to be input when it is called up. If you are using the report for dual purpose it does not need to have a built in default value. The default can be blank and its value populated as described above.

|||

Thanks again for the response.

I have the default parameter setup correctly as you described, so I think it is not being passed correctly. The value I am getting from the database os a char(5), so it might not be handling the padding correctly or something. I am going to try it with another field that is an int and make sure that works... then I will know if it is that stupid char(5) value. Grrrrrrr.

Thanks, Mike

|||This issue is killing me. I can get clickthrough reports to work fine with other parameters (ints instead of char(5)). I have tried trimming the value before sending it etc. I have tried passing a specific community code (with and without padding) and that does not work. Anyone have ideas?|||Is there a way that I can see the actual value being passed?|||

Put the value in question into a textbox in the original report.

The data type does need to be the same for the field in both reports; might be able to workaround using some kind of type conversion in the parameter or sql stmt.

|||

OK, some more info...

I am passing the community code and it does contain spaces for padding up to the 5 chars, but I do not think that is the issue. I just tried setting up the report parameter on the community report and forced the default to be one of my community codes (non-queried) and the report still does not automatically populate. I still have to select a community code.

What would cause the report not to generate?

|||More info. I can get it to work fine when I do not have it setup to get available values from a query. I should be able to do that shouldn't I?|||

I figured it out...

In my dataset on the Community detail report which gets the list of available values, I had to cast the community id to be a varchar as below:

CAST(CommunityID AS varchar(5))

Then it worked fine. What a pain.

Mike

Click through Report Parameter

Hi there.

I am having a problem where I have a Summary Report for a Region that lists out data for each community in that region (sample below):

West Region Count Community 1 N/A Community 2 14 Community 3 41 Community 4 25 Community 5 38 Community 6 67 Community 7 40 Community 8 52

I have navigation setup such that when I click on a Community (like Community_1 above), the detailed community report is called. I am passing CommunityID as a parameter to the community report. The community report has a CommunityID (literally) parameter setup. This seems fine, but when I click on a community from the Region report (for example, Community_1 above), the community report does not automatically get rendered, it makes me select a community before it renders. I must have something setup incorrectly, but can't figure it out. Any ideas would be appreciated.

I want the community report to be rendered based on the selected community without having to select it again.

Thanks, Mike

Sounds like the detailed community report has a parameter that does not have a default value set. That would be why it is asking for an input when it starts up. There is a parameter button on the navagation tab of the textbox properties window to map the default parameter from the original report to the report you are jumping. If there is only one "CommunityID" parameter in the jump too report that should be it. Might also check for a duplicate parameter that could have been accidently added without a default.

|||

Thanks for the response.

I do not have a default parameter set on the community detail report, but how do I do that when the report is dual purpose - 1. A click through where you pass a community id AND 2. a standalone community report where you pick your community from a list. Is this possible? It seems like it should be and I have something setup wrong still.

I do not see a place to setup a default parameter on the navigation for the textbox. I assume this is what you mean:

I click on parameters button on the navigation tab (where I have the community report selected). I pick CommunityID from the dropdown and set it = to =Fields!CommunityID.Value.

I think that should do it.

Also, I checked and I do not have a duplicate parameter. Other ideas?

Thanks, Mike

|||

To set the default parameter of the "Jump to report" from the original report:

In the original report:

Right click on the textbox with the jump to feature.

Select properties from the drop down.

Click navagation tab.

In the hyperlink action section beside the jump to report field is a parameters button.

Click it to open a parameter mapping window.

On this window you select a value from the original report to default into the parameter of the "jump to" report.

When filled in there should be two fields with values; one the parameter name from the "jump to" report and the other a parameter value which is a field in the original report.

If the jump to report is receiving the value correctly it will not ask for the value to be input when it is called up. If you are using the report for dual purpose it does not need to have a built in default value. The default can be blank and its value populated as described above.

|||

Thanks again for the response.

I have the default parameter setup correctly as you described, so I think it is not being passed correctly. The value I am getting from the database os a char(5), so it might not be handling the padding correctly or something. I am going to try it with another field that is an int and make sure that works... then I will know if it is that stupid char(5) value. Grrrrrrr.

Thanks, Mike

|||This issue is killing me. I can get clickthrough reports to work fine with other parameters (ints instead of char(5)). I have tried trimming the value before sending it etc. I have tried passing a specific community code (with and without padding) and that does not work. Anyone have ideas?|||Is there a way that I can see the actual value being passed?|||

Put the value in question into a textbox in the original report.

The data type does need to be the same for the field in both reports; might be able to workaround using some kind of type conversion in the parameter or sql stmt.

|||

OK, some more info...

I am passing the community code and it does contain spaces for padding up to the 5 chars, but I do not think that is the issue. I just tried setting up the report parameter on the community report and forced the default to be one of my community codes (non-queried) and the report still does not automatically populate. I still have to select a community code.

What would cause the report not to generate?

|||More info. I can get it to work fine when I do not have it setup to get available values from a query. I should be able to do that shouldn't I?|||

I figured it out...

In my dataset on the Community detail report which gets the list of available values, I had to cast the community id to be a varchar as below:

CAST(CommunityID AS varchar(5))

Then it worked fine. What a pain.

Mike