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


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

Can Report Builder mimic something like MS Word's "Column" formatting with a lot of table data?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Greetings,

I want to make a report that shows the sign-in of a list of people. There will be anywhere from 40-200 people signing in per day. I need to print this data. The columns in the row are small: [firstname, lastname, id number].

What I would like to do is have 2-3 mega-columns, which each "mega"-column contains [firstname, lastname, id number]. I'm using the phrase mega-column to distinguish from a normal column in the context of a table.

Is that possible with report builder? My production platform is IIS7.5 with ASP.NET 4 and MVC3. I am planning on generating PDFs for the user to print. However, right now it looks simpler to just format html with stylesheets and have that print.

Any help would be appreciated.

 

-Jimmy




View Complete Post


More Related Resource Links

Report Builder Report manage data sources - relink programmatically

  
As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

is it possible to make 2 column name badges with Report Builder 2.0?

  
I am starting the process of moving reports from Crystal to SSRS and I am trying to build what I beleive should be a simple two, column (Avery 74461) name badge report.. It should look like this...       NAME                           NAME FULL NAME                   FULL NAME  COMPANY                    COMPANY Yet I cannot find anything in the forums or help system... Basically it is a 4 up by 2 wide name badge page.. i need different names on each badge.. Is this something it can do or no? and if so can I have some type of example on page layout field system to use? (ie: matrix, text boxes, etc)   Thanks!  

Applying conditional formatting to the 'AssignedTo' column does not work in a data view using Shar

  
This one is throwing me for a loop.  I've joined two lists using "Linked Sources" in SharePoint Designer.  On a new ASPX page I added a data view and added 3 columns (Title, Priority and AssignedTo) as a multi-Item view.   I can select a row and apply conditional formatting to the Title field (changing the background color if @title = 'Parent 1') and the changes are displayed in the design pane.   The only oddity there is that I have to go back and edit the condition in advanced mode, changing the XPath expression from ../../../Rows/Row/@Title = 'Parent 1' to @Title = 'Parent 1'  and then it seems to work just fine. Here's the problem.  I want the condition applied to the AssignedTo column (hide row if 'AssignedTo != 'John Doe')  If I create a condition to hide contents if the AssignedTo = 'John Doe' it creates the XPath expression ../../../Rows/Row/@AssignedTo = 'John Doe'.  When I save it, the row is still visible.  If I edit the XPath expression, changing it to @AssignedTo = 'John Doe' and save it the row is still visible.  The same is true if I simply try to change the background color, conditionally formatted  against the AssignedTo column. Does anyone have any ideas here?              

Update one column of a table with data from another table

  
I have two tables which are different with the exception of a single field (column name = "LocationCode"). Both tables can also be joined with a common id field. I would like to update the "LocationCode" values in one table with the the "LocationCode" of the other table. I can do a relational join on the common id. It is impractical for me to update one row at a time. How can I update all the rows quickly?   But one more point both tables lies in different database Varinder Sandhu http://varindersandhus.blogspot.com/

Update one column of a table with data from another table

  

I have two tables which are different with the exception of a single field (column name = "LocationCode").

Both tables can also be joined with a common id field.

I would like to update the "LocationCode" values in one table with the the "LocationCode" of the other table. I can do a relational join on the common id.

It is impractical for me to update one row at a time. How can I update all the rows quickly?

 

But one more point both tables lies in different database


Varinder Sandhu http://varindersandhus.blogspot.com/

How to show varbinary data on the report builder normally?

  

Hi everyone,

The varbinary column type data will show #error on the report builder, is there a way to show it correctly? convert or other?

 


Where there is great love, there are always miracles.

Report Builder 2.0 Strange column when using model

  
Hi, We have build a simple dsv and model and are writing reports in report builder. Every time we add in a linked table we are getting a column appearing with strange values e.g. "AH.gEAAA=" these appear to come from no where and have a column name the same as the table, Can anyone please explain what they are and how to get rid of them please.

Table formatting in word document using C#.net

  

I need to form my word document(#30 pages) like this using c#.net:
A   C
Table
B   D
E   F
G   H
Table
I   J
Table
K   L

Here A,B,C,D...  are the text paragraphs and the page should split into two columns and if table comes it should come in one colume.
Please can one help me in this regard.


SSRS Word Export Issue- Last Column Data getting Trim

  

We are exporting a SSRS report in Word. The last colum is getting displayed without its right side vertical bar. Data is also getting trim. Please let us know the solution on this.

 


create a new table column with data...

  

I have created a web project using asp.net and visual web developer 2008.  On my local project I created a new column in one of my MS SQL data tables and populated it with data.  How would I create a sql script of the new column and data?  I want to insert this into my live database on Godaddy? 

Thanks,

Photon


filter table data to report

  

hello,

I have a table which captures the updated data. I need to generate a report on updated fields.

Could you please tell me how to filter the updated data from the table to display in the report.

I'm new to this so i need the sql code or stored procedure to filter and show only the updated data.

 

Well I have time stamp as well as a column for last changed date.

 

i need to produce all the fields pertaining to the updated cell in a single cell of the report.

for instance i change the last name of the person - i need to produce the persons firsname , updated lastname, his address and other details in a single cell of a report.

 i also need to show the records in both ascending and decending way - like most recent update of the day and first update of the day.

so how do i code for this.

 

thank u for your help


filter the data from a table to a report

  

hello,

I have a table which captures the updated data. I need to generate a report on updated fields.

Could you please tell me how to filter the updated data from the table to display in the report.

I'm new to this so i need the sql code or stored procedure to filter and show only the updated data.

 

Well I have time stamp as well as a column for last changed date.

 

i need to produce all the fields pertaining to the updated cell in a single cell of the report.

for instance i change the last name of the person - i need to produce the persons firsname , updated lastname, his address and other details in a single cell of a report.

 i also need to show the records in both ascending and decending way - like most recent update of the day and first update of the day.

so how do i code for this.

 

thank u for your help


Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio

  

I need some help.

 

If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.

 

My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.

 

Is this a bug or am I missing a setting?


Importing table/ column details from one report to another

  
is it possible to import a value present in the  column/table of a report to another report. The is just to avoid the creation of datasets again in the second report.

Table name , Column name from Data value

  

Hi,

   I have 3 tables namely  T1 with column A,B,C and T2 with columns  D,E ,T3 with columns E,F .  A data namely 100 is present in any of the column . Need to find out the column name and Table name where that data exists . Please advice .

Regards

Selvaraj


Report Builder:The type of the data source has not been specified.

  

HI,

I am getting the folloing error when I try to run the reeeport through report builder

The type of the data source has not been specified.

----------------------------
An error has occurred during report processing.

Please tell me what can i do to avoid this


data connections in data connection libraries as consumed by Report Builder and SSRS

  

A data connection to a SQL DB is created and published to a data connection library in SharePoint 2010.  When Report builder or SSRS consume this connection, does the actual network connection happen between the SP server and the DB or the client machine and the DB?  And is this different based on whether you use SSRS or Report Builder?  

The reason for the question is that the firewall is open between the SP farm and the DB but NOT between the client machine and the DB and I'm trying to figure out if this will be a problem or not.

Additional clarifications that may be helpful.  SSRS (SQL 2008 R2) is in SharePoint integrated mode and we are specifically talking about rsds files.


Categories: 
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