Ssrs Report Question

[tame]

Please help ...Issue details ...

 

1. Source table has no data for a particular Date.

2. But on SSRS report date should be displayed ( on Bar Chart Category axis ) and nothing should be displayed.

3. How can we achieve this ?

[pandugadu999]

nee dataset query lo ne all dates vafchetattu chey.....use outer join..aa date column unna table ki outer join chey,,,so a date vastundi

[tame]

1. Source Table for this Report is One Single table ...so  JOIN ruled out kadaa

2. Source table has no entry for "Date in Question" so how can I get the data for this date in question ???

[pandugadu999]

1. Source Table for this Report is One Single table ...so  JOIN ruled out kadaa

2. Source table has no entry for "Date in Question" so how can I get the data for this date in question ???

 

date dimension  table untundi kada....daniki join chey...

[tame]

date dimension  table untundi kada....daniki join chey...

 

Thank you ...but problem entante ..data base worst gaa design chesaaru ...  ...Dimension table asalu ledu :-(

[pandugadu999]

Thank you ...but problem entante ..data base worst gaa design chesaaru ...  ...Dimension table asalu ledu :-(

 

date dim table lekunda how man,,,

[tame]

date dim table lekunda how man,,,

 

 
ade kadaa  client gaadu alaa chesaadu database design worst gaa...

[loveindia]

create a date range inside the cte and use a cross apply man.. thats it...

[loveindia]

Thank you ...but problem entante ..data base worst gaa design chesaaru ...  ...Dimension table asalu ledu :-(

 

very common scenario man.. no need to worry... how many days you are looking at a strech??

[tame]

create a date range inside the cte and use a cross apply man.. thats it...

 

thank you .....I tried that ....dataset lo correct gaane vachindi ...report lo edo issue undi display avvatledu ....

 

[tame]

very common scenario man.. no need to worry... how many days you are looking at a strech??

 

8 days ....
 

[loveindia]

8 days ....
 

 

deeniki kuda inta alochistunnava man... chimple ey kada...

[pandugadu999]

post report screenshot here....and dataset result

[loveindia]

;WITH CTE AS
(
 SELECT CAST(DATEADD(D, -8, GETDATE()) AS DATE) AS [Date]
 UNION ALL
 SELECT DATEADD(D, 1, [Date]) FROM CTE WHERE DATEADD(D, 1, [Date]) <= Getdate()
 )
 SELECT * FROM CTE

Use this man...

[loveindia]

post report screenshot here....and dataset result

 

why do you need that man???