Date Parameters - International

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Date Parameters - International

Author

Topic

jewel
Starting Member

18 Posts

Posted - 2007-01-04 : 20:03:43

hi all

We are a multi site / multi language company so do not want to hardcode the date format - these reports will be on intranet

Using MS Sql - Reporting Services 2005

RecvdDate field = yyyy-mm-dd - is how it is displayed.

I added a @startdate and an @enddate parameter and am using the
calendar - so a user picks off the calendar

I read up and saw this information:

Report properties set

'Language' setting to '=User!Language' to detect user
culture automatically

My regional settings are set to English (New Zealand)

but whatever I do I receive no data - (data is definately there eg when run without parameters) so it is obviously the parameter that is incorrect.

Can someone give me some advice on what else to check.

thanks

jhermiz

3564 Posts

Posted - 2007-01-05 : 09:11:56

2 things you need to do. If you just added the parameters at a later time, reporting services forgets to include them in the .rdl code. What you have to do is right click the actual report and click "View Code". Go to the section that lists your main datasource, that is the data source that the table / cube / matrix uses. Look at how it calls the stored procedure and make certain the two parameters you added to the report are there in the rdl code in the <parameters> section.

Second thing you need to do is to make sure you post your code so we can see it, I am referring to your SPROC code that is used in your report.

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

jewel
Starting Member

18 Posts

Posted - 2007-01-07 : 16:51:49

hi there jhermiz

I am using the BI Interface and adding the parameters like this"

on Data Tab

SELECT CallID, CompanyName, Application, RecvdDate, ClosedBy, ClosedDate, CallStatus
FROM CallLog
WHERE ('WHERE RecvdDate' BETWEEN @StartDate AND @EndDate) AND (CallStatus = 'closed')
ORDER BY CallID DESC

so my code on right clicking my report - portion of date parameters reads like this:

<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<Prompt>StartDate</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<Prompt>EndDate</Prompt>
</ReportParameter>
</ReportParameters>

so I need to verify what my parameter settings on the report should be:

my Data type = DateTime
what should my available values be:
what should my default values be:

thanks

jewel

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources