Viewing 15 posts - 1 through 15 (of 27 total)
i don't think you can write expression to hide or gray out the parameter.
July 28, 2010 at 3:28 am
July 20, 2009 at 1:02 am
Thanks for share your experience with us.
July 6, 2009 at 12:05 am
you can use multi-select parameter in report but it will return you comma seperated value and you have to change the logic to handle the comma seperated value in the...
May 27, 2009 at 11:33 pm
allow null value from the report parameter and add logic in the SP or TSQL like ......... WHERE (@DBNAME IS NULL OR DBNAME = @DBNAME)
this way if you passed the...
May 27, 2009 at 11:30 pm
Try to find out SQLInjection and check how it work. It will help you to design the database to secure it's data from these injection.
May 27, 2009 at 11:27 pm
1st option is the correct answer. there is a typo mistake in the option given for the question. I think it;s ok if you look properly the answer then you...
May 26, 2009 at 11:21 pm
check this for automation
May 21, 2009 at 11:44 pm
your question may lead confusion as you are usign third party tool to write the query. your TSQL include code inside the TSQL statement.
May 6, 2009 at 11:57 pm
check the below code i make it generic based on appointment limit it will set the flag 'Y'
select ROW_NUMBER() OVER(ORDER BY doctor,apptcreatedate) AS ROW_ID,*
DECLARE @Dr VARCHAR(10),
April 22, 2009 at 12:33 am
execute this before executing the open rowset query.
EXEC sp_configure 'show advanced options', 1;
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
April 21, 2009 at 3:55 am
How can you consider MDX as TSQL. MDX and TSQL is totally different.
April 14, 2009 at 11:24 pm
don't cry too much this is not your Board exam. Regarding the point moderator will check for the point.:-D. I can't modified the answer of this question and motive of...
April 13, 2009 at 2:12 am
check the chart padding space.
April 3, 2009 at 2:31 am
shared datasource is good option or you can define one internal parameter in the report and pass the server information to that parameter through your application.
in this way when you...
April 1, 2009 at 12:05 am