Can We A Use A CSS Or Equivalent For A Reports(RDLC File)

Jul 3, 2007

Hi,





I will be using RDLC files to display reports in various pages.





My Question is this.



I need to use the same type of formatting of color,fonts,font sizes and the background colors so that the same can be used across the reports.



This is somewhat like using a CSS file for aspx pages.



Any ideas... , solution........, .......

View 8 Replies


ADVERTISEMENT

Rdlc Reports

Feb 26, 2008



I am having a rdlc report in which i have to fit the image. I dragged and dropped the Image from the toolbox. I am able to get the Image but if the image is small i want to get small or else if the image is big i want to get big image . At the moment i am getting same for both of them. I am using VB.net to get the Image and sql2005. Any solution for this....

View 1 Replies View Related

Render Html In .RDLC Reports

Jun 8, 2007

Hi all,



I am using the asp.net web application and microsoft visual studio reportviewer control and rdlc for creating a report ( not using sql server reporting). I used the Product table to view the result. It has five fields and I display all the itemsin the report. One field is Description and it store the html code as the value(eg:<div><ul><li>a</li><li>b</li></ul><b>aaaa</b></div>). I want to disply the output of this html code in my report's description field. But in my report, it shows the html value that I stored in my table (:<div><ul><li>a</li><li>b</li></ul><b>aaaa</b></div>). How can I render the html in my report. Please give me a solution.

View 6 Replies View Related

Reporting Services :: RDLC Reports Renders Very Slow

Oct 25, 2014

I am creating an RDLC report. but it is rendering very slow. I have very small amount of data and still it takes a long time in rendering. I thought it might be due to amount of SQL data so i cut data to 5 rows and 5 columns only. still it renders very slowly.I am using Visual Studio 2012 and SQL server 2012 for deployments. Also i have a good hard ware configuration and still it takes upto 5 minutes in loading a report.

View 2 Replies View Related

Reporting Services :: RDLC Reports Render Fonts Incorrectly

Apr 8, 2011

We have this problem?

View 5 Replies View Related

Crystal Reports GridRowColumnValue Equivalent In Reporting Services

Feb 20, 2008

Hi,

I am converting a crystal report cross-tab, in to a reporting services matrix. The cross-tab uses a GridRowColumnValue function to hide/show the data & total fields.
Is there an equivalent in reporting service or a workaround method for this?

Thank you

N

View 1 Replies View Related

Can You Encrypt The Rdlc Xml File To Keep Someone From Changing It?

Feb 21, 2008

this idea goes with my post on licensing reports. Is it possible to deploy an encrypted rdlc file and have custom SSRS pages that will decrypt it, run it, manage it, etc? We were thinking what is the point of custom SSRS pages for licensing if the rdlc is just a plain xml file any one can see, change, copy, etc.


thanks

View 1 Replies View Related

Reporting Services :: How To Convert RDL File To RDLC Step By Step

Jun 18, 2012

I want to convert .rdl  to .rdc need full steps.Actually i created .rdl report using sp sucessfully.Now i want to convert it to rdlc while doing it iam getting some authentication error and some thing else.I created rdl in 2008 and i want to change it to rdlc 2010.

View 5 Replies View Related

Loading Sql Files From A Master File Oracle Equivalent

May 19, 2006

Hi.I need to give my customer an sql file that they can run in query analyzer.All the stuff they need to run is in a set of existing files.I'd like to just tell them to load this file (this is oracle syntax):@file1.sql@file2.sql@file3.sqlis there some way of calling these files (that are in the same dir) from amaster sql file?ThanksJeff Kish

View 2 Replies View Related

How To Send The Reports As An Exe File

May 22, 2007

Hi,

can any one tell me how to send the reports as an exe file. Is there any possibility in ssrs. I have to send all my reports to my client along with the .net application. can any one help me out in this. Thanks in advance

View 7 Replies View Related

Merge Two Reports Into One Pdf File

Mar 31, 2008


I have 2 reports. It has different header, detail and footer respectively. I want to do one thing now. When I click the hyperlink in browser, it can download a PDF file that is merge 2 reports into one. Anyone has solution? (I think use the subreport is not a good idea because subreport must has the same header and footer.)

View 3 Replies View Related

Is It Possible To Have The .rds File In Reports Folder

Mar 13, 2007

Since i have 5 different projects all has the same kind of reports., but calling via 5 different sites all sites on same webserver.

The problem i have is the .rds file name is same in all 5 report projects and it is a shared datasource., now when i compile the report project it will not load or overwrite the .rds file since the name is same, for that reason i tried to have the .rds file in reports folder as a datasource not a shared datasource. but i tried to add it, after i create the datasource, it is automatically going into the shared datasource folder, how can i create a datasource not shared under reports folder.

Thank you very much for all your help and information.

View 3 Replies View Related

Help With Generating Reports And Saving To File.

Jun 27, 2007

Hi, I'm a first time user at reporting services and in dire need of some help, I'm having a real hard time finding the information I need.



I have made two reports in Business Intelligence Development Studio that access a sql database and I can deploy them and see them at http://localhost/reports etc.



What I wan't to do is be able to "trigger" the reports to be built from a schedule (e.g. every 8 hour on weekdays, every 12 hours on weekends but should be able to be changed) and after built to be saved to a html file.



I also need to set the sql query for the dataset before generating the report (select * from table where DateTimeType between This and That).



Anyway, I'm completely lost on how to achive this and would greatly appreciate and tips or pointers to where the information can be found.



Kindest Regards

View 2 Replies View Related

Creating Reports Based On Hierarchical XML File

Jul 20, 2005

Hi,We have XML files (and its XSD) that are dump of our tree-like datastructure in memory. These XML files may potentially have unlimitedlevels of nesting because some elements can contain themselves(recursively defined).We want to build some reports using some third party reporting tool(Crystal Report, for example).The first question is - is there any way for Crystal Reports toprocess such complicated (some elements have recursive definitions)XML file directly? If not, anyone knows any other reporting tool thatcan do that job?The second question is - if we have to develop a small applicationthat converts the XML to dataset, anyone who has done similar thingbefore can give us some recommendations as to which approach is theeasiest to take (Java, .NET, etc.)? I'd appreciate it if someone canpoint me to some resources to get me started.Another approach is to convert the hierarchical XML into relationaltable set and store the data into relational database. In that case,the reporting tool can simply read from the database. I'd appreciateit if someone can let me know if there is any softeware/program thatcan do the conversion. (I heard that some database server can do theconversion from XML to relational tables, but didn't find anythingconcrete.)Any comment/recommendation is appreciated!Thank you for your help in advance!!

View 1 Replies View Related

Limit File Size Of Subscription Reports

Mar 27, 2008



I have a report subscription this is generating PDF files. The end user of the PDF files requires these files to be below a certain threshold in file size. Is there any way to set up a subscription to generate files that are under the threshold size?

If I knew approximately how many records would generate a report below the threshold, is there a way to generate several reports all of which are below the threshold?
Thanks.

View 4 Replies View Related

How To Render Multiple Reports Into One Output File?

Nov 21, 2006

We are using SQL Server 2005 Reporting Services and looking to render multiple reports into one output file. So, for example, say we have four reports and when the user asks for the reports to be generated, we would like to have all four reports come out in one PDF (or Excel or HTML) file instead of four separate files. I hope this makes sense.

Is there any way to render multiple reports to one output file?

Thanks!


View 9 Replies View Related

Manage Reports Using Report Manager But Do Not Allow Upload File

Mar 21, 2007

Hello, I need to be able to view and save reports using Report Manager. However, I do not want some users the ability to upload files (need to prevent virus or bad files). It appears I need to select manage reports from the role definition in order for a user to save reports. but then i get the upload file link as well. Is there a way to manage reports but prevent upload file link?

View 2 Replies View Related

History Of Report Definition File For Published Reports...

Jun 26, 2007

I would like to know if there is a way to maintain the history of changes to the reports that have been published to the report server?

I know that the report definitions get saved onto ReportServer database. But let's say a user makes a change to the published report and then saves it back to the server. And that the latest change was incorrect and I have to revert back to the previous version of the published report. Is there a way to do that? Does the report server maintain a history of previous versions.

There is a history for each report and I think that corresponds to the history of report executions (output data). But I am talking about the history of actual report definition.

Thanks for you help.

View 2 Replies View Related

Any Editor For Rdlc?

Nov 2, 2007

I would like to use SQL client-side reporting in ASP.NET. However, our customer would like to edit the report sometimes, is there any existing graphical editor to edit .rdlc file?
Thanks.

View 1 Replies View Related

How To Set Page In RDLC?

Mar 31, 2008

I am using Local Report, .RDLC, I want to Set PageName A4, How Can I set PageName in Report .RDLC??

I can set Page Size but I wan to Set Page Name.


Thanking You.

View 1 Replies View Related

RDLC Vs RDL Revisited

May 8, 2007

I have searched the archive of this forum, and based on some previous answers have read the followin FAQ



http://www.gotreportviewer.com/



However, even so, I still have a questoin about when to use RDLC vs RDL from the point of view of licensing and load sharing betwee DB and report server.



1. As we all know that SSRS will take a license of SQL Server if the web service is deployed on any other machine other than SQL Server (which is normally the case because no serious DBA will allow IIS apps to be installed on the DB Server). Also, if the SSRS is deployed on NLB cluster then each node of the cluster would need a "SQL Enterprise" license. (which can be very expensive).

2. Co deploying the SSRS with SQL Server is a bad idea because it puts excessive load on the DB+Report Server.

3. Since there is no "load balancing" in SQL all the rendering has to be done by the SSRS service which is running on the DB Server.



Now compare this to RDLC



1. RDLC gives me the same engine as RDL

2. However it has no licensing tags to it.

3. I can deploy ASP.NET report viewer on my web farm and scale it out as much as I like.

4. Extract data from the DB using stored procedures.



So it seems that RDLC solution is cheaper, gives better scale out capabilities and also moves the rendering of reports on the web farm rather than the Report Server.



Why should me or anyone else choose RDL at all?



There seems to be one disadvantage that the data has to fetched programmatically and manually binded (like an ASP.NET app) as RDLC does not provide any feature to connect to data sources. But this is not much when you see the cost and scalability benefits.



regards,

Abhishek.

View 6 Replies View Related

.rdlc Table Use Of SUM And SWITCH Together?

Jan 19, 2007

Hello everyone, thanks in advance for reading. I'm new to reports and have tried searching for my answer with no luck. Any direction would be great.

Here is the issue, I have 3 colums in the dataset which display String data ("High", "Medium", or "Low")

I've added a column to the table on the report where I would like to convert the value of "High", "Medium" and "Low" to 3,2,1 respectively then SUM these numbers.

Is this possible? I've tried several variations of the code below--maybe it's not possible to do what I want? Thanks again for your time and help.



Fields!PP.Value is set to:
=Switch(Fields!Avail_Rank.Value = "High", 3, Fields!Avail_Rank.Value = "Medium", 2, Fields!Avail_Rank.Value = "Low", 1)

=Switch(Fields!Volume.Value = "High", 3, Fields!Volume.Value = "Medium", 2, Fields!Volume.Value = "Low", 1)

=Switch(Fields!Integ_Rank.Value = "High", 3, Fields!Integ_Rank.Value = "Medium", 2, Fields!Integ_Rank.Value = "Low", 1)

=Sum(Fields!Avail_Rank.Value + Fields!Volume.Value + Fields!Integ_Rank)

View 3 Replies View Related

Add Serial No In Report.rdlc

Jun 20, 2007

hi forum

how to add Serial No in "Report.rdlc". I want to add SNo. in as a extra field in Report.

SNo. ItemName Price

1 abc 10

2 xyz 20

View 5 Replies View Related

Converting .rdl To .rdlc Files.....help!

May 9, 2007

Hey there guys!

I am trying to convert, (as the title suggests), an already created .rdl file to a .rdlc file. I have googled it and yes came across the most informative "step-by-step", however even after renaming to .rdlc and opening the file in SQL Server 2005 BI the file is still not being deserialized using the reportdefinition from 2005.



Can somebody please help with this and provide me with something a little clearer than "...you must convert the file.".

Thanks in advance for all your help,

Ron

View 3 Replies View Related

Reporting Services :: Default Path For Saving Reports On File System?

Jun 23, 2015

during period of troubles connecting to Local Servers and Sites location i.e., to [URL], the place where all Reports are saved by default, I have continued to work on some Reports that have been saved to file system of my localhost/developing machine. But, upon recovery of http location, I can not see/open those files?

how to approach those files in order to open them in Report Builder 3.0 and thus, to "save as" them to the http location? Seems that Report Builder has chosen that location, by default, somehow.....

View 2 Replies View Related

RDLC Report Formatting Issues

Mar 9, 2007

We have developed client SQL Server Reporting Services reports (rdlc) that are completely dynamic.

Everything on the report itself is build from code.

There are a few problems in the formatting of these reports that we have not been able to correct.

1) Because of the way the data has to be displayed. we have had to use a List control with Textboxes and Lines within to give the appearance of a table.(Column headers are textboxes with background set to gray). Line controls exist between each column of data. We did this because we need to have nested lists in some cases to display the data.

The height of the listbox is adjusted to fit the contents within. The vertical lines between the columns appear broken with gaps between each item.

Is there any way to set the line height to automatically fit the height of the ListBox.

2) Another issue we have is with Texboxes. If there is no value in the Textbox, the borders do not show. CanShrink is set to false. Hidden is false. Is there any other setting or something else that could be causing this?

View 1 Replies View Related

RDLC And Excel - No Grid Lines

Jul 9, 2007

Using ASP.NET 2, C#, Web application, we have an rdlc report which will be primarily used to export to an Excel spreadsheet. When we run thw report, then export it, we wind up with a spreadsheet with no gridlines, eg a spreadsheet with invisible cell borders.

Is the a setting or property somewhere which can be changed so that the spreadsheet which opens after the export looks like a standard spreadsheet, that is, with visible cell borders?

Many thanks
Mike Thomas

View 2 Replies View Related

Passing String To Rdlc's TextBox

Jan 23, 2008



Hello
I am pretty new to reporting services. Now i have something like this. on the .cs file, i have a fullName lets say
String fullName = "John Smith",
Now I want to pass this string to the report's textBox and show this value on this textbox.

How can i do this?
1.How should i write in .cs file?
2. How should i set the expression for the textbox?

Thank you very much. It is very urgent! Please help!

View 6 Replies View Related

Work Around To Display RTF Text In RDLC?

Apr 18, 2008



Hi,

We had come a long way in implementing reports using RDLC and now we are stuck with the requirement to display RTF text using RDLC.

Is there a way to display a RTF Text in RDLC in a purely managed code?

The links mentioned below provides a work around solution to this but a part of its implementation is in un-managed code.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=551939&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1

Iam also curious to know if Microsoft has released a patch or service pack that supports RTF in RDLC?

Iam using .NET 3.0 with SP1 and my backend is MS-SQL Server 2005 Express Edition.

Thanks & Regards
Arvind T N

View 1 Replies View Related

Stream A Rdlc Report From Dll To Browser

Apr 22, 2008

I have a very simple test report created in Visual Studio 2005 as an rdlc file in my dll. The rdlc file is in the dll because it is built off of the business objects. I need to be able to stream this file (i.e. not use a report viewer) to the browser.

I found code that I included below, but get an error:

The report definition for report 'Monkey.Report1' has not been specified

Yes my test namespace in my dll is named "Monkey" )

Anyway, any idea on how to solve this?





Code Snippet
using Microsoft.Reporting.WebForms;

protected void Page_Load(object sender, EventArgs e)
{
LocalReport localReport = new LocalReport();
localReport.ReportEmbeddedResource = "Monkey.Report1.rdlc";

ReportDataSource reportDataSource = new ReportDataSource("FamilyCollection", Monkey.Family.RetrieveAll());
localReport.DataSources.Add(reportDataSource);

string reportType = "PDF";
string mimeType;
string encoding;
string fileNameExtension;

string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>1in</MarginLeft>" +
" <MarginRight>1in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";

Warning[] warnings;
string[] streams;
byte[] renderedBytes;

//Render the report
renderedBytes = localReport.Render(reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);

//Clear the response stream and write the bytes to the outputstream
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=foo." + fileNameExtension);
Response.BinaryWrite(renderedBytes);
Response.End();
}

View 1 Replies View Related

Bind Object To RDLC Report

Apr 8, 2006

