.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cross tab dynamic report

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

Hi i have the following scenario we have a table named property with intPropertyId as pk

we have two more tables 1 is custom_tables custom_columns

custom_tables have table names

custom_columns columns have column names which are user defined column with property

and finally we have a custom_columns_values table as mapped table with custom_columns

so we have intPropertyid incolumnid varValue column as column value sql_variant against every property

now i have to create report which shows column names as column names and their values as values

i have tried pivot but its not working is there any way i can print dynamic or user defined columns as columns and their values as rows

View Complete Post

More Related Resource Links

Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


Dynamic Report in reportviewer


HI I m sorry to say this But this task too urgent.

 Ex- i have two tables in my db name called Comdetails, deptdetails.

TCS is a one company name stored in ComDetails and Company_ID took as primany key,

TCS having 10 department stored in deptdetails and Company_ID as foreign key.

so now in DB we have available one company with 10 departments.

so now i need to generate report , i m using report.rdlc and reportviewer.

i hope upto now its clear.

my task-

1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

Include a Crystal Report in .NET Web Service for Dynamic In-Memory-Only DataSet



I would like to use Crystal Reports in a .NET web service.  Ultimately I would like to convert my report document to a PDF and then return the PDF as a byte array. 

My .NET DataSet is generated dynamically at run-time.  It consists of four related tables.  Since my DataSet does not have a physical datasource, I created an XML Schema file.  I then added the XML Schema file to the web service project with Add Existing Item. 

A solution for working with a dynamic in-memory DataSet exists for ASP.NET web sites and client-based forms.  I tried to use this method as it is published.  When that didn't work I tried creating the report and XML Schema directly in the web service project, but that also didn't work.


The problem is apparent when you try to set the datasource.......the code bombs on the call to SetDataSource(DataSet) with the message
ex = {"The data source object is invalid."}

Crystal Reports would save me a lot

Make dynamic changes to ReportViewer Report design InteractiveSize property


Hello all,

Could someone share with me how to dynamically change the Report design InteractiveSize property?  I want to use a radiobutton list which has two options (complete list, paginated list) which changes the height of the Report display.  I wonder if I need to use the Report Parameters but how do I change and refresh to display the selected option.  Thank you.


Cross validation report - settings

Hi,I am curenttly running a logistic regression model, and a resulting cross validation report, in SQL 2008. A large amount of analysis is done on the data before it is run into the logistic regression algorithm to ensure its predictiveness, and that multicollinearity does not reside with the dataset.Due to the fact that the dataset is streamlined before it is run into the logistic regression algorithm the maximum number of input and output variables are set at 0. The system never exceeds 20 variables at the best of times (Dataset is discrete in nature). The remainder of the settings for the logistic regression algorithm are set at default.The cross validation report settings are as follows: "Data set" - Use test cases   "target attribute" - Applicable variable that is being predicted within the logistic regression algorithm   "target state" - 0   "target threshold" - 95  "test list" - null The issue that I face is that the log score that is usually returned by the cross validation report is negative e.g. gets very close to 0 but never crosses into positive territory. (I interpret this a being not a great result). I have tried to run different datasets through the algorithm, and have adjusted the "target threshold" downwards, but I unfortunately seem to encounter the same issue on each run.Do you have any suggestions as to how this can be improved? Do I for instance,

Dynamic SQL statement for a multilevel hierarchy report

Basically I have a requirement from the functional team that need to show a multilevel hierarchy report.   ID ParentID A NULL B A C A D B E C F C G F   The above is the sample of the table.   I need to show the cascading relationship dynamically base on the available level. The issue was we would not know how deep the relationship in the table.   Target Result:   ID Parent Level 1 Parent Level 2 Parent Level 3 A NULL NULL NULL B A NULL NULL C A NULL NULL D B A NULL E C A NULL F C A NULL G F C A

Dynamic Columns Using Report Viewer Control

Hi,, I'm using Report viewer Control to generate reports.Currently i have static columns..I need to have columns created  based on the DB Query  results i.e., DB query will return more columns under certain conditions and less columns in another...In Short,Headers and column data will be known only at runtime.how can i bind the data dynamically...what can i do to accomplish this..

Creating Dynamic Group Fields for a Crystal Report?

I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it. Thanks, Blake

Dynamic or Expression-based Report Page Properties

Hello, I have a tablix(table) with column grouping making the number of columns dynamic. Although our customers have been warned that this could lead to the columns going beyond the edge of the normal landscape 8.5x11 inch page, they have asked for alternate solutions. Beyond rotating the column labels and reducing fontsizes, the issue is not so much that it goes off the page, but the fact that in print preview mode the data is broken up requiring that you go to the next page to get the remaining data. What I am investigating is whether the Page Properties of the report body, either the pagesize property and/or the interactivesize property, can be manipulated at run time? This way if a user, based on their experience with the parameters they usually select and pass into the report, knows that the results will span the length of the page onto a second page, could choose a new parameter such as pagesize/interactivesize so that it changes from 8.5/11 to perhaps the next standard page size of 8.5/14 inches? This does not mean the contents would change during the course of rendering the report, just a new input that could decide at run time what paper size to use in print preview mode.   Thanks.

Using Sub reports and dynamic crystal report generation

Hi..........friends,         I am working on crystal reports to generate Ration card details.My form  consists of the fields like Address details of the ration card owner,existing ration card details and family members details.in these Family Details i have to generate dynamically according to the count of the family members.I am new to crystal reports.I am confusingabout whether i have to use sub reports or formula fields.................               Plz help me                                                                    Thanks in advance      

dynamic Dataset-Crystal Report

Hello everybody, i'm developing a C# application in which i'm using crystal reports to display data from database. i'm trying to create a dynamic dataset since it's going to be filled from multiple classes i'm not able to fill these dataset unless i add to my sql query the "column AS columName" for example:"select nmClient as Name from customer " ; if i write down "select nmClient  from customer", it won't work   please let me know if there any ulternative solution in order to solve my problem   thank you in advance  

generate dynamic fields crystal report

  I want to add a Dynamic column in Crystal report at run time. Because I dont know about the columns in design time. The columns will come based on the user selection. So i want to Add a column to Crustal report at run time. I am using Crystal report. If it is not support to add column in Crystal report at runtime. Please kindly give the other solution or other third party tool like. Which version will support to add dynamic column in Crystal report? i already used the crosstab report but thats not work for my scenario.becoz i want to add another colums at right side ( after total of each row ) , which is crosstab report not supported 

SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

Dynamic file name in File based report delivery


I am trying to implement a report delivery mechanism which is file based. So the report will be generated in pdf or excel and placed in file share location.  The name of the file needs to be dynamic.  For e.g. : if the report I am running is Daily sales for store 101 with a sales amount of $150 and for the date 03/22. I need to generate a pdf with file name dailysales_101_150_032210.pdf

There are some parameterized report generation scenarios as well. In that case the report name should include the parameters provided. In the above example itself if all the values above are provided as parameter, the report should be generated for the given parameter and the name should contain the parameter.

Has anyone had this requirement and implemented a solution before ? Can this be implemented in a standard subscription & data driven subscription. any custom code is required in order to implement this or can this be done by configuration in SSRS ?

thanks for your help.


Generate a dynamic number of custom report item instances in a report


Are there any solid examples/tutorials/demos of how to dynamically generate custom report item instances in a report based on the amount of rows in a data set?

Additionally I would like to insert these custom report items in a particular order based on a field in the data set.

Any help/pointers/articles would be appreciated!

How do I create a dynamic image in report server


I have two questions about report server.

Question 1: Is it wise to 1300 users to make use of reporter server order forms to print / view? or are better solutions?

Question 2: In a report to a dynamic image. The picture is on the Internet. http://www.domainname.com/images/12500.jpg
How can I display dynamic image in the report?
The filename can be retrieved from the database with the order number.

I was thinking something like: http://www.domainname.com/images/ (Fields! Article.Value)
This work, unfortunately.

Does anyone have an idea?

SSRS 2008 dynamic change to report parameter properties


I'm running SSRS 2008, and I'm wondering if it is possible to change a report parameter property based on user input in another report parameter.  What I need to do is to make report parameter #2 a required parameter if a specific value is selected in parameter #1.  Parameter #2 should be optional under all other scenario.

Thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend