Report Parameter Date AND Time

SSRS2005.
In the Report Parameters dialog, I click Non-queried in the Default values
section, and use =Today(). I get today's date, which is exactly what I want.
But now I need to apply some formating, which generates an error:
=Format(Today(), "dd MMM yy hh:mm:ss")
How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
any errors?
Thanks,
--
RandyTry going to properties of the text box and Format tab just give
dd-mm-yyyy-hh:mm:ss in the custom.
Amarnath
"randy1200" wrote:
> SSRS2005.
> In the Report Parameters dialog, I click Non-queried in the Default values
> section, and use =Today(). I get today's date, which is exactly what I want.
> But now I need to apply some formating, which generates an error:
> =Format(Today(), "dd MMM yy hh:mm:ss")
> How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
> any errors?
> Thanks,
> --
> Randy|||The Today() property only gives you the date with time set to 00:00:00. You
should use the Now() property if you want time as well as date.
HTH,
Magendo_man
"randy1200" wrote:
> SSRS2005.
> In the Report Parameters dialog, I click Non-queried in the Default values
> section, and use =Today(). I get today's date, which is exactly what I want.
> But now I need to apply some formating, which generates an error:
> =Format(Today(), "dd MMM yy hh:mm:ss")
> How do I apply dd MMM yy hh:mm:ss formating to my Report Parameter without
> any errors?
> Thanks,
> --
> Randy|||Hello Randy,
Have you tried Amarnath's suggestion on use the "dd-MMM-yy hh:mm:ss" format
string instead to see whether it works. Based on my test, both the
followign formatting code work correctly:
=Format(Today(), "dd MMM yy hh:mm:ss")
=Format(Today(), "dd-MMM-yy hh:mm:ss")
Also, I suggest you consider the following options:
Currently you directly use the following expression for your report
parameter:
=Format(Today(), "dd MMM yy hh:mm:ss")
Then the paramter's type must be "string" , correct? Instead of directly
add the formatting operation in the parameter expression(and define the
parameter as string), you can define the report parameter as Datetime type
and use the following expression:
=Today()
this will return the DateTime object of today. And when you want to
display a formatted datetime string upon this paramter, you can use the
format function in the certain ReportItem's expression, e.g
=Parameters!Today_Param.Value
You can try this to see whethe it also works.
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Report Page Issue?

I have a report that I developed. When I click the preview tab and see the
report it show's 1 page which is correct. When I click the "Print Preview"
button it shows the 1st page and 3 blank pages after? It also prints this
way.
Why is it doing this?
DavidMake sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Ponnurangam
"Yoshi" <yoshi@.home.com> wrote in message
news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> I have a report that I developed. When I click the preview tab and see the
> report it show's 1 page which is correct. When I click the "Print Preview"
> button it shows the 1st page and 3 blank pages after? It also prints this
> way.
> Why is it doing this?
> David
>|||Ponnurangam,
I thought that was going to solve my problem but it didn't. Thanks for good
info. Do you have any other suggestions?
Thanks,
Davod
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Make sure that your report satisfies the condition specified below
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
> Ponnurangam
> "Yoshi" <yoshi@.home.com> wrote in message
> news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> I have a report that I developed. When I click the preview tab and see
>> the
>> report it show's 1 page which is correct. When I click the "Print
>> Preview"
>> button it shows the 1st page and 3 blank pages after? It also prints
>> this
>> way.
>> Why is it doing this?
>> David
>>
>|||Hi
I have also had the same problem today and have worked out that the white
background with the dots is like the canvas, is the body width and must be
smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
Hope you get my meaning.
Fiona
"Yoshi" wrote:
> Ponnurangam,
> I thought that was going to solve my problem but it didn't. Thanks for good
> info. Do you have any other suggestions?
> Thanks,
> Davod
> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> > Make sure that your report satisfies the condition specified below
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > Ponnurangam
> >
> > "Yoshi" <yoshi@.home.com> wrote in message
> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> >> I have a report that I developed. When I click the preview tab and see
> >> the
> >> report it show's 1 page which is correct. When I click the "Print
> >> Preview"
> >> button it shows the 1st page and 3 blank pages after? It also prints
> >> this
> >> way.
> >>
> >> Why is it doing this?
> >>
> >> David
> >>
> >>
> >
> >
>
>|||I finally understand what everyone is saying. Thank you so much!
David P.
"Fiona Harrison" <FionaHarrison@.discussions.microsoft.com> wrote in message
news:40621EF4-C726-4859-935F-53C239980B96@.microsoft.com...
> Hi
> I have also had the same problem today and have worked out that the white
> background with the dots is like the canvas, is the body width and must be
> smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
> Hope you get my meaning.
> Fiona
> "Yoshi" wrote:
>> Ponnurangam,
>> I thought that was going to solve my problem but it didn't. Thanks for
>> good
>> info. Do you have any other suggestions?
>> Thanks,
>> Davod
>> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
>> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
>> > Make sure that your report satisfies the condition specified below
>> >
>> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> > Body.Width
>> >
>> > Ponnurangam
>> >
>> > "Yoshi" <yoshi@.home.com> wrote in message
>> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> >> I have a report that I developed. When I click the preview tab and see
>> >> the
>> >> report it show's 1 page which is correct. When I click the "Print
>> >> Preview"
>> >> button it shows the 1st page and 3 blank pages after? It also prints
>> >> this
>> >> way.
>> >>
>> >> Why is it doing this?
>> >>
>> >> David
>> >>
>> >>
>> >
>> >
>>

