i m not changing sqlquery in mrt files?

[fatih1453]

Code: Select all

            sqlAdap.SelectCommand.CommandText = "sqlquery"
            sqlAdap.Fill(dt);            
            sti.Load(HttpContext.Current.Server.MapPath("Mrt\\Firma2_2.mrt"));
            sti.RegData(dt);

i have changed the select query but columns are same with the mrt files
for example in mrt file "SELECT * FROM TABLE"
and i have changed the query that: "SELECT * FROM TABLE WHERE DATE BETWEEN 2005 AND 2008" above sqlAdap.SelectCommand.CommandText = "sqlquery"

report doesnt shows sti.RegData(dt). report shows the select query in mrt file
can't i change the query in mrt file
i dont know english very well
i hope you understand me

[Vital]

Hello,

Report designer does not change columns in sql datasource automatically when you change sql query. You need reget columns from sql server.

Thank you.

[fatih1453]

thanks vital
but you did not understand me
columns are same not different
i only put where clause

Code: Select all

WHERE DATE BETWEEN 2007 AND 2008

columns are same
in mrt file select quey did not have the where clause
and select query(which have where clause) that i sent did not work . select query(which havent where clause)in mrt file worked?
the problem ist that

[Edward]

Hi Fatih,

Please let us know type of the DATE column in your report.

Did your select query work in the SQL Editor window outside our designer?

Which designer you tested, Win or Web version?

Thank you.

[hadisaadat_du]

Hi every body.
I sea allmost all topic in forum and seem int all of them posit that we know what is our tables and columns in dataset of our reportbut allways not thus
1-sometime we may want to edit the report in webdesigner that we dont know any thing about its data set but we sure it works with our data base , so befor call the design() function we pass what data set to our report via regdata(//what_dataset) ??
2- or we may want to set full access to data base to one user to create the every report that need to design well we pass a full data base to designer dictionary and he/she design every report by every columns in every tables or viwes in database and save it , in viwe report mode namely after load our report and we want to pass it to stiwebviewer we pass what data set to it since we cant pass all data base to our report ??!