1. Take the data and Image in two different rectanngles
2. Put "Page Break before" in second Rectangle properties
When you export it to excel, it'll...
Thanks Adriaan<br /><br />Just wondering if this can be achieved in single query? On the face of it, looks like a simple problem...just thinking that...
I Want to select TOP 2 records for each of the INDICATOR
CREATE TABLE ABC
Hey, I dont want to insert '<='
See character value for ASCII 243 athttp://www.asciitable.com; look under "Extended ASCII Codes"
Well, it works following way
create table test1234
insert into test1234
values ('Â¡Ã Â¡Ãœ')-- If u cant see, replace junk with...
Well, i think theres some scripting done on this page, I want to insert <= and >= like we see together...like ALT+242 or ALT+243
I want to insert >= & <= into database.
Please see attached query.
create table test123
insert into test123
values ('Â¡Ã Â¡Ãœ')...
How can I convert numeics to words
e.g. 837 to Eight Hundred and Thirty Seven
When you install SQL Reports, Install Samples also.
Theres an Example where you can find a .NET project ReportViewer.
Compile this project and you'll...
If the picture is small (say 10Kb or so), its better you store it to database as Image with an ImageID. Write an SP to retrieve the required Images....
Why don't you create a Textbox(saying "No data Exists") on your Subreport; visibility of which is toggled by count of data on your subreport (you can...
Why don't you split the memo in two parts in SQL query (Part to be shown on first page and to be shown on next page) and show it in two Text boxes?...
I've observed that if you keep the date as 29-Nov-2004 its generally kept in the same format.
Thanks a lot guys..<Alt-0177> is working.
Frank, I've multiple front ends (Many ASP.NET pages, some 100 SQL Reports etc) so I want to handle it at...
I want to print + "Plus-Minus" as a text in SQL. e.g. I want to store +2% rather than +-2%.
How can I store this?
We are actually looking at creating a separate Reporting database (only for querying etc) but we need a part of database only (as i...
I have a database with 60 tables. I want to create another database(separate server) with only 15 of these tables for reporting. I do not want to...
Thanks a lot Frank
I've a table with following data
I want to fetch result as 'Red, Blue, White, Yellow' in a single SQL Query.
Separate names with a comma.