Setting Multiple Datasource For A Report?
Mar 24, 2010
I have a report whose data is derived from two stored procedures.so i need to set these two datasources for generating the report.But the reports which have only one SP, ie.only one datasource works properly. For setting the datasource, i wrote code like this:
dim reportdocument as ReportDocument
Dim reportPath As String = Server.MapPath("CrystalRptsReport.rpt")
ReportDocument.Load(reportPath)
'Function for Setting the Connection
[Code]....
But, the report is not generating.it shows the following error
The Report requires additional information
Servername:- Server
Database:- Database
UserID:-
Password:-
But the reports which have only one SP, ie.only one datasource works properly.What colud be reason for this error?
I have already created this report.So i cant combine the two SPs as it may refresh the report fields.
View 1 Replies
Similar Messages:
Feb 24, 2014
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report
using CrystalDecisions.ReportSource;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
View 1 Replies
Nov 16, 2010
using crystal report in VS 2005 C#. I want to print multiple copies(3) of a same report in a single page. Is is possible.
View 1 Replies
Feb 19, 2011
I want to use a single Crystal report (.rpt) file for two actual reports, changing only the title and the data. I've got the data working, but I can't seem to get the title part right. I tried to follow this
tutorial, but when I do my report just disappears (whether I set the parameter or not). I created a "Report Title" special field and dragged it to my page header. Then I brought up the formula editor on the report title display string and clicked on my title parameter. So the formula ends up being
{?Title}
I'm sure I'm probably just making a rookie mistake here.
View 5 Replies
Dec 22, 2010
I have created a web application will will eventually be the holding place for several reports. Rather than creating a new webform for each report, I want to use the same report viewer for all of the reports. I have created an AccountSummary dataset (AccountSummaryDS.xsd) that has two tables, one for the header information and one for the details. I have two webforms in the app, a Default.aspx that captures the necessary employee information for the query and the ReportForm.aspx that has the reportviewer control.
I came up with the code below for a Windows form application but am having issues translating it to be used in a webform.
[Code]....
View 1 Replies
Jan 3, 2010
is it possible to add more then one file name in app settings.??if so,how to work around with second file.?..i currently have one file listed in app setting,
<appSettings
file="list.config"
>//i need to add another file here with values??????
<add key="key1" value="a"></add>
<add key="key2" value="b"></add>
<add key="key3" value="c"></add>
</appSettings>
View 4 Replies
Apr 23, 2010
I am binding a report in VS 2008 and crystal reports 10
How can i know the number of pages that a report is producing for a single id.....?
View 1 Replies
Sep 8, 2010
I have multiple reports that take the same parameters. Need to create a master report with all the reports merged together. I dont want to copy paste the rdlc files into one large file. found a control by Telerik called ReportBook but it costs money!! [URL] anyone knows something similar? or am i missing something very obvious? using visual studio 2005... will subreports solve my problem? not sure how these work. so say i have a report that lists employers and i create a subreport that lists all employees for a particular empoyer. is it then possible on one rdlc to have the list of employers and a bunch of subreports for each employer's employees?
View 2 Replies
Jan 20, 2011
I want to print report based on GridView checkbox. If 3 rows has been choosed, should be 3 reports. My code is like this...
protected void btn_Print_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
try
{
foreach (GridViewRow gvr in grdRV.Rows)
{
RadioButton rbID = (RadioButton)gvr.FindControl("rbID") as RadioButton;
if (rbID != null && rbID.Checked)
{
string sID = grdRV.DataKeys[gvr.RowIndex].Value.ToString().Trim();
if (rbl_Print.SelectedValue == "0")
{
SMTP(sID);
}
else if (rbl_Print.SelectedValue == "1")
{
Material(sID);
}
}
}
}
catch (Exception ex)
{
Session["error"] = ex.Message;
Response.Redirect("MessageBoard.aspx");
}
}
}
private void Material(string sID)
{
string querystring = "../pmis/Reports/RptRFQMatV.aspx?RFQNo=" + lblRFQNo.Text.ToString() + "&ID=" + sID;
Random r = new Random();
string Script = "";
Script += "<script language=JavaScript id='PopupWindow'>";
Script += "confirmWin = window.open(' " + querystring + "','" + r.Next() + "','scrollbars=yes,resizable=1, width=960,height=500,left=50,top=130,status');";
Script += "confirmWin.Setfocus()</script>";
//ClientScript.RegisterStartupScript(typeof(string), "PopupScript", "PopupWindow");
if (!ClientScript.IsClientScriptBlockRegistered("PopupWindow"))
ClientScript.RegisterClientScriptBlock(typeof(string), "PopupWindow", Script);
}
Currently this code can print report the last row only
View 1 Replies
Feb 28, 2011
I'm working on Visual Studio 2008 and SQL Server 2008, language C#
Multiple parameter passing in crystal report in asp.net. I have two parameter @accountnumber and @customerid at time. I can only pass one parameter to my.
[Code]....
View 2 Replies
Oct 5, 2010
Can we use different resultset in our Report. Like if we have written two select statement in our SP, how can we use the different result set to bind them in our Report.
View 3 Replies
Mar 7, 2011
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
View 2 Replies
Jun 4, 2010
Would it be better to have a sp return multiple result sets and use NextResult() or have subsequent call to dr.execute.... () and hadle one result at a time?
To me using nextResult() on a multiresult datareader would be cleaner and easier - but it does not seem to be very "atomized". I guess I am wondering can the cost of executing multiple commands be neglected? Seems like executing multiple commands and receiving a single result set would also be easier to read/test/understand.
View 1 Replies
Sep 6, 2010
i want to delete multiple report in grid view and i am facing some problems, i am using this Code.
protected void LinkButton1_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("chkSelect");
if (cb.Checked)
{
int rid = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
SqlDataSource1.DeleteParameters["id"].DefaultValue = rid.ToString();
SqlDataSource1.Delete();
}
}
}
View 5 Replies
Nov 25, 2010
I have a report displaying the data for an employee. If I wish to generate report for 2 employee, how I can do to make a single report contains both the data? (e.g.: 1st page display data for 1st employee; 2nd page display data for 2nd employee and so on) I need them to be in the same report/pdf file.
View 3 Replies
May 18, 2010
I have a requirement to open a report in excel sheet that would have 7 sheet in it and each sheet keeps data for each 7 days.
[URL]
View 2 Replies
May 17, 2012
[URL] .... I done as per in the given link ....
But I get error unrecognized identifier at GetBreakupstring (
I want to watch field in a single cell in newline in MS reporting service table cell....
View 1 Replies
Aug 22, 2010
I have a calendar that can have multiple dates non sequentially selected. I have a gridview on the page with a sqldatasource control bound to it.
Again, I have already built the events calendar with the ability to select multiple dates... now I just want to show those detailed records below the calendar for only the dates selected.
How do I filter the records to only get the records of the SelectedDates of the Calendar control.
This has to be done dynamically in the code behind.
View 1 Replies
Feb 24, 2011
I want to generate crystal report in pdf format. I had done the same thing by passing one parameter. But this time I want to pass 10 parameter. I followed the same thing what I did for passing one parameter.
But now I got the Error Message "Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack."
[Code].....
View 1 Replies
Jan 25, 2010
I need to display a header and details. What's the recommended way to do this? 2 separate datasets/tables, or 1 dataset with 2 datatables in it? I can't get the second set of data to display.
View 6 Replies
Feb 24, 2011
I'm creating a reports with the following filter criteria:
ID - textbox Created Date - range between start and end date Syste Name - dropdown Users may filter the report based on the ID or System Name or all the criteria mentioned.
The search Field for ID, by default has a Null checkbox beside on it while other filter doesn't. how can I enable the checkbox for the other filters?
So I came across this article which should my issue. Apparently, I'm receiving a formula error "The arguments to the following functions are not valid:FIND" with this formula OR(FIND(Creation Date, Parameter: Creation Date)<>0, Parameter : Creation Date = Empty). see this link for the screenshot. I don't know what I'm missing. I'm using Reporting Services 2005
View 2 Replies
Oct 17, 2012
I know to populate Excel file using htmltextwriter from dataset.
I want to know how to populate Excel multiple sheets using htmltextwriter from dataset based on condition
View 1 Replies
Mar 17, 2010
I have a ListView that, among other things, in the EditItemTemplate, has a pair of related DropDownList controls, sort of a parent/child relationship. The selected value of the parent is used as a parameter for the SQL Datasource of the child. Outside of a control such as the ListView, this would be easy and I'd simply set up a ControlParameter for the SQL Datasource and life would be good. Within the DataList things are not quite so simple. My plan is to set the parameter of the child in the Selecting handler of its datasource. I have hard coded some values and this works the way I want it to. My problem is getting the "parent" value. I've got two theories on how to get this:
#1, I've tried instantiating the parent DropDownList but it is either not available at this point in the page life cycle or I just don't know the syntax to get at it from within the Selecting handler.
#2, I'm thinking I may have to grab the value from the underlying data for the ListViewRow that I am editing, but again, I do not know the object model well enough to get at those values.
Below is a code sample for option #1. As stated, setting the parameter works, but getting the value of the DropDownList does not.
View 5 Replies
Aug 25, 2010
I know it is recommended to use a using statement with a sqldatareader, but I was wondering if it is necessary when you are setting the datasource of a control to a datasource directly. in some places in my code I do this.
using (SqlDataReader reader = getReader())
{
while (reader.Read())
{
// do stuff with data
}
}
when binding to a control I do this.
ddlCustomer.DataSource = getReader(); // get Reader returns a sqldataReader
ddlCustomer.DataBind();
In the second case, do I need to use a using statement. Do i have to first declare an SqlDataReader in a using statement, then set the DataSource to that object. Seems like more clutter in the code, so i was hoping binding to the SqlDataReader disploses of the SqlDataReader.
View 3 Replies
Aug 2, 2010
I have a vb.net web site. Currently it is generating reports via ReportViewer. The datasouce for the all reports is set at the deploying of the report.
ReportViewer is configured in the aspx page
<rsweb:ReportViewer ID="myReportViewer" runat="server" ShowParameterPrompts="true"
ZoomMode="Percent" Height="1100px" Width="1000px" BorderWidth="1">
</rsweb:ReportViewer>
I am setting up the ReportViewer using the following code.
Dim _cred As New ReportServerCredentials(Session("_ApplUser"), Session("_ApplPswd"), Session("_ApplDom"))
'Set the processing mode for the ReportViewer to Remote
myReportViewer.ZoomPercent = 100
myReportViewer.Width = Unit.Percentage(100)
myReportViewer.Height = Unit.Percentage(100)
myReportViewer.ProcessingMode = ProcessingMode.Remote
Dim _SrvRpt As ServerReport
_SrvRpt = myReportViewer.ServerReport
_SrvRpt.ReportServerCredentials = _cred
'Set the report server URL and report path
_SrvRpt.ReportServerUrl = New Uri(Session("_RSConn"))
_SrvRpt.ReportPath = Session("_RSFold") + _rr.Report_Path
myReportViewer.ServerReport.Refresh()
lblTitle.Text = _rr.Report_Title
myReportViewer.ServerReport.Refresh()
myReportViewer.Visible = True
What I want to do is dynamically set the datasource for a report at runtime. That is, I have 2 datasources already configured in my Report Manager. I want to have the vb.net pick which datasource based on a enviornment variable. So, if Env 1, then use Datasource 1 in the Report Manager. Of Env 2 then use Datasource 2 in the Report Manager. I have seen what looks like software for doing this Locally but no for Remote.
View 5 Replies