Yep...

Thats true.

🙂

Why are you creating different dataset.

You can create one dataset by combining all the results using UNION ALL

e.g.

select count(e.id) as count, month(e.type1_date) as type_month

from example as e

where year(e.type1_date) = 2008...

Hi,

If you are using SSRS then you can do following things to achieve your goal:

1. Create your dataset.

-- I am taking following example according to your dummy data:-

Declare @T table...

Yep, GSquared is true.

HI,

try this query:

select * from source

order by Cast(Left(timecol,2) as int)

Syntax for WRITETEXT :

WRITETEXT { table.column text_ptr }

[ WITH LOG ] { data }

But You can add ntext, text, or image values to a row in the following ways:

1. Specify relatively short amounts of data in an INSERT statement in the same way...

Hi,

I think microsoft will remove ntext, text, and image data types in a future version of Microsoft SQL Server. So avoid using these data types in new development work, and...

Dear Swekik,

Try this:

CREATE TABLE TableName (Field VARCHAR(12) CHECK (Field LIKE '[a-z][a-z][a-z][a-z][0-9][0-9][0-9][0-9][a-z][a-z][a-z][a-z]'))

cheers 😛

Hi,

Are you looking for this result:

SELECT Team.team,

SUM(AFLPlayerStats.kicks)/Count(distinct AFLPlayerStats.aflGame_id) AS Kicks,

SUM(AFLPlayerStats.marks)/Count(distinct AFLPlayerStats.aflGame_id) AS Marks,

SUM(AFLPlayerStats.handballs)/Count(distinct AFLPlayerStats.aflGame_id) AS Handballs

FROM AFLPlayerStats INNER JOIN Team ON AFLPlayerStats.team_id...

Hi,

"Parameter is missing a value." message displayed only when your parameter is not having any value in deployed report.

If you will set it NULL by default, it'll create problem because...

Hi,

You can follow these steps:

1. Open Chart Properties window.

2. Select Data Tab

3. Click on value field and then Edit Button

4. in Edit Chart Values dialogue box, Click on Point Labels

5....

Hi

Write following expression in Non-queired option of Default values:

=CDate(Format(now(),"M/d/yyyy"))

It'll work fine..

Do you need something different?

Dear DBASkippack,

try to do one thing...

Create a dataset which has single row and four columns say A,B,C,D

Now, Drag and Drop a Matrix Control in your report.

Now Drag and drop all...

Hi,

Then you need to alter your Stored Procedure.

probably you can handle the NULL value in your stored procedure like:

ISNULL(FieldName,'') AS FieldName

or

ISNULL(FieldName,0) AS FieldName