Hi,all
I hava a question about Bind object to RDLC Report,the RDLC like
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="DummyDataSource">
      <ConnectionProperties>
        <ConnectString />
        <DataProvider>SQL</DataProvider>
      </ConnectionProperties>
      <rd:DataSourceID>47739726-cc8c-4719-b061-c392c2cceb68</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <BottomMargin>2.5cm</BottomMargin>
  <RightMargin>2.5cm</RightMargin>
  <PageWidth>21cm</PageWidth>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>21cm</InteractiveWidth>
  <rd:GridSpacing>0.25cm</rd:GridSpacing>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <Body>
    <ColumnSpacing>1cm</ColumnSpacing>
    <ReportItems>
      <Table Name="table1">
        <Footer>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox7">
                      <rd:DefaultName>textbox7</rd:DefaultName>
                      <ZIndex>7</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox8">
                      <rd:DefaultName>textbox8</rd:DefaultName>
                      <ZIndex>6</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox6">
                      <rd:DefaultName>textbox6</rd:DefaultName>
                      <ZIndex>5</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox9">
                      <rd:DefaultName>textbox9</rd:DefaultName>
                      <ZIndex>4</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value />
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.63492cm</Height>
            </TableRow>
          </TableRows>
        </Footer>
        <DataSetName>WindowsApplication1_MedcialCase</DataSetName>
        <Top>0.25cm</Top>
        <Details>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="ID">
                      <rd:DefaultName>ID</rd:DefaultName>
                      <ZIndex>3</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!ID.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="Name">
                      <rd:DefaultName>Name</rd:DefaultName>
                      <ZIndex>2</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!PatientOfMedcialCase.Value.Name.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="Name_1">
                      <rd:DefaultName>Name_1</rd:DefaultName>
                      <ZIndex>1</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!Name.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="PatientOfMedcialCase">
                      <rd:DefaultName>PatientOfMedcialCase</rd:DefaultName>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!PatientOfMedcialCase.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.63492cm</Height>
            </TableRow>
          </TableRows>
        </Details>
        <Header>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox1">
                      <rd:DefaultName>textbox1</rd:DefaultName>
                      <ZIndex>11</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>ID</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox2">
                      <rd:DefaultName>textbox2</rd:DefaultName>
                      <ZIndex>10</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox4">
                      <rd:DefaultName>textbox4</rd:DefaultName>
                      <ZIndex>9</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Name</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox3">
                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <ZIndex>8</ZIndex>
                      <Style>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingBottom>2pt</PaddingBottom>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>Patient Of Medcial Case</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.63492cm</Height>
            </TableRow>
          </TableRows>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>5.33333cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>8cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>5.33333cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>5.33333cm</Width>
          </TableColumn>
        </TableColumns>
        <Height>1.90476cm</Height>
      </Table>
    </ReportItems>
    <Height>5cm</Height>
  </Body>
  <rd:ReportID>a69b2d8e-258a-4212-8d4a-c67c96055732</rd:ReportID>
  <LeftMargin>2.5cm</LeftMargin>
  <DataSets>
    <DataSet Name="WindowsApplication1_MedcialCase">
      <rd:DataSetInfo>
        <rd:DataSetName>WindowsApplication1</rd:DataSetName>
        <rd:ObjectDataSourceType>WindowsApplication1.MedcialCase, WindowsApplication1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null</rd:ObjectDataSourceType>
        <rd:TableName>MedcialCase</rd:TableName>
      </rd:DataSetInfo>
      <Query>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
        <CommandText />
        <DataSourceName>DummyDataSource</DataSourceName>
      </Query>
      <Fields>
        <Field Name="ID">
          <rd:TypeName>System.Guid</rd:TypeName>
          <DataField>ID</DataField>
        </Field>
        <Field Name="PatientOfMedcialCase">
          <rd:TypeName>WindowsApplication1.Patient</rd:TypeName>
          <DataField>PatientOfMedcialCase</DataField>
        </Field>
        <Field Name="Name">
          <rd:TypeName>System.String</rd:TypeName>
          <DataField>Name</DataField>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <Width>24cm</Width>
  <InteractiveHeight>29.7cm</InteractiveHeight>
  <Language>en-US</Language>
  <TopMargin>2.5cm</TopMargin>
  <PageHeight>29.7cm</PageHeight>
</Report>

the object I bind  to the Report like

public class MedcialCase
    {
        private Guid iD;

        public Guid ID
        {
            get { return iD; }
            set { iD = value; }
        }

        private Patient patient;

        public Patient PatientOfMedcialCase
        {
            get { return patient; }
            set { patient = value; }
        }

    }

    public class Patient
    {
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }

    }

and the code bind object to report like

  MedcialCase medcialCase = new MedcialCase();
  medcialCase.ID = Guid.NewGuid();
  Patient patient = new Patient();
  patient.Name = "Michael";
  medcialCase.PatientOfMedcialCase = patient;
  this.MedcialCaseBindingSource.DataSource = medcialCase;
  this.reportViewer1.RefreshReport();

I choose the MedcialCase.ID and MedcialCase.PatientOfMedcialCase.Name to show, but when the report was run ,,just MedcialCase.ID has been shown,
the text of MedcialCase.PatientOfMedcialCase.Name is "=Fields!Name.Value"

I modify it to "=Fields!PatientOfMedcialCase.Value.Name.Value" and run it ,the "#Error" show in the text of Name

anyone can tell me why?and how to bind object like MedcialCase to the Report?

thanks!

 

View 9 Replies View Related

Local Report (RDLC) Formatting

Feb 22, 2007

I cannot find anything that would suggest it is possible to use a cascading style sheet when formatting data elements within a local report (RDLC). We created an HTML report using CSS and now want to generate the same report using the Report Viewer control along with our defined styles.

Any ideas?

thank you

View 1 Replies View Related

Create Report.rdlc In Vb.net Dynamically

Oct 23, 2007

I' m using Microsoft Reporting. Is there a way to create Report .rdlc file Dynamically on the fly? I' m using VB.net.
Any help can be appreciated.
Thanks
Mythili

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved