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>

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.
|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.
|||Hi Murali / Nilay,
Hope this link will explain you in setting Parameter value.
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.|||Hi Murali / Nilay,

Hope this link will explain you in setting Parameter value.

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.|||Hi Murali / Nilay,

Hope this link will explain you in setting Parameter value.

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.
|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.
|||Hi Murali / Nilay,
Hope this link will explain you in setting Parameter value.
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.|||Hi Murali / Nilay,

Hope this link will explain you in setting Parameter value.

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.
|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.
|||Hi Murali / Nilay,
Hope this link will explain you in setting Parameter value.
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.|||Hi Murali / Nilay,

Hope this link will explain you in setting Parameter value.

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx

Display DB Table in ASP

hello forum friends,

i need to display the database table in ASP

page.how it is possible,can anyone explain me

with code.

Regards

Prathap

What about:

http://www.stardeveloper.com/articles/display.html?article=2002061201&page=1

Jens K. Suessmeyer

http://www.sqlserver2005.de