Report Parameter error

Hi ,

This is vishal vidhale. when i pass parameter in reporting services that time it gives me an error "Foward dependancies are not allowed".

How can i overcome this error. Any one who know or having knowledge of SQL reporting services can help me..

Thanks......................

Hi Vishal. May be your parameter(child) is depending on another parameter(Parent) in the Report and that parameter(parent) is declared later this parameter(child).

so, if this is the situation, in the parameters form(Report->Parameters) move your paramter(child) to below the parent parameter and check it out.

Thanks,

Srinivasa Reddy.

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 pages - reduce render time

Is there a way to minimize the number of pages obtained from a report. My report has more than 9000 pages. I want to minimize the number of pages as it would fasten the rendering of the report in excel,pdf formats. how would one do this? is there any expression?. your help is very much appreciated. I am tearing my hair to minimize the time taken to render a report.! help pls!

Thanks,

You say the report is 9000 pages, so what did you have in mind when you say "minimize the number of pages" -- it seems like you already know how big the report is.

If you only need to see some of the 9000 pages at a time, or only certain people need to see certain pages, you should filter the data (preferably at the data source) with parameters and/or UserId.

Report of Job Activities

I need a report of all job monitoring activities. How can you run a report
out of SQL 2005 which list the reports by day, date and time
--
WPJLYou may want to be more specific on exactly what you'd like to accomplish.
Perhaps, an example would help.
Linchi
"WPJL" wrote:
> I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||WPJL
As Linchi said , to help you we need an exmaple
http://dimantdatabasesolutions.blogspot.com/2008/03/sql-server-agent-jobs-duration-report.html
"WPJL" <WPJL@.discussions.microsoft.com> wrote in message
news:CFA4269C-267E-4CE4-A53A-085FC22621B6@.microsoft.com...
>I need a report of all job monitoring activities. How can you run a report
> out of SQL 2005 which list the reports by day, date and time
> --
> WPJL|||I asked to create an analysis report of all jobs which run via SQL Service
Job Activity. The data that is needed is the day, date and time intervals
which each job runs. The requestors want a side by side analysis to view
specific jobs that run on the same day and time. We currently have
approximately 72 jobs which run via SQL server. To get the information into
a spread sheet, I had to open the job history and properties and manually
enter this information in an excel spreadsheet. This is very time consuming.
Examples of jobs â' Job A run everyday M-F at 6:00 a.m., Job B run M-F at
6:00 a.m., Job C may run everyday starting 12:00 a.m, until 12:00 midnight.
However, the job runs M_F, at time intervals of every 10 minutes. It starts
at 12:00, 12:10, 12:20 and so on.
I wanted to know if there was a way to query the Job Activity data out of
SQL query where I could create an analysis report which would show a
comparison of the days, dates and interval times that each report runs.
Thanks.
--
WPJL
"Linchi Shea" wrote:
> You may want to be more specific on exactly what you'd like to accomplish.
> Perhaps, an example would help.
> Linchi
> "WPJL" wrote:
> > I need a report of all job monitoring activities. How can you run a report
> > out of SQL 2005 which list the reports by day, date and time
> > --
> > WPJL

Report moving between fields

I'm having a strange issue.
When moving between parameter fields when viewing a report, it refreshes the
report every time I move from field to field. Whether I'm moving with the
tab button or just clicking in the next field.
The refresh option is off.
Anyone have any ideas?Here's an update...
This only occurs when using a default field. I'm using the global constant
"user id". It is the last parameter in the stored procedure and the last
parameter entry field in my report.
If I move this field to the first parameter entry field, it works just fine.
When it's in any other position, it tries to run the report each time I move
to a new field.
This is extremely frustrating.
"Scott M" wrote:
> I'm having a strange issue.
> When moving between parameter fields when viewing a report, it refreshes the
> report every time I move from field to field. Whether I'm moving with the
> tab button or just clicking in the next field.
> The refresh option is off.
> Anyone have any ideas?sql

Report Model Deployment Problem (DataSource)

I created a new Report Model project and specified folders for both the model and the datasources. For some reason, every time I deploy the model I get an error stating the datasource cannot be found. I've tried changing the project properties to no end. Here's the specific output

Deploying to http://localhost/ReportServer?%2f

Deploying data source '/Data Sources/CRM Database Conection'.

Deploying model 'CRM Filtered View Model'.

The item '/Data Sources/CRM Database Connection' cannot be found.

This seems to happen a lot when creating logical joins from tables from different datasources.

Report Model Deployment Problem (DataSource)

I created a new Report Model project and specified folders for both the model and the datasources. For some reason, every time I deploy the model I get an error stating the datasource cannot be found. I've tried changing the project properties to no end. Here's the specific output

Deploying to http://localhost/ReportServer?%2f

Deploying data source '/Data Sources/CRM Database Conection'.

Deploying model 'CRM Filtered View Model'.

The item '/Data Sources/CRM Database Connection' cannot be found.This seems to happen a lot when creating logical joins from tables from different datasources.

Report Manager Error

When I try to open the report manager (SQL Server 2005), I get an error that
says "Response is not well-formed XML - Error". This is the first time that
I have see this error, has anyone else seen it? Any idea about how to fix
it? I tried deleting the Report and Report Server directories in IIS and
recreating them using the Reporting Services Configuration tool, but this did
not make the error go away. I see the same error in the Business
Intelligence Developement Studio when I try to deploy reports. Any ideas
would be helpful. Thank you.
--
LaurieTOn Oct 10, 8:41 am, LaurieT <Laur...@.discussions.microsoft.com> wrote:
> When I try to open the report manager (SQL Server 2005), I get an error that
> says "Response is not well-formed XML - Error". This is the first time that
> I have see this error, has anyone else seen it? Any idea about how to fix
> it? I tried deleting the Report and Report Server directories in IIS and
> recreating them using the Reporting Services Configuration tool, but this did
> not make the error go away. I see the same error in the Business
> Intelligence Developement Studio when I try to deploy reports. Any ideas
> would be helpful. Thank you.
> --
> LaurieT
Do you have SP2 installed? If not, you will want to start there. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:41 am, LaurieT <Laur...@.discussions.microsoft.com> wrote:
> When I try to open the report manager (SQL Server 2005), I get an error that
> says "Response is not well-formed XML - Error". This is the first time that
> I have see this error, has anyone else seen it? Any idea about how to fix
> it? I tried deleting the Report and Report Server directories in IIS and
> recreating them using the Reporting Services Configuration tool, but this did
> not make the error go away. I see the same error in the Business
> Intelligence Developement Studio when I try to deploy reports. Any ideas
> would be helpful. Thank you.
> --
> LaurieT
It seems like my previous response was not posted.
If you haven't already, you will want to install SP2 for SQL Server
2005. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report is rssuccess but browser continues until time out (no document returned)

Hi,
Basically, we're having a problem on our production servers, that is
that a report is running for 2h (this is expected, large data set) and
IE6 is setup up for a 4h timeout (via a registry entry). The browser
will display the spinning report generation icon for the entire 4h
before timing out. However, the server log is reporting that the report
had succeeded (rssuccess), 1.5 hours BEFORE the browser fails.
Servers/Services are Win2003, Reporting Services SP2, SQL Server 2000
SP3
The machines sit behind a load balancer, which might be important (HTTP
requests etc.).
We're stumped :-(
Any ideas?
Thanks
RolandoWhat happens after the browser fails? What indication points out that
the browser fails?
It gives you a "This application needs to be closed" error?
Is there a different error? It just freezes?|||Sorcerdon,
When the browsers times out at its designated timeout value (4 hours),
we get the standard IE6 "Page cannot be displayed" page.
Do you have some idea of what might be going on?
Thanks|||Try running it and turn off "Show friendly HTTP messeges" in the
browser options.
Go to Options --> ADvanced tab --> Its under Browsing.
This will provide you with a more detailed error messege.
BTW, where is this error show up? in the actual report window? or it
redirects to the error page?
regards,
Stas K.

Report interface getting refreshed

All of a sadden my report refreshes its interface every time I choose
something from dropdowns. Any reason for that?
ThanksYou must have cascading parameters (one parameter dependent on another).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
> All of a sadden my report refreshes its interface every time I choose
> something from dropdowns. Any reason for that?
> Thanks
>|||And if I do then that's how it works?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
> You must have cascading parameters (one parameter dependent on another).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>|||It's refreshing the page to update the dependent parameter. I only see this
behavior when I have dependent parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e8n$TZEkIHA.2268@.TK2MSFTNGP02.phx.gbl...
> And if I do then that's how it works?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
>> You must have cascading parameters (one parameter dependent on another).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>>
>

Report Headers showing on blank page

I hope someone will have time to answer a really basic RS question.

I have a simple report, the query will only return a few rows (16 - 20), my header is repeating on a 2nd blank page. I'm sure it's because I grouped on a column from the record set. I can not find where you delete the grouping.

Anyone have any good suggestions on RS books?

Thanks

Hey Marc,

There are a couple of places to check:

When you click on the table, are there rows that have little numbers on them (1,2, etc)? If so, you should be able to right-click on these and select Delete Groups.

Another place could be the Properties of the table (Select the table, right click on the Properties option). Select the Grouping tab. Delete any of the groups in there (usually named something like "details_group")

Good luck!

Jessica

Report get time out.

Hi all,
I am facing a problem of report time out for some of the my reports.The
report seems to be taking too long and then times out.But when the new
browser is opened immediately after the report comes in minutes. And the if
I close the browser before it's get timed out and open the new browser for
the same report it again comes out quickly. Can anybody tell me why it is
so.
SandeepSounds like your report query is taking a long time, and is timing out
on the database side. Running the report a second time may be taking
advantage of the fact that your data was loaded into memory the first
time your database query ran. This would make it run much faster the
second time, but wouldn't actually have anything to do with Reporting
Services.
Might I suggest you try manually running your query with sample
parameters? If you see the same behavior in Query Analyzer, then
double-check what your query is doing because it isn't Reporting
Services. (If the query is always very fast in Query Analyzer, then
you've got a much more interesting problem!)
Ted

Report generation time between users and admin

Hi,

When we generate a report with an account that is in the admin group it takes 2-3 seconds but when we do it with another user it takes over 2 minutes... any reason for this?

(The "Report is being generated" thing, by the way)

Not sure if my question is clear, I've been looking and searching for the past 2 hours but can't find anything remotly close to that problem... any help would be appreaciated!

Thanks

Wacky guess:

Are temp files for the two accounts going to different places, for example there is a "home" drive for normal users that is not local?

>L<