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

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

Merging 2 crystalreport into 1

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :ASP.Net
Alright, I have been search through the net to combine 2 reports into one. I know about the subreport but I can't merge them in my case.I have one report with data being added into the report at runtime and another report having images being added to it at runtime as well.I tried inserting both of them to another report as a subreport but I get nothing out of it. Its blank! I was wondering if subreports only works if the data are either static or being drag out from a database. Ultimately I want to export them as a single PDF. Here's my code. AllReadings report = new AllReadings();Graph graphReport = new Graph();report.SetDataSource(readings);graphReport.Database.Tables["Images"].SetDataSource(data);Combine cbreport = new Combine();Stream stream = cbreport .ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);The cbreport holds 2 subreport. One being AllReadings and the other is the graphReport. Is there any other ways to combine them both together?

View Complete Post

More Related Resource Links

merging multiple tables in a single dataset to single table


 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

Merging PDF documents


I've generated some PDF documents.
But i like to merge all PDF documents to 1 PDF document, withouth saving it first.

So i would like to have 10 byes ans bound them together if possible...
But how?

Code i use right now:

////Then create new pdf file
            string strMime = null;
            string strEncoding = null;
            string strfileNameExtentions = null;
            string[] stream = null;
            Microsoft.Reporting.WebForms.Warning[] warnings = null;
            bytes = rep.Render("PDF", null, out strMime, out strEncoding, out strfileNameExtentions, out stream, out warnings);      


need help: HTMLEditor, Sql-Server 2005 and CrystalReport


Hi All,
i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? how to do?


Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

need help: HTMLEditor, Sql-Server 2005 and CrystalReport


Hi All,

i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? please!




Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

using CompositeCollection in ListBox for merging two Typed DataTable

Hi i have a Typed DataSet contining two DataTable : Table1 , Table2 i want to merge the two Tables in a ListBox by using "CompositeCollection " , but this doesn't work <ListBox.ItemsSource> <CompositeCollection> <CollectionContainer Collection="{Binding Path = Table1}"/> <CollectionContainer Collection="{Binding Path =Table2}"/> </CompositeCollection> </ListBox.ItemsSource> i put also : public partial class Window1 : Window { public Window1() { InitializeComponent(); this.FillDataset(); this.DataContext = ds; //this.Resources.Add("mytable1", DataSet1.Table1); }   i want to confess i don't have a clear idea about referencing an object as a Typed DataTable. also if a want to Template my ListBox lique this :    <ListBox.ItemTemplate> <DataTemplate DataType="{x:Type myprog:DataSet1+Table1 }"> <StackPanel Orientation="Horizontal"> <TextBlock Text="{Binding Path=ProductName}" Background="AliceBlue"/> </StackPanel> </DataTemplate> <DataTemplate DataType="{x:Type myprog:DataSet1+Table2 }"> <StackPanel Orientation="Horizontal"> <TextBlock Text="{Binding Path=ProductName}&quo

SQL Reporting - Merging fields into document

Currently, we have a process setup that has a user create a merge in the application, then that merge is dropped into a .csv file onto the root of the c: drive of the individual's PC... they then take the .csv file and use macros within Word and run a merge process into a document template... (these are documents that are sent to the court for renewal of an expired legal process)..  I'd like to know if there is a better way of doing this? Is there a way of eliminating the .csv file and the merge process of Word, and keep everything within SQL and the Reporting services?  Any help in pointing me to the right resources for this would be appreciated. Thanks! jill

CrystalReport:- The report you requested requires further information.

Hi Guysi am trying crystal report first time and i used xsd file  in this example and when  i tried to run this example at that time i got one page which ask me a database name and user name and password but It not allow me to write Database name.and it have one check box of integrated security. so now what to do i get stucked plz can any one help me?i have tried on other pc to but i got same request page.i want a solution which not ask me this id pass all the time.

Merging overlapping data from two databases?

We are decommissioning an older server (2000) and are in the process of migrating all the DBs to a nice new server (2005). One particular database was backed up and restored to the new server, BUT not all applications were re-pointed at the instance on the new server, they were left pointing at the old instance on the old server. Result: We have almost an entire day where some data was inserted into one DB, and some data was inserted into another. I've been handed the task of getting the data that went to the old server onto the new one. I've re-backed up the Db and restored it as a separate instance on the new server and I've been able to compare the two.  The "old" instance has about 675 records I need to get onto the new instance. Problem: 1. Trying to avoid writing a separate query for every single table in the DB, comparing the old and new instances, and inserting.  "IS NOT IN" or something similar.  I could do that but I'm swamped with work.  This project was NOT on my to-do list yesterday, but lots of other stuff was.  Anything quicker available? 2. Identity: Since the new instance took up where the old instance left off, and the old instance carried on as if nothing had changed, almost every row in every table has PKs duplicated in the other instance, but relating to a different data set. Besides shooting the individual

Get the row position of the group? merging query?

Hello! I am using SQLS2005. I have two tables: Unit: UnitId int PK Title varchar UnitOption: UnitOptionId int PK UnitId int FK Title varchar Quote: QuoteId int PK UnitOptionId int FK Title varchar I want to create a scalar UDF that takes a QuoteId param and returns a varchar that contains the following description (pseudu): Quote.Title + '-' + Unit.Title + '-' + Unit.UnitId + /* Here is where my question is: If there are more than 1 UnitOption under this Unit, then return '-' + the UnitOption number under this Unit (i.e.) if under this Unit, there are 3 UnitOption with IDs 13, 17, 55 under the unit, and the current Quote.UnitOptionId is the 17 one, it should return 2. Which means I want to retrieve an ID of this row in the group. Else return '' */

merging every 3 column in excel using macros

I would like to merge every 3 columns and so forth in excel. It will be as follow: Column A,B,C as one column continued with  D,E,F, and G,H,I, and so forth until say KU,KV,KW. please let me know how to create the macros to select and then merge it. Thank you

merging two textfiles along with filename

Hi Team, I wantto build a package which takes input from .txt files and write in abc.txt along wiht the file name so if input is file a.txt content is lksjklsslkjfksf sfjsdkjflsd file b.txt content is lksjklsslkjfksf sfjsdkjflsd  then output abc.txt should be a.txt lksjklsslkjfksf sfjsdkjflsd b.txt lksjklsslkjfksf sfjsdkjflsd   Please give me some suggsetion on how to do it its like inserting file name then data in the same column Regars, Eshwar    

Merging gridview header after binding in winforms



Note : I am talking about Winform grid only

I want to bind a grid, structure should look like below after binding with the datatable,


    26_sept            l         27_sept          l            28_sept       l           29_sept

col1 col2 col3 col4 l   col1 col2 col3 col4  l   col1 col2 col3 col4 l  col1 col2 col3 col4

                           l                               l                              l


Here, I have datatable dt 16 columns as below but no parent header

col1 col2 col3 col4 l   col1 col2 col3 col4  l   col1 col2 col3 col4 l  col1 col2

Gridview Cell Merging


Hi All,

I have a grid, where i need to do cell merging till certain columns. It is working and the code is as follows.

Friend Shared Sub GridviewCellMerge(ByRef gridViewControl As GridView, ByVal colStart As Integer, _
                                            ByVal colLast As Integer)
            For rowIndex As Integer = gridViewControl.Rows.Count - 2 To 0 Step -1
                Dim gvRow As GridViewRow = gridViewControl.Rows(rowIndex)
                Dim gvPreviousRow As GridViewRow = gridViewControl.Rows(rowIndex + 1)
                For cellCount As Integer = colStart To colLast
                    If gvRow.Cells(cellCount).Text = gvPreviousRow.Cells(cellCount).Text Then
                        If gvPreviousRow.Cells(cellCount).RowSpan < 2 Then
                            gvRow.Cells(cellCount).RowSpan = 2
                            gvRow.Cells(cellCount).RowSpan = gvPreviousRow.Cells(cellCount).RowSpan + 1
                        End If
                        gvPreviousRow.Cells(cellCount).Visible = False
                    End If
        End Sub

1. a  b  c  d

2. a  b  c  e

3. a  b  f  e

4. a  b  f  e

5. a  b  g 

how to create crystalreport in vb.net 2008 from 3 diffrent msaccess table?


Its a Windows Application

I Want to Create a CrystalReport from 3 Table in a single .mdb file & i want to display 1st table at once & 2nd table having multiple records & 3rd table also having multiple record which is related to 1st table

eg. i have 1st table as bill, 2nd table as material & 3rd table as payment. Now all 3 table has bill_id common field so i want to display record for only bill_id which i have selected.

How to Do Its Urgent? pls help me

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