|
i have also the problem when exporting to pdf, i get blank pages in the middle of the report.
i have a report that generates data grouped by territory, and each group has a different size.
so if u try to put 10 lines of data by page, it can't work, i get blank pages anyway.
|
|
|
|
|
Hi,
I have Deployed reports in my Report Server.
All the reports are working fine,
Then i send mail from particular user,
so try to create a new subscription,
but error thrown...
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Get Online Help"
in my project folder am used two rdl files
example for (Report1.rdl, Report2.rdl)
& two Data Source (Remote1.rds, Remote2.rds)
Report1.rdl file is point to one Remote Machine using Remote1.rds datasource, Report2.rdl file is point to another Remote Machine using Remote2.rds datasource
its properly running in my ReportServer area
but create new subscription area thrown an error..
anybody give idea for that issue..
thanks for advance
regards,
Ram...
|
|
|
|
|
Can any body explain why I am getting blank pages when I export the report in pdf format?
Thank you.
vedd
|
|
|
|
|
I have a report which contains so many components.Some of these components are having the Visibility conditions.The Problem is that I am getting large white spaces between components while exporting the report to PDF.How can I avoid getting these spaces in PDF?
|
|
|
|
|
I have the same problem. Really annoying.
Some spaces i could avoid because there were overlapping items. but now there are no overlapping items. argh...
I'm using a list in a list. Both lists contain some textboxes. thats all.
Please help
|
|
|
|
|
I have managed to sort out the code above and get the application compiling and executing. However there seems to be a problem with the parameter that I define and and set with the SetExecutionParameters() method.
Everytime I try to run my report the following error is displayed
This report requires a default or user-defined value for the report
parameter 'contractid'. To run or subscribe to this report, you must provide a parameter value.
I am setting this parameter as follows:
parameters[0] = new ParameterValue();
parameters[0].Name = "contractid";
parameters[0].Value = "1";
rs.SetExecutionParameters(parameters, "en-us");
where rs is an ExecutionService.
If anyone knows what I am doing wrong or what I need to change on my report to get this working I'd like to hear from you.
mtembene
|
|
|
|
|
OK I figured it out after a bit of hacking.
In the end I discovered that though the parameter I had to set was a string the report writer and a set of predefined valid parameter values that had to be met. That was my first problem.
When running the report manually I could pick the parameter I wanted from a drop down list. The drop downlist actually provided a Guid as a parameter to the report.
So in the end I had to create a Guid in my code. Assign it a valid value and then add that value as a string to the parameter for my report.
Obvious in the end.
|
|
|
|
|
Hi - I have exactly the same problem with drop-down choices in a report, but dont quite understand what you mean
when you mention the use of a GUID. Do you mean that each option in the dropdown has an associated GUID that is the real value of the parameter - if so how do you get these values. Hope to hear from you soon.
Scott Hayles (scott.hayles@ntsolutions.com.au)
|
|
|
|
|
Hi All, I am having trouble getting this running - does anybody have a sample of this in a VS solution that I could have a look at please?
Sorry for being dense... All help greatfully received...
:-/
|
|
|
|
|
Hi - with help I think I am making progress...
I am running into a problem very similar to the thread below this:
The report on my SSRS instance is stored in Home > Pauls Case Report > Report1
So I assume the path for the reportname variable should be "/Pauls Case Report/Report1" However - this returns me back a 404 error (not found)...
I can see it's the rs.getparameters block thats throwing this...
Any idea's?
Brgds, Paul.
|
|
|
|
|
A sample for VS development is as :-
ReportService2005.CatalogItem myCatalog=new TestApp.ReportService2005.CatalogItem();
ExecutionHeader header=new ExecutionHeader();
ExecutionInfo rpt = myReportExec.LoadReport("/Report Project/Report1", null);
myReportExec.ExecutionHeaderValue = header;
myReportExec.ExecutionHeaderValue.ExecutionID = rpt.ExecutionID;
--------To load a report------.
Hope this helps bcoz ur problem is for loading only.
|
|
|
|
|
Hi - thanks for getting back to me so quickly - I really appreciate this.
So,
I declare as follows:
private ReportService2005.ReportingService2005 rs;
private ReportExecution2005.ReportExecutionService rsExec;
then...
// Create a new proxy to the web service
rs = new ReportService2005.ReportingService2005();
rsExec = new ReportExecution2005.ReportExecutionService();
// Authenticate to the Web service using Windows credentials
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;
// Assign the URL of the Web service
rs.Url = "http://anitemscrm/ReportServer" + "$REPORTSERVER2005/ReportService2005.asmx";
rsExec.Url = "http://anitemscrm/ReportServer" + "$REPORTSERVER2005/ReportExecution2005.asmx";
ReportService2005.CatalogItem myCatalog = new ReportService2005.CatalogItem();
ReportExecution2005.ExecutionHeader header = new ReportExecution2005.ExecutionHeader();
ReportExecution2005.ExecutionInfo rpt = rsExec.LoadReport("/Pauls Case Report/Report1", null);
rsExec.ExecutionHeaderValue = header;
rsExec.ExecutionHeaderValue.ExecutionID = rpt.ExecutionID;
However - I still get back error 404 not found...
Brgds, Paul.
|
|
|
|
|
All sorted now - thank you very much for your help and for an excellent source of information
Paul...
|
|
|
|
|
Hi Paul,
How did you solved it? I have exactly the same problem .
Any help is appreciated!
|
|
|
|
|
FYI ~
For those you have the same problem, here is how I fixed mine:
Replace
rs.Url = "http://SQL1/ReportServer" +
"$REPORTSERVER2005/ReportService2005.asmx";
rx.Url = "http://SQL1/ReportServer" +
"$REPORTSERVER2005/ReportExecution2005.asmx";
With
rs.Url = "http://SQL1/ReportServer" + "/ReportService2005.asmx";
rx.Url = "http://SQL1/ReportServer" + "/ReportExecution2005.asmx";
Hope this help!
|
|
|
|
|
Hi Im using
Reportexecutionservice.ReportExecutionService res =new Reportexecutionservice.ReportExecutionService();
im trying to load a report
like this
Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(rptname, null);
rptname i given it to be \oasisreport\childrpt"
actually childrpt exist in my server.im runnning my system on my localmachine.How to get reports of server which contain all reports
r can u tell me how to access my server reports
i geeting this error
System.Web.Services.Protocols.SoapException was unhandled by user code
The path of the item "/OasisReports/Childreport" is not valid. The path must be less than 260 characters long and must start with slash.
mhi
|
|
|
|
|
Hi,
First of all you need to check that reports deployed on the report server is in which folder with the name itself for the report.
Eg - If your reports folder build on server has name "Report Project1" and the report name is "Report1" then the path should be in C# code->
--rptName="Report Project1/Report1"--
and you can load report using "--LoadReport(rptname, null);--" as u usually do.
I hope this helps,if i got ur problem right!!!!! .
Vikas
|
|
|
|
|
This looks like EXACTLY what I need but I can't follow the first part of your code. Full source of consuming the webservice would be helpful.
|
|
|
|
|
Was anyone successful in actually opening the pdf file it generates? Wouldn't you need some dll from Adobe to be able to write to PDF?
|
|
|
|
|
Nevermind...
|
|
|
|
|
First I would like to thank you for writing this tutorial.
I seem to have problems changing the PDF to XLS in order to export an excel file.
Any idea on what I could be doing wrong?
|
|
|
|
|
I just found out I should have used "EXCEL" as the format and not "XLS" like i thought.
thanks again
|
|
|
|
|
This article was a huge help in programmatically exporting a report to .pdf, however I have yet to get it to work by using the InvokeWebService activities in a WF project. Any chance you could put together a sample using Windows Workflow & InvokeWebService activities? I am basically having a problem with the "SetExecutionParameters" method because it is telling me that a SessionID is required, even though one is specified on the SessionID property.
jfkrueger
|
|
|
|
|
This block of code works fine when I supply a default value to a parameter, but when there is no default value, the Render method fails with the follwing error message:
{"This report requires a default or user-defined value for the report parameter 'fund'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'fund'. To run or subscribe to this report, you must provide a parameter value. ---> This report requires a default or user-defined value for the report parameter 'fund'. To run or subscribe to this report, you must provide a parameter value."}
I am assiging the params this way:
SSRSReportExecution.ParameterValue[] parameters = new SSRS.SSRSReportExecution.ParameterValue[2];
if (_params.Length > 0)
{
parameters[0] = new SSRS.SSRSReportExecution.ParameterValue();
parameters[0].Label = "date";
parameters[0].Name = "date";
parameters[0].Value = "2/28/7";
parameters[1] = new SSRS.SSRSReportExecution.ParameterValue();
parameters[1].Label = "fund";
parameters[1].Name = "fund";
parameters[1].Value = "abcd";
}
res.SetExecutionParameters(parameters, "en-us");
Any suggestions what might be wrong in my code?
|
|
|
|
|
Please provide complete working code (if possible for local mode too)
Thank you
|
|
|
|