Thursday, March 22, 2012
arabic Problem
After exporting the report to pdf format ,The arabic text
Disappear.
even the settings of the machine are set to arabic default
Plz adviceRight to left languages (Arabic, Hebrew) in PDF were not implemented in the
initial release of Reporting Services. This will work in the upcoming SP1.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<anonymous@.discussions.microsoft.com> wrote in message
news:1ee7401c456ca$08c6df10$a501280a@.phx.gbl...
> hello
> After exporting the report to pdf format ,The arabic text
> Disappear.
> even the settings of the machine are set to arabic default
> Plz advice
>sql
Saturday, February 25, 2012
Application Interface
output to "Print, PDF, Excel or Email".
Any suggestions or articles would be helpful, so as not to reinvent the
wheel.
Thanx in advance,
Greg RowlandTake a look at this BOL topic:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_overview_v1_31pv.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:eDMpNqOaEHA.596@.TK2MSFTNGP11.phx.gbl...
> I would like to call reports from a Delphi 7.0 Application, and direct the
> output to "Print, PDF, Excel or Email".
> Any suggestions or articles would be helpful, so as not to reinvent the
> wheel.
> Thanx in advance,
> Greg Rowland
>
Thursday, February 16, 2012
append date to exporting file name in SQL reporting service
example : Report name : Testreport
Exported file should be : Testingreport-November-22-2007.pdf
please help me in this
Thanks
sukuTry here:
http://www.codeproject.com/sqlrs/PDFUsingSQLRepServices.asp|||I would suggest placing the timestamp inside of the report.
ie. "Report was generated November 22 2007 11:01am".
This way the client cannot change the "report date".
Because it is a PDF and thus you won't be editing the document you can sort it by "Date Modified" in explorer if you want to sort the files.
append date to exporting file name in SQL reporting service
example : Report name : Testreport
Exported file should be : Testingreport-November-22-2007.pdf
please help me in this
Thanks
suku
Quote:
Originally Posted by sukumaster
When exporting a report to another format, say excel,PDF; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to pdf, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services ?
example : Report name : Testreport
Exported file should be : Testingreport-November-22-2007.pdf
please help me in this
Thanks
suku
Please post the over all operation you are trying to perform?
Are you trying to use shell script to ftp the file to any other server?
If Yes, then renaming a file would become easy!!
Append current date in exported report file name in PDF format in sql report server 2000
HI All
I want to append current date in exported reported file name.
I am using report viewer to diplay report . when i exported report in pdf format it ask me to save file at this time file name is same what ever i uploaded in report server.
when it ask me to save i want append current date to the file name.
like report file name is "testingdetail" then i want "testingdetail-November-27-2006.pdf"
Please help me in this
Thanks
Alpesh
It appears you can only alter the filename when using subscriptions. (link to related post)
If you find another way to achieve that behavior please let me know.
|||
Hi All
I found another way to append current date to Expoting report file name.
We have to overide the Reder method of reporting service
first we have to add web reference of reporting service then
put below code in button click event
private void lnkexport_Click(object sender, System.EventArgs e)
{
ReportingService rs = new ReportingService();
string reportPath=/SampleDetail/TestingDetail;
// TestingDetail report must uploded in SampleDetail folder in ReportManager
TestingDetailReport testingDetailParams =this.reportParams as TestingDetailReport;
ParameterValue[] parameters = new ParameterValue[1];
parameters[0] = new ParameterValue();
parameters[0].Name="parameterName";
parameters[0].Value=parameterValue;
Byte[] result = this.LoadReport(reportPath,parameters);
string fname = "TestingDetail" + " - " +DateTime.Today.ToString("MMMM-dd-yyyy");
Response.ClearContent();
Response.AddHeader("Content-Disposition","attachment; filename=" + fname);
Response.AddHeader("Content-Length", result.LongLength.ToString());
Response.ContentType="Application/pdf";
Response.BinaryWrite(result);
Response.Flush();
Response.Close();
}
private Byte[] LoadReport(string reportPath,ParameterValue[] parameter )
{
ReportingService rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string[] streamIDs;
string optionalString = null;
ParameterValue[]optionalparams =null;
Warning[] warning = null;
Byte[] output= rs.Render(reportPath,"PDF",null,null,parameter,null,null,out optionalString,out optionalString,out optionalparams,out warning,out streamIDs);
return output;
}
Thanks
Alpesh