Friday, March 30, 2012
reportbuilder button not appearing
I am not getting the reportbuilder button on the toolbar in report
server portal. I have implemented forms security on the reporting
services instance.
Can anyone please help me solve this problem?
Thanks in advance,
BharathHi All,
I got the resolution for this problem. I was implementing the sample
from SQL 2000 on an SQL 2005 platform. After implementing the forms
authentication using the sources from SQL 2005 the button is
appearing...
Bharath
bharath wrote:
> Hi Everyone,
> I am not getting the reportbuilder button on the toolbar in report
> server portal. I have implemented forms security on the reporting
> services instance.
> Can anyone please help me solve this problem?
> Thanks in advance,
> Bharath
Wednesday, March 28, 2012
Report window opens, remains blank
I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.
I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.
Any ideas?
Thanks,
Michelle
I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.Report window opens, remains blank
I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.
I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.
Any ideas?
Thanks,
Michelle
I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.sqlReport Viewer toolbar problem
Thanks for the help.
Hi
Install MSSRS Service Pack 2. That will solve your problem.
|||Adonis,
Thanks for the reply. Now I am using Report Services through SQL 2005 Standard and the Report Viewer through VS 2005 Standard if that matters any.
Where do I find the service pack for this that you mention?
Thanks for the information.|||
I think -
What CTP version of 2005 are you using? If July - upgrade
|||I have the full version of SQL 2005 Standard and Visual Studio 2005 Standard. These are the full release versions.|||
Good Evening!
Since I am on the other side of the world so to speak -
You have the "full" version - AND WITH ALL DUE RESPECT - did you purchase this - because if so - I would like to as well --
I can only get a CTP download here in BKK -
Give me some help here in that is this a general first release of 2005?
thank you
|||I do have the "full" version of Standard (not Professional) for both Visual Studio 2005 and SQL Server 2005. These were offered at the Launch Parties. You can get the "full" version of the Express versions for free here:http://msdn.microsoft.com/vstudio/express/. These are free for one year so if you download them now, there is no cost to you at all.
Hope this helps.
|||I have researched the "full version" as you have claimed - and SORRY - there is not a FULL version of 2005 other than the CTP release
or
a possible "full" -- BS --- if your company has a relationship - which every company has a relationship!
So in your request please provide a mod and release # then we can help - but do not say to this forum you have a "FULL" release of a "standard" version of 2005...
Watch your words!
|||
Huh? So what, the November 7 launch never happened and the beta is still out there?
I do not know what you are talking about.
But thanks for the great help you have provided.
|||Sorry about my post about the "FULl" version - please take no personal offense!
I modified the toolbar one time to change the background color and font... I lost the print button on some reports and on others I lost the export button... I never could figure out why - so I reverted back....
I just recently read something on Microsoft's www site about RS 2005 behavioral changes - and the first paragrap indicated problems with headers - maybe there is something in that article - I will go back and look up and post the link to the article -- maybe a small "glitch" in the initial release
Best regards
|||Not sure if you are still working on this. If you are running reports in local mode, the print icons will not be available. Client-side printing is only available in remote mode when you are calling an actual Report Server. Not sure if that applies to your setup or not. You can supposedly get printing to work by writing your own code, but we are just trying this now so not sure if it works or not.http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=76294&SiteID=1|||
Actually, I still am having the problem, but I do see what you are saying because I changed the processing mode to remote and the print button displays. So what I did is import the report to the SQL Reporting Server (I hope I did this right) by using the SQL Management Console.
Now though when I run the app, I am getting the following error:
"The path of the item "\Reports\report.rdlc" is not valid. The path must be less than 260 characters long and restrictions apply. (rsIndalidItemPath)"
What did I do wrong here?
Report Viewer toolbar
How?Yes - its possible.
Our book "Hitchhiker's Guide to SQL Server 2000 Reporting Services" shows
how you can customise the Report Manager, in Chapter 11, if you combine the
content there with the SOAP information in Chapter 9¾ then you should be
able to place a button on the Report Manager and print.
Peter Blackburn
www.sqlreportingservices.net
"mparsons" <mparsons@.discussions.microsoft.com> wrote in message
news:F208C86B-C1A8-4CBF-8CE0-2E4433468686@.microsoft.com...
>I want to add a print button on the report viewer toolbar. Is this
>possible?
> How?
>|||Hold up... your book shows how to do this? Does it come with source code?
and do I have to do anything extra to get the reporting working?
And I buy this where?
-CJ
"Peter Blackburn (www.sqlreportingservices.net)"
<http://www.sqlreportingservices.net> wrote in message
news:%238K119ftEHA.3572@.tk2msftngp13.phx.gbl...
> Yes - its possible.
> Our book "Hitchhiker's Guide to SQL Server 2000 Reporting Services" shows
> how you can customise the Report Manager, in Chapter 11, if you combine
the
> content there with the SOAP information in Chapter 9¾ then you should be
> able to place a button on the Report Manager and print.
> Peter Blackburn
> www.sqlreportingservices.net
>
> "mparsons" <mparsons@.discussions.microsoft.com> wrote in message
> news:F208C86B-C1A8-4CBF-8CE0-2E4433468686@.microsoft.com...
> >I want to add a print button on the report viewer toolbar. Is this
> >possible?
> > How?
> >
>|||Hello CJ,
The book comes with 2.5 GB of DVD content including source code and Video
content. We've not included source code for printing as we were going to
release a product to do this - nevertheless you'll find sufficient
information in the the chapters I referenced to be able to customise the
Report Manager - and once you have button on the Report Manager - well then
the world is your Oyster :-> Chapter 9¾ discusses the approach to take to
get printing from within the same session that you are browsing in.
Where can you buy the book from - well - the usual sources - Amazon..
http://www.amazon.com/exec/obidos/tg/detail/-/0321268288/ .or direct from
the publisher's website: http://www.awprofessional.com/titles/0321268288 .
You'll find more details on our website
(http://www.sqlreportingservices.net )
Peter Blackburn
www.sqlreportingservices.net
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:ulzhWTgtEHA.948@.tk2msftngp13.phx.gbl...
> Hold up... your book shows how to do this? Does it come with source
> code?
> and do I have to do anything extra to get the reporting working?
> And I buy this where?
> -CJ
> "Peter Blackburn (www.sqlreportingservices.net)"
> <http://www.sqlreportingservices.net> wrote in message
> news:%238K119ftEHA.3572@.tk2msftngp13.phx.gbl...
>> Yes - its possible.
>> Our book "Hitchhiker's Guide to SQL Server 2000 Reporting Services"
>> shows
>> how you can customise the Report Manager, in Chapter 11, if you combine
> the
>> content there with the SOAP information in Chapter 9¾ then you should be
>> able to place a button on the Report Manager and print.
>> Peter Blackburn
>> www.sqlreportingservices.net
>>
>> "mparsons" <mparsons@.discussions.microsoft.com> wrote in message
>> news:F208C86B-C1A8-4CBF-8CE0-2E4433468686@.microsoft.com...
>> >I want to add a print button on the report viewer toolbar. Is this
>> >possible?
>> > How?
>> >
>>
>
Friday, March 23, 2012
report viewer control wont display report !
am trying to display reports from my report server in report view controls. following is my code in a button click
reportviewer1.ServerReport.ReportServerUrl = {http://localhost/reportserver};
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();
its not giving my any error not displays any report!!
but if i set same info in design mode to report viewer control it works nicely!
whats missing here ?
Thanks for your help.finally figured out .following is what needs to be done
reportviewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportviewer1.ServerReport.ReportServerUrl = new System.Uri(@."http://localhost/reportserver");
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();
Wednesday, March 21, 2012
Report Viewer
I'm using Visual Studio Beta 2
I have few questions about the ReportViewer WinForm Control.
When rendering a Server Report the Print button appears disabled is this by
design?
Also the Print Preview button is enabled but it does not do anything is this
also by design?
Any help is appreciated!!!
LuigiHi,
I am also facing the same problem. Without the print option the report is of
no use for our client. Please help on urgent basis.
"Luigi Di Santo" wrote:
> Hi
> I'm using Visual Studio Beta 2
> I have few questions about the ReportViewer WinForm Control.
> When rendering a Server Report the Print button appears disabled is this by
> design?
> Also the Print Preview button is enabled but it does not do anything is this
> also by design?
> Any help is appreciated!!!
> Luigi
>
>
Friday, March 9, 2012
Report service and automatically creating a PDF report.
via a report button.
Currently when users click the report button the users web interface opens
(would like to not the the web interface just create the PDF without any
interaction) then the user is prompted to open/saved/cancel.
Is it possible to click on the so called report button and automatically
create the PDF? no dialog boxes appering just create the PDF?
Is this a workstation issue with internet exploier?
Running the 2000 version of SQL & it's counter part of reporting services.
All workstations all XP Pro Sp2
MikeHi Mike,
Well I'm using RS 2005 and all the latest stuff here, so I'm not sure
if it'll work but here goes. From a website, my users click a button
and I then do this in C# my code :
//*******************************
string url;
int idStage =3D Convert.ToInt32(lblIdStage.Text);
int annee =3D Convert.ToInt32(lblAnnee.Text);
int idTrimestreAdmission =3D
Convert.ToInt32(lblIdTrimestreAdmission.Text);
url =3D
"http://xxxxx.xxxxx.ca/ReportServer?/Rapport_xxxx/Etxxxge";
url +=3D "&rs:Format=3DPDF";
url +=3D "&idStage=3D" + idStage;
url +=3D "&annee=3D" + annee;
url +=3D "&idTrimestreAdmission=3D" + idTrimestreAdmission;
url +=3D "&idDomaineFormation=3D" +
Convert.ToInt32(Session["IdDomaineFormation"]);
Response.Redirect(url);
//*******************************
This basically pop up a acrobat reader with my report in it.
Hope it helps, cheers.
Mike a =E9crit :
> woundering if there's a way for the user to automatically create a PDF re=port
> via a report button.
> Currently when users click the report button the users web interface opens
> (would like to not the the web interface just create the PDF without any
> interaction) then the user is prompted to open/saved/cancel.
> Is it possible to click on the so called report button and automatically
> create the PDF? no dialog boxes appering just create the PDF?
> Is this a workstation issue with internet exploier?
> Running the 2000 version of SQL & it's counter part of reporting services.
> All workstations all XP Pro Sp2 > > Mike
Report Server website - button presses ignored
server.
Some of the website buttons, like OK & CANCEL when attempting to create a
new site-wide Schedule, don't function. No error reported when you press
them, they're just ignored, it's as if the installation failed to complete
properly.
My development server, also running SQL 2000 and Reporting Services, doesn't
have the issue.Have you got activeX disabled?
Are you running sp2?
SimonN wrote:
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services, doesn't
> have the issue.|||HI. Tks for the reply.
No ActiveX is not disabled, and client PC is running SP2.
Browsing the two installations from the same client, so i can bring up two
IEs one pointing to an RS website that works and the other to the one that is
faulty.
"SmartbizAustralia" wrote:
> Have you got activeX disabled?
> Are you running sp2?
> SimonN wrote:
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services, doesn't
> > have the issue.
>|||Simon,
Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
and <ReportServerExternalURL> config values. Many times these reference the
machine name instead of the URL used to access the reporting services. I've
found if these these entries don't match the domain name in the URL used to
access report manager, many of the buttons simply don't do anything when
clicked.
- Chris
"SimonN" <SimonN@.discussions.microsoft.com> wrote in message
news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> server.
> Some of the website buttons, like OK & CANCEL when attempting to create a
> new site-wide Schedule, don't function. No error reported when you press
> them, they're just ignored, it's as if the installation failed to complete
> properly.
> My development server, also running SQL 2000 and Reporting Services,
> doesn't
> have the issue.|||Chris,
Thanks for the reply.
I checked the value of ReportServerURL in the RSWebApplication.config, it's
set to the correct name of the server. I have a DNS alias that user will use
to run reports, but for all administration I'll stick to using the actual
server in the URL.
I don't have an entry for ReportServerExternalURL, but it sounds like this
is a 2005 feature when accessing the Report Server through a firewall. I'm
only running the 2000 version.
Unfortunately, I'm still seeing the same issue even when I browse with the
serve name identified by the ReportServerURL config element.
"Chris Walls" wrote:
> Simon,
> Look in the Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config file for a <ReportServerURL>
> and <ReportServerExternalURL> config values. Many times these reference the
> machine name instead of the URL used to access the reporting services. I've
> found if these these entries don't match the domain name in the URL used to
> access report manager, many of the buttons simply don't do anything when
> clicked.
> - Chris
> "SimonN" <SimonN@.discussions.microsoft.com> wrote in message
> news:63A63397-D966-4A70-8D5A-24AD9054E50B@.microsoft.com...
> > I'm seeing a strange problem on my production Reportng Services (SQL 2000)
> > server.
> >
> > Some of the website buttons, like OK & CANCEL when attempting to create a
> > new site-wide Schedule, don't function. No error reported when you press
> > them, they're just ignored, it's as if the installation failed to complete
> > properly.
> >
> > My development server, also running SQL 2000 and Reporting Services,
> > doesn't
> > have the issue.
>
>
Wednesday, March 7, 2012
Report Server renders incorrect URL for [Export] button
We have a Report Server 2000 on a client site. The server is accessible
via server name (NetBIOS name) from the local LAN, but only via a DNS name
from outer regions of the WAN (these users are on a different but trusted
domain in the bigger forest). The reports render successfully when accessed
via either the NetBIOS or DNS name, but the URL rendered for the â'Exportâ'
functionality always refers to the NetBIOS (server) name. As a result users
on the WAN cannot use the â'Exportâ' functionality since the URL is not found
from that network location (without us adding a local host entry which is
against company policy).
The page source shows a number of variables, including dmRepUrl,
touchSessionUrl, printUrl, renderingUrl, exportUrl and docMapUrl â' these are
all incorrectly mapping to the server name.
I cannot find any matching entry in the Report Server configuration and it
seems as-if this code is output by a compiled assembly on the Report Server.
Are these URLs configurable at all?
Thank you,
James Avenant
GijimaAst ConsultantHi James,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
deploy your report server on a WAN environment. If I misunderstood your
concern, please feel free to let me know.
Based on my experience, you need to specify a fully qualified domain name
instead of the Netbios name in the config file.
The first step is to change the following two registry values under this
key to the appropriate new values:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting
Services\
RSVirtualDir = http://server.company.com/ReportServer (Old Value was
http://server/ReportServer)
WAVirtualDir = http://server.company.com/Reports (Old Value was
http://server/Reports)
The final piece is to make a change in the following to config files on
your reporting server:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
Each file will contain one instance of the server referenced by name
(http://server/ReportServer). Replace it with the fully qualified domain
name, keeping the trailing directory
(http://server.company.com/ReportServer)
Now just restart the service and you should be able to access the reports
inside or out using a fully qualified domain name.
Hope this will be helpful!
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.