Report of Reports

I have a report listing all my available reports.
On that report I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line.
Is that possible? It looks like the navigate tab can only take a static
reference to a single report.so build a standard report that queries against the SQL Database Named
'Catalog'
-Aaron
Jim Breffni wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.|||It is possible to drillthrough different reports. Your 2nd and the 3rd
sentence are contradictary. correct me if I have understood wrongly..
ie. you said
in 2nd
I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line
in 3rd
Is that possible? It looks like the navigate tab can only take a
static
reference to a single report.
Amarnath
"Jim Breffni" wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.sql

Report not showing up in IE but works in VS.net

Hey guys,
Anyone know why my main report works but when i click on a link i've created
on the main report to link to another report, the other report doesn't show
up (IE just says 'done' and nothing is displayed)?
The reports link and load correctly when i'm using the preview tab within
VS.net though.
ACK!
Thanks guys,
AlI've run into this when my drillthrough (second) report takes
parameters based on the first, but is pointing to a different database,
thereby returning no results. Try to manually load the second report
using any valid parameter values from the first and see if you can
replicate this error.
Just be sure that both reports are going against the same database.
I've run into this when using key values which are different between
DEV and QA environments.
Mike

Report Manager HELP ASAP! I get this error when running a repor

Your browser does not support scripts or has been configured not to allow
scripts. Click here to view this report without scripts.
What does this mean?Nevermind. Web browser issue. Thanks.
"OriginalStealth" wrote:
> Your browser does not support scripts or has been configured not to allow
> scripts. Click here to view this report without scripts.
> What does this mean?

Report Manager blank

I've got a report that works fine in development (and in production too until
recently) but no longer loads in production. When I click "View Report", it
just reloads the page as it is, without generating a report.
I've tried deleting and reloading it clean into production, but with the
same results.
I'd think it was something wrong with my stored procedure, except that it
has been working fine in development (and working off the same database as in
production).
Is there anything like this that anyone else has run into?I have seen this as a credential problem (reason that it is blank). Check
that the credential for the report has the proper rights for the SP.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mike R" <MikeR@.discussions.microsoft.com> wrote in message
news:D737759F-EF2D-48C3-81B8-5205DF64C4DA@.microsoft.com...
> I've got a report that works fine in development (and in production too
> until
> recently) but no longer loads in production. When I click "View Report",
> it
> just reloads the page as it is, without generating a report.
> I've tried deleting and reloading it clean into production, but with the
> same results.
> I'd think it was something wrong with my stored procedure, except that it
> has been working fine in development (and working off the same database as
> in
> production).
> Is there anything like this that anyone else has run into?

Report manager

Hello,

How can I make my sub-reports invisible in the report manager, I do not want users click them and try to run.

Thanks,

There are some basic security features. It is possible to limit access to certain roles. There's plenty of info here: Thttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_3hia.asp

Report Links in Page Header

I have a report that I put links to other reports in the page header.

When I click on those links, I get the error:

"source of the report definition has not been specified"

If I move the links to the body of the report, they work fine.

Is this a bug or a limitation, and will we eventually be able to put links in the header?

Thanks!

BobP

Drillthrough links in page header/footer are not supported in RS2005. We plan to get it fixed in the next release.

report header and footer missing.

hiye, i'm doing a drill down report (group type) everytime the reoprt loads
the headr and footer is missing untill i click on the plus (+) sign and then
only the headr and footer will be display. any idea?
thanks in advance.Toggle by property of the controls is set in a way that
you can see either the report main area or the header.
Just right click on the control and under properties just
reset the toggle property.
>--Original Message--
>hiye, i'm doing a drill down report (group type)
everytime the reoprt loads
>the headr and footer is missing untill i click on the
plus (+) sign and then
>only the headr and footer will be display. any idea?
>thanks in advance.
>.
>