Showing posts with label pdf. Show all posts
Showing posts with label pdf. Show all posts

Friday, March 30, 2012

Problems with values display as currency

Hi NG,
has anybody got a report with values formatted as currency and could export
it to pdf without loosing the currency-formatting?
My currency-values are in Euro. Do i have to put some language-parametes in
the URL?
regards
Frank
www.xax.deAdobe 5.00 and 5.05 do not render symbols (e.g. Euro symbol) correctly when
the Arial font is used. Which version are you using? Did you try other fonts
(e.g. Tahoma)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank Matthiesen" <fm@.xax.de> wrote in message
news:34mtrsF4avhu6U1@.individual.net...
> Hi NG,
> has anybody got a report with values formatted as currency and could
export
> it to pdf without loosing the currency-formatting?
> My currency-values are in Euro. Do i have to put some language-parametes
in
> the URL?
> regards
> Frank
> www.xax.de
>
>|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
Newsbeitrag news:eEvOCqZ%23EHA.3592@.TK2MSFTNGP09.phx.gbl...
> Adobe 5.00 and 5.05 do not render symbols (e.g. Euro symbol) correctly
> when
> the Arial font is used. Which version are you using? Did you try other
> fonts
> (e.g. Tahoma)?
Got the wrong acrobat-version (5.0)
After an update everything wirks fine.
thx
frank
www.xax.desql

Friday, March 23, 2012

Problems with Printing and rendering to PDF

Hi,

I have an SQL server 2000 and I am creating a simple 1 page report using the Reporting Services and Visual Studio 2003. Everything is working fine. When I on "Preview" or when I access the report using a URL to disply it in HTML, I get a perfect report.

However, when I click on the "Print Preview" Icon (in the Preview Tab), or when I Render it as PDF, something goes wrong and it divides the report in 2 pages. On the first, there is only the company logo and the outlines of the tables used, while the rest of the report (minus the logo) is on the second page! I tried removing the logo, but still got a first page with only the outlines of tables. I also tried increasing the margins, with no success! I even tried removing some of the tables from the report, and test it, also the same result! could it be the datasets?

Did anybody get this problem? What could possibly be the reason?

Thanks a lot

Bob

Yes, the only way that I was able to stop this from happening was to reduce the margin size in the report properties.|||

Thx

yes it was the margins of the report that did this, especially the left and right margins.

sql

Problems with Printing and rendering to PDF

Hi,

I have an SQL server 2000 and I am creating a simple 1 page report using the Reporting Services and Visual Studio 2003. Everything is working fine. When I on "Preview" or when I access the report using a URL to disply it in HTML, I get a perfect report.

However, when I click on the "Print Preview" Icon (in the Preview Tab), or when I Render it as PDF, something goes wrong and it divides the report in 2 pages. On the first, there is only the company logo and the outlines of the tables used, while the rest of the report (minus the logo) is on the second page! I tried removing the logo, but still got a first page with only the outlines of tables. I also tried increasing the margins, with no success! I even tried removing some of the tables from the report, and test it, also the same result! could it be the datasets?

Did anybody get this problem? What could possibly be the reason?

Thanks a lot

Bob

Yes, the only way that I was able to stop this from happening was to reduce the margin size in the report properties.|||

Thx

yes it was the margins of the report that did this, especially the left and right margins.

Friday, March 9, 2012

problems with Exporting and Viewer

Hi, i'm having troubles using the ReportViewer to export to a pdf. Parameters are set by the user and (depending on the report) programmatically.
When i try to export in my code, i get a "Missing Parameter Values" error.
However, if i try to open a report with no parameters - the export works fine.

Can someone please help me out?

Here's my code:

this is the Export code:

<code>
private void Export4()
{
string ExportPath;
ExportPath = Request.PhysicalApplicationPath + "Exported\\";

if (Directory.Exists(ExportPath) == false)
Directory.CreateDirectory(Request.PhysicalApplicationPath + "Exported\\");

crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crExportOptions = reportDocument1.ExportOptions;
crDiskFileDestinationOptions.DiskFileName =ExportPath + "PortableDoc.pdf";
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;

try
{
reportDocument1.Export();
}
catch (Exception err)
{
Response.Write("<BR>");
Response.Write(err.Message.ToString());
}
}
</code>

And this is the code that sets the parameters, report and Viewer:

<code>

public void LoadReport_Param(ref CrystalReportViewer crViewer, ref ReportDocument crReport)
{
TableLogOnInfo crTableLogOnInfo = new TableLogOnInfo();
ConnectionInfo crConnInfo = new ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
ParameterDiscreteValue crPDValue;
ParameterFieldDefinitions crPFDefs;
ParameterFieldDefinition crPFDef;
ParameterValues crPValues;
try
{
crConnInfo.ServerName = _servername;
crConnInfo.DatabaseName = _dbname;
crConnInfo.UserID = _username;
crConnInfo.Password = _password;
crDatabase = crReport.Database;
crTables = crDatabase.Tables;

foreach(CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
crPFDefs = crReport.DataDefinition.ParameterFields;
for (int intParamCounter = 0; intParamCounter <= crPFDefs.Count-1; intParamCounter++)
{
try
{
crPFDef = crPFDefs[intParamCounter];
crPValues = crPFDef.CurrentValues;
if ((_GroupABBR != "") || (crPFDef.ParameterFieldName == "Branch") ||
(crPFDef.ParameterFieldName == "@.Branch")|| (crPFDef.ParameterFieldName == "?Branch") || (crPFDef.ParameterFieldName.ToLower() == "branch"))
{
crPDValue = null;
crPDValue = new ParameterDiscreteValue();
crPDValue.Value = _GroupABBR;
crPValues.Add(crPDValue); crPFDef.ApplyCurrentValues(crPValues);
}
}

catch (EngineException engEx)
{
throw new Exception(engEx.Message);
}
}
crViewer.ReportSource= crReport;
}
catch (LogOnException engEx)
{
throw new Exception("Incorrect Logon Parameters. Check your user name and password.");
}
catch (DataSourceException engEx)
{ throw new Exception("An error has occurred while connecting to the database.");
}
catch (EngineException engEx)
{
throw new Exception(engEx.Message);
}
}
</code>Did you ever get a result with this? I am having the same problem. I have watched every single ParameterField in my ParameterFields collection and where there isnt a value, I set one - then as soon as I do ReportDocument.Export I get this "Missing Parameter Values" exception.|||See if you are able to find solution here
www.businessobjects.com