Skip to Content
avatar image
Former Member

Database Vendor Code: 13172752

Hi Experts ,

I have included 3 sub reports in my main report but for each report it doesn't have a link .i trying to pass separate queries for each to get the result which i need but i tryied my maximum but i couldn't come up with any solution please help me on this issue .....

method

public void subAddQuery(string Query)
{
singleList = new List<KeyValuePair<string, string>>();
string SqlBeforProces = Query;
Query = procesSubreportSQL(Query, subreportfileName);
try
{
Tables myTables = crystalReport.Subreports[subreportfileName].Database.Tables;
string tablename;
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in myTables)
{
tablename = myTable.Name;
ci = myTable.LogOnInfo.ConnectionInfo;


crystalReport.Subreports[subreportfileName].SetSQLCommandTable(ci, tablename, Query);

break;
}

}
catch (Exception ex)
{
singleList.Add(new KeyValuePair<string, string>("", ex.Message));
lists.Add(new KeyValuePair<string, List<KeyValuePair<string, string>>>("ERROR : ", singleList));
AddtoLogFile("REPORT UNABLE CONTINUE PROCESS", lists);
conn.Close();
}
}

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers