Showing posts with label reportin. Show all posts
Showing posts with label reportin. Show all posts

Sunday, March 11, 2012

Displaying Price in Microsoft reporting services

hai

I am using Microsoft reporting services.
I am using XSD as report datasource to bind data to the report
In the report, i want to display Amount in french belgiun format in a column eg. 123.456,00 €
While passing the value through datasource, i cant able to pass the value as decimal.
I am only passing it as string. While exporting to excel ,i cant able to make calculations on this field
because it is exported as string.
Is there is any other way to dispaly the value as 123.456,00 € in the report and exported to excel as numeric
to perform calculations
Plz give your suggestions

Regards,

Sakthi

hai

I have solved this problem by using Laguage property for the report.

You can change the report language to french -belgium

And now you can able to display decimal value in french format

Regards

Sakthi

Friday, February 24, 2012

display reporting services objects only during printing

Hi all
Is there a way to suppress the text box, table etc in a reportin
services report while displaying it on the browser and display the
when the report is printed
Thanks
ringnot today.
there is no way to know how the report is rendered (HTML, PDF, print...)
its an important feature and everyone wait for it
"rings" <sridevi3@.hotmail-dot-com.no-spam.invalid> wrote in message
news:i8udnSeuL747JU3fRVn_vg@.giganews.com...
> Hi all,
> Is there a way to suppress the text box, table etc in a reporting
> services report while displaying it on the browser and display them
> when the report is printed?
> Thanks,
> rings
>

Sunday, February 19, 2012

Display of reports on browser with Custom Assembly

Hi friends,

We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc.

So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Referance. We have stored that DLL at two different locations also

C:\Program Files \Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

so when we run our reports from Preview tab DLL is just wroking fine.

But when we deploy all our report on Brwoser and when we try to execute them from browser DLL is now working i.e no function value is working. only normal report without styleing is coming.

So can anyone help me out coz this is very argent

any help will be greatly appreciated

RTFM ;)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_6d0i.asp

especially:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_0so6.asp

I gave my custom assembly FullTrust:

<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyNewCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\MyAssembly.dll"/>
</CodeGroup>