2
Answers

Create Report in which columns are not predefined.

Hi friends i want to Create a report which columns will dynamic from stored procedure.I mean i can't predefined no of columns in my report.If my Stored Procedure's query contains 5 columns then 5 column should be display in report,if query contain 10 columns then report should display 10 columns.So my question is which report i should use.I should use RDLC,RDL,Crystal or any other ?? Please reply.thanks in advance.I am using VS 2010,Sql Server 2008 R2.
Answers (2)
0
ketan borsdiya

ketan borsdiya

NA 1.5k 3k 8y
Hi Gagan,
Write Below Query,
SELECT *
FROM <Your Table Name>
WHERE Name LIKE '14th-Copy%' and LEN(Name)<13;
Now accept my answer and enjoy :)
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 8y
Try like below:
SELECT Id
FROM test
WHERE (len(Name) - len(replace(Name,'Copy',''))) = 4
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
HI Ketan,
this query not working correctly. It returns all records who have copy keyword
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
Plz Reply ASAP
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
<h4><a data-userid="manas1" href="http://www.c-sharpcorner.com/members/manas-mohapatra">Hi Manas Mohapatra</a></h4><div>I have already decsribed my recuirement in my question .please see it</div>
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
These query are wrong because it returns all records who have copy string.this is not my recuirment .
I need only records which have only one copy string
Requried Output:
1.14th-copy(2)
2.14th-Copy
-1
ali tuncer

ali tuncer

NA 2.9k 108 8y

use SQL LIKE operator

Check this link :

http://www.w3schools.com/sql/sql_like.asp

-1
Rajeev Punhani

Rajeev Punhani

NA 4.7k 402.5k 8y

Hi Gagan,

Please try the following query.

  1. SELECT*
  2. FROMtest
  3. WHERENameLIKE'%copy%';