Sql Report protection: window

Showing posts with label window. Show all posts

Friday, March 30, 2012

Report with parameter and Windows Application

Hi,
I've created a report with parameter, namely user should enter three
parameter and then run the user.
From a window application I would like to launch (call) an existing report,
already depoloyed in the SQL Reporting Server, and pass the three parameter
according to the user's input. Can anybody help me'
ThanksToday you have two choices, URL integration or web services. With URL
integration you embed the IE browser control, assemble the appropriate URL.
With web services your app uses SOAP to get the rendered report (which still
needs to be shown, either html (browser control again) or pdf). Next version
will have a winform control that will make this much easier (late summer
hopefully).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:BF7CD367-3353-4AA9-9C56-A5A6E2411638@.microsoft.com...
> Hi,
> I've created a report with parameter, namely user should enter three
> parameter and then run the user.
> From a window application I would like to launch (call) an existing
report,
> already depoloyed in the SQL Reporting Server, and pass the three
parameter
> according to the user's input. Can anybody help me'
> Thanks|||I'm interested in URL integration: how should I write the url in order to
pass the parameter?
Thanks :)
"Bruce L-C [MVP]" wrote:
> Today you have two choices, URL integration or web services. With URL
> integration you embed the IE browser control, assemble the appropriate URL.
> With web services your app uses SOAP to get the rendered report (which still
> needs to be shown, either html (browser control again) or pdf). Next version
> will have a winform control that will make this much easier (late summer
> hopefully).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:BF7CD367-3353-4AA9-9C56-A5A6E2411638@.microsoft.com...
> > Hi,
> > I've created a report with parameter, namely user should enter three
> > parameter and then run the user.
> >
> > From a window application I would like to launch (call) an existing
> report,
> > already depoloyed in the SQL Reporting Server, and pass the three
> parameter
> > according to the user's input. Can anybody help me'
> >
> > Thanks
>
>

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 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.sql

Report window and 2-up labels

When I run a multi-column report like labels, the preview does not look like
the labels actually print. Is there a method/property or something that can
make the preview look similar to the actual printed output when printing a
multi-column report? Thanks.
DavidOn Nov 16, 9:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
I'm not sure if this will help; however, you could try placing the
controls that are being used into a single rectangle control or adjust
your column spacing (by right-clicking Column 2 and select
Properties). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 16, 10:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
David,
I don't think there's a way to get Preview to look like the printed
output straight-a-way as what you're seeing in preview is the HTML
rendering of the xml code. However, once you're in Preview you can
click on the Print Layout button (right next to the Print button) to
give you a rendering of the page as it will print. Once you change to
this view, it'll stay that way as you flip back and forth from Preview
to Layout.
HTH
toolman

Monday, March 26, 2012

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

Rajeev
|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

report viewer in new window

I'm executing report server from my aspx page as follows:
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
taSource=c:\temp\mydataset.xml)
this seems the easiest way.
Is there any way I can get the report to display in a new window so that my
aspx page still shows?
Thanks,
GDean,
In your ASP.NET page, you can generate script to run in the window onload
event. In your case, this script would call window.open passing the report
URL. Just make sure that you put in window onload to prevent cookie lost if
you are using Forms Authentication. This will guarantee that the script will
run when the page and cookies are loaded.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I'm executing report server from my aspx page as follows:
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> taSource=c:\temp\mydataset.xml)
> this seems the easiest way.
> Is there any way I can get the report to display in a new window so that
my
> aspx page still shows?
> Thanks,
> G
>|||if you mean when my aspx page is just loading, I don't have the information
yet to generate the report. A purpose of my aspx page is to develop a
dataset to generate the report. My response.redirect is in answer to a
button click event.
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Dean,
> In your ASP.NET page, you can generate script to run in the window onload
> event. In your case, this script would call window.open passing the report
> URL. Just make sure that you put in window onload to prevent cookie lost
if
> you are using Forms Authentication. This will guarantee that the script
will
> run when the page and cookies are loaded.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.manning.com/lachev
> Home page and blog http://www.prologika.com
> ---
> "G. Dean Blake" <Dean@.nospam.com> wrote in message
> news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I'm executing report server from my aspx page as follows:
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > taSource=c:\temp\mydataset.xml)
> >
> > this seems the easiest way.
> >
> > Is there any way I can get the report to display in a new window so that
> my
> > aspx page still shows?
> > Thanks,
> > G
> >
> >
>|||No, I meant using Page.RegisterClientScriptBlock in your ASP.NET page to
generate dynamically the browser window.onload call instead of using
Response.Redirect, e.g.
StringBuilder sb=new StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("function requestReport");
sb.Append("{");
sb.Append("window.open (<'your report URL'>");
sb.Append("}");
sb.Append("</script>");
this.Page.RegisterClientScriptBlock("script",sb.ToString());
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:u$8xE%237hEHA.632@.TK2MSFTNGP12.phx.gbl...
> if you mean when my aspx page is just loading, I don't have the
information
> yet to generate the report. A purpose of my aspx page is to develop a
> dataset to generate the report. My response.redirect is in answer to a
> button click event.
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Dean,
> >
> > In your ASP.NET page, you can generate script to run in the window
onload
> > event. In your case, this script would call window.open passing the
report
> > URL. Just make sure that you put in window onload to prevent cookie lost
> if
> > you are using Forms Authentication. This will guarantee that the script
> will
> > run when the page and cookies are loaded.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.manning.com/lachev
> > Home page and blog http://www.prologika.com
> > ---
> >
> > "G. Dean Blake" <Dean@.nospam.com> wrote in message
> > news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I'm executing report server from my aspx page as follows:
> > >
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > > taSource=c:\temp\mydataset.xml)
> > >
> > > this seems the easiest way.
> > >
> > > Is there any way I can get the report to display in a new window so
that
> > my
> > > aspx page still shows?
> > > Thanks,
> > > G
> > >
> > >
> >
> >
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
This is installed in the folder YoursQLInstallfolder\Reporting
Services\Samples\Applications\ReportViewer.
But for windows applications why not use the web browser control? Add it to
your Windows project toolbox by doing Tools,Add/Remove Toolbox Items select
COM Components tab, then put a checkbox against Microsoft Web Browser
(filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox. Now
add it to your Windows form; the default name for the control when added is
AxWebBrowser1.
Now you can do:
axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
for example:
axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
Reports/Territory Sales Drilldown")
HTH
Charles Kangai, MCT, MCDBA
"Ed Willis" wrote:
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>
>
>|||That's great I was able to bring the report up. I cannot get the export to
excel to work. If I click Open after clicking on the export nothing happens.
Is there security problems with exporting?
Thanks.
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:790C7718-0D03-40B1-9BC0-CC4DD08BDD51@.microsoft.com...
> Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
> This is installed in the folder YoursQLInstallfolder\Reporting
> Services\Samples\Applications\ReportViewer.
> But for windows applications why not use the web browser control? Add it
> to
> your Windows project toolbox by doing Tools,Add/Remove Toolbox Items
> select
> COM Components tab, then put a checkbox against Microsoft Web Browser
> (filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox.
> Now
> add it to your Windows form; the default name for the control when added
> is
> AxWebBrowser1.
> Now you can do:
> axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
> for example:
> axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
> Reports/Territory Sales Drilldown")
> HTH
> Charles Kangai, MCT, MCDBA
> "Ed Willis" wrote:
>> Is there a report viewer for a window application? I need to plug a
>> report
>> into a Vb.Net windows app.
>> Thanks.
>>
>>|||You need to call the web service's Render method. This creates an array of
bytes that you can write to a file. The Render method accepts a format
parameter.
This is what you need to do:
1) add the Reporting Services web reference to your project. The web
reference is http://Yourserver/ReportServer/ReportService.asmx
when you add it, you have to give it a name, such as RServer.
2) At the top of your form window code add:
Imports YourProjectName.RServer
Imports System.IO
3) declare and create an instance of the Reporting Service. I like to do it
at form level, within the Form1 class:
dim rs as New ReportingService
4) Assuming you are using code behind button to export to excel:
private sub Button1_Click(...)
dim historyid as string = nothing
dim deviceinfo as string = nothing
dim paramvalues() as ParameterValue = nothing
dim credentials() as DataSourceCredentials = nothing
dim showhide as string = nothing
dim encoding as string = nothing
dim mimetype as string = nothing
dim warnings() as Warning = nothing
dim paramsused() as ParameterValue
dim streamids() as string = nothing
dim myRenderedReport as byte() = _
rs.Render("/Sample Reports/Territory Sales DrillDown", "EXCEL", historyid,
deviceinfo, paramvalues, credentials, showhide, encoding, mimetype,
paramsused, warnings, streamids)
dim fs as FileStream = File.OpenWrite("c:\MyFile.xls")
fs.Write(myRenderedReport, 0, myRenderedReport.Length())
fs.Close()
End Sub
you can do:
dim myRenderedReport as byte[] = TheWebService.Render(FullReportPath, "EXCEL")
dim myFileStream as filestream
"Ed Willis" wrote:
> That's great I was able to bring the report up. I cannot get the export to
> excel to work. If I click Open after clicking on the export nothing happens.
> Is there security problems with exporting?
> Thanks.
> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
> news:790C7718-0D03-40B1-9BC0-CC4DD08BDD51@.microsoft.com...
> > Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
> > This is installed in the folder YoursQLInstallfolder\Reporting
> > Services\Samples\Applications\ReportViewer.
> >
> > But for windows applications why not use the web browser control? Add it
> > to
> > your Windows project toolbox by doing Tools,Add/Remove Toolbox Items
> > select
> > COM Components tab, then put a checkbox against Microsoft Web Browser
> > (filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox.
> > Now
> > add it to your Windows form; the default name for the control when added
> > is
> > AxWebBrowser1.
> >
> > Now you can do:
> > axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
> >
> > for example:
> > axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
> > Reports/Territory Sales Drilldown")
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "Ed Willis" wrote:
> >
> >> Is there a report viewer for a window application? I need to plug a
> >> report
> >> into a Vb.Net windows app.
> >>
> >> Thanks.
> >>
> >>
> >>
> >>
> >>
>
>|||A ReportViewer control will be available in Visual Studio 2005 (aka
Whidbey). Whidbey Beta 1 does not have the ReportViewer control, but Beta 2,
scheduled for early 2005, will contain the control. There will be a WinForms
version and a WebForms version. The ReportViewer control will have built-in
ability to process and render reports, which means a Report Server is
unnecessary. If a Report Server is available then the controls will be able
to connect to the Report Server to view reports that are stored and
processed on the Report Server. Licensing has not been finalized, but we are
looking into making this control freely redistributable.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:etizP1j1EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.
Have you Googled this topic? There are many reporting controls available.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Have you Googled this topic? There are many reporting controls available.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Have you Googled this topic? There are many reporting controls available.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Tuesday, March 20, 2012

Report subscription only works 80% of the time.

Hi,

I have setup report subcription with stored credential using a valid domain account and "Use as Window Credentials..." checked. Everything tested fine and works properly when the report is viewed in a web application. The problem is this report renders fine in the browser 80% of the time and occasionally it gives me Logon failure error:

An error has occurred during report processing (rsProcessingAborted)

Cannot impersonate user for data source 'Pinnacle'. (rsErrorImpersonatingUser)

Logon failed. (rsLoginFailed)

Logon failed: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Since the report is working 80% of the time and the user domain account hasn't changed. I am confused why I am getting bad user account error. Please help!

Thanks.

-SouBee

This sounds like a network connectivity issue - if the security authority is not available when we try to login the data source credential user, you'll see behavior like this. At the time the subscription fails, are you able to connect to the data source as the same credentialed user?

-Lukasz

Report subscription only works 80% of the time.

Hi,

An error has occurred during report processing (rsProcessingAborted)

Cannot impersonate user for data source 'Pinnacle'. (rsErrorImpersonatingUser)

Logon failed. (rsLoginFailed)

Logon failed: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Since the report is working 80% of the time and the user domain account hasn't changed. I am confused why I am getting bad user account error. Please help!

Thanks.

-SouBee

-Lukasz

report starts processing immediately

Hello,
my report starts processing immediately when I switch to preview window in
VS (or click on it in the Web Browser).
I know it's because it has some string parameters (with list of available
values and default value defined) & 2 datetime parameters that allow null
values. When I remove default values or uncheck "allow null value" the
report waits untill I specify params. I suppose it is not convenient to work
with. Happily, my report calculates fast.
Are you going to fix this in the future releases?fix what?
This isn't desired behavior?
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hello,
> my report starts processing immediately when I switch to preview window in
> VS (or click on it in the Web Browser).
> I know it's because it has some string parameters (with list of available
> values and default value defined) & 2 datetime parameters that allow null
> values. When I remove default values or uncheck "allow null value" the
> report waits untill I specify params. I suppose it is not convenient to
work
> with. Happily, my report calculates fast.
> Are you going to fix this in the future releases?
>|||Ok, suppose, I want a report that can be for the last week, last month or
any other period that the user can specify (the fisrt two options is for
subscription). I'm creating 3 params: period type (last week, last month,
other) and two datetime parameters -- start date, end date (checking "allow
null value" to use them in subscriptions. Did I do anything wrong? May be
there is a better way?
"G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> fix what?
> This isn't desired behavior?
>
> "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > my report starts processing immediately when I switch to preview window
in
> > VS (or click on it in the Web Browser).
> >
> > I know it's because it has some string parameters (with list of
available
> > values and default value defined) & 2 datetime parameters that allow
null
> > values. When I remove default values or uncheck "allow null value" the
> > report waits untill I specify params. I suppose it is not convenient to
> work
> > with. Happily, my report calculates fast.
> >
> > Are you going to fix this in the future releases?
> >
> >
>|||I too have seen this behavior and agree that it is not the best. Just
because I have assigned defaults to the parameters does not mean I want it
to execute without any intervention on the users part. They should need to
click, hit enter. I.e. they should have to do the same thing they do after
selecting a parameter for the report to run. So, I did as you did. I leave
at least one report without a default so it waits for user interaction
before running.
Bruce L-C
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:e0e%23mJAcEHA.3300@.TK2MSFTNGP09.phx.gbl...
> Ok, suppose, I want a report that can be for the last week, last month or
> any other period that the user can specify (the fisrt two options is for
> subscription). I'm creating 3 params: period type (last week, last month,
> other) and two datetime parameters -- start date, end date (checking
"allow
> null value" to use them in subscriptions. Did I do anything wrong? May be
> there is a better way?
> "G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
> news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> > fix what?
> >
> > This isn't desired behavior?
> >
> >
> > "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> > news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > >
> > > my report starts processing immediately when I switch to preview
window
> in
> > > VS (or click on it in the Web Browser).
> > >
> > > I know it's because it has some string parameters (with list of
> available
> > > values and default value defined) & 2 datetime parameters that allow
> null
> > > values. When I remove default values or uncheck "allow null value" the
> > > report waits untill I specify params. I suppose it is not convenient
to
> > work
> > > with. Happily, my report calculates fast.
> > >
> > > Are you going to fix this in the future releases?
> > >
> > >
> >
> >
>|||It would be good to have an option to execute the report automatically
or not when the parameters are all valid.
In my case - after the user has selected all the parameters, he still
has to click 'view report' in the browser. I wish I could set it that
any parameter he changes, as long they are valid... execute the query.
My queries are small.. and go to OLAP... so are very quick.
People like to see action without much effort!!
And of course - sometimes it is better to click the view report -
specially if the query is large...

Monday, March 12, 2012

Report shows fine on pop-up preview window yet gives error when viewed in report server

My Report shows fine on pop-up preview window yet gives error when
viewed in report server
I believe that the pop-up window simulates the report server , my
report is fine in th epop up window, yet it breaks in the report
server, my config files are all the same, i made sure they are all
alike.
My report uses a custom assembly that refernces a sharepoint.dll
the custom assembly is strong named and is already in the GAC
i have given the custom assembly permissions and put permissions in
method level
[permissionset(blah blah)]
public string function()
{}
I mean what's wrong in this world'
I even gave FullTrust on the AllMembershipCondition, yet it didn't
work.!!! what the heck'I have the same problem...did you get this working?
Thanks,
Gary
"third.kill@.gmail.com" wrote:
> My Report shows fine on pop-up preview window yet gives error when
> viewed in report server
>
> I believe that the pop-up window simulates the report server , my
> report is fine in th epop up window, yet it breaks in the report
> server, my config files are all the same, i made sure they are all
> alike.
> My report uses a custom assembly that refernces a sharepoint.dll
> the custom assembly is strong named and is already in the GAC
> i have given the custom assembly permissions and put permissions in
> method level
> [permissionset(blah blah)]
> public string function()
> {}
> I mean what's wrong in this world'
> I even gave FullTrust on the AllMembershipCondition, yet it didn't
> work.!!! what the heck'
>

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me urge

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

aliahmad wrote:

:(( i am very disappointed that no one reply me on this problem. so i think i apply this problem on other forums.
i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.
and in text box expression in get the value from assembly.
when i click the report preview tab. its run fine and display my desired result.
but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.
i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".
ihave write the code group in both files is written below:
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust" Name="MyCustomCodeGroup"
Description="Code gorup for my custom extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"
/>
</CodeGroup>
any one suggest me how can i preview my desired result from running the project.
please reply me a soon as possibly
Regards,
Ali Ahmad

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

aliahmad wrote:

:(( i am very disappointed that no one reply me on this problem. so i think i apply this problem on other forums.
i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.
and in text box expression in get the value from assembly.
when i click the report preview tab. its run fine and display my desired result.
but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.
i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".
ihave write the code group in both files is written below:
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust" Name="MyCustomCodeGroup"
Description="Code gorup for my custom extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"
/>
</CodeGroup>
any one suggest me how can i preview my desired result from running the project.
please reply me a soon as possibly
Regards,
Ali Ahmad

Saturday, February 25, 2012

Report server

I am using sql express. I started report server using window services. It started and stopped automatically. How can it be kept going? I did use the configuration utility in report server.

thanks,

hobby

Hi Hobby,

Could you, please, take a look in the Reporting Services windows service log file to see what error you find there?

I would also recommend to take a look in the event viewer to see what was logged there regarding the stop of your service.

The Reporting Services windows service log file lives in this directory:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

and its name looks like this:

ReportServerService__<timestamp>.log

Mihaela

Friday, March 30, 2012

Report with parameter and Windows Application

Wednesday, March 28, 2012

Report window opens, remains blank

Report window opens, remains blank

Report window and 2-up labels

Monday, March 26, 2012

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

report viewer in new window

Report Viewer for a Windows application

Report Viewer for a Windows application

Report Viewer for a Windows application

Report Viewer for a Windows application

Tuesday, March 20, 2012

Report subscription only works 80% of the time.

Report subscription only works 80% of the time.

report starts processing immediately

Monday, March 12, 2012

Report shows fine on pop-up preview window yet gives error when viewed in report server

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me urge

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me

Saturday, February 25, 2012

Report server

Sql Report protection

Blog Archive

About Me