Bind SQL reporting services (Reports) to ASP.NET (Urgent)

Hi all,

Currently I have a project that require me to use reporting services (Reports) together with ASP.net web application.

However, I have the following problem.

I have an asp.net web application. From there, I have a textbox whereby user can type a specific date. The specific date should then be incorporate with the sql reporting services. The report that is being generated will contain data that is on the specific date.

How can I do that?

I try to search through the internet but to no result. Can anyone help out?

Thank you so much.Read a book on Reporting Services ... you can pass everything to Reporting Services through the webservices it exposes ...
Microsoft has some good books about Reporting Services ... Search for William Vaugh ... He's very good

Bind DataSource at runtime and Adding fields [A little help please]

hi,

I am using Crystal Reports 8.5 and Visual Biasic 6.0, the technique that I
was using was I connect the database using the ODBC to the crytal reports and design my report by draging the fields to the reports.

In my new assignment I have to bind a ADODB recordset to the report at
run time.

I got 2 Problems.

01. How can I bind a ADODB recordset to the report at run time
02. After binding the recordset how can I add the fileds to the report
content area

A small help on this please.

Thank you.Dim conn As ADODB.Connection 'CONNECTION TO BROKER QUERIES
Dim rs As ADODB.Recordset 'HOLDS ALL DATA RETURNED FROM QUERY
Dim crystal As CRAXDRT.Application 'LOADS REPORT FROM FILE
Dim Report As CRAXDRT.Report 'HOLDS REPORT

Set conn = New ADODB.Connection
conn.Open "Provider=MSDAORA.1;User ID=scott;Data Source=qb;Persist Security Info=False", "sebsv4", "sebsv4pwd" 'THESE OPTION VALUES ARE BEST FOR VB

Set rs = New ADODB.Recordset
rs.Open q, conn, adOpenStatic, adLockReadOnly

Set crystal = New CRAXDRT.Application 'MANAGES REPORTS

Set Report = crystal.OpenReport(App.Path & "\report1.rpt") 'OPEN OUR REPORT

Report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
Report.Database.SetDataSource rs 'LINK REPORT TO RECORDSET

CRViewer1.ReportSource = Report 'LINK VIEWER TO REPORT
CRViewer1.ViewReport 'SHOW REPORT|||thanks for the quick reply sraheem

another small problem,

if I am using the report designer in VB like that, when I have draged a field name in to the report
it shows the field name as

field:<TableName>.<ColumnName>

now If I am doing the data binding at run time how can I add the recordset columns in to the report, since there is no data property on report fileds

Thanx.|||just capture report sections like below and add fields...

Dim crxdetail As CRAXDDRT.Section 'Section Decleration
Dim crxPageHeader As CRAXDDRT.Section 'Section Decleration
Dim crxPageFooter As CRAXDDRT.Section 'Section Decleration

Set crxdetail = Report.Sections.Item("D") 'Detail Section
Set crxPageHeader = Report.Sections.Item("PH") 'Detail Section
Set crxPageFooter = Report.Sections.Item("PF") 'Detail Section

crxdetail.AddFieldObject "{e." & rs(i).Name & "}", 1000, 0

where e is the report command object name or table name in your case.

Binary (Image) in SSAS

I have an Image column in my database nicely imported by SSIS. I want to use these (product) images in my reports. These reports use a SSAS cube as source.

However, I'm unable to use this column as an attribute of my dimension. I get the error:
The 'Binary' data type is not allowed for the 'KeyColumns' property #0

I know there are alternatives like only storing the location of the file and using the url to get it, but that's not an option for me.

Thank you very much!Still nobody who can awnser this? |||

Look in the Adventure Works sample cubes in the Product dimension. They've got the logo image in there. The trick is to put an int ID as the KeyColumn and use the image datatype as the MemberValue.

Binary (Image) in SSAS

I have an Image column in my database nicely imported by SSIS. I want to use these (product) images in my reports. These reports use a SSAS cube as source.

However, I'm unable to use this column as an attribute of my dimension. I get the error:
The 'Binary' data type is not allowed for the 'KeyColumns' property #0

I know there are alternatives like only storing the location of the file and using the url to get it, but that's not an option for me.

Thank you very much!Still nobody who can awnser this? |||

Look in the Adventure Works sample cubes in the Product dimension. They've got the logo image in there. The trick is to put an int ID as the KeyColumn and use the image datatype as the MemberValue.

BIG PROBLEM : Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'

Anyone know my reports are all suddenly throwing this back :
Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'
?The Report Server uses two databases on SQL Server. One of them is called
ReportServerTempDB. It contains a table called ExecutionCache. Check out
whether this table is still there, and whether it can still be queried. You
have to use Enterprise Manager or Query Analyzer to try and query it.
HTH
Charles Kangak, MCT, MCDBA
"Matt Swift" wrote:
> Anyone know my reports are all suddenly throwing this back :
> Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'
> ?
>
>

Big performance problem with reports

Hello everyone!
I have major performance problems with reports that I have deployed in
Reporting Services.
I have an Sql database with millions of rows, and I have created a cube in
Analysis Services that is run against a view in the database.
My reports get data from the cube and the dataset is created with Sql syntax.
I need to filter the report and needed to create parameters, but only
prameters that give the option of choosing "all", i.e. being optional
parameters. The only way I can do that, as far as I know, is by creating the
filter parameter datasets in Sql Syntax. That is to be able to use union as
in
"select 'All'
union
select the real dataset
group by value" syntax. And it seems that I can't use union when running the
sql statement on a cube, so I have to run the statement on the original
database view.
Now the problem I have is that it takes about half an hour or more to view
the report, after choosing values in some filter parameters!
As far as I can see, the group by, is the statement that takes such a long
time. But that can't be the only problem.
So... does anyone know what I can do to reduce the time it takes to process
a report and what performance enhancements I can do?
I also have a problem with a specific report that gets a
System.OutOfMemoryException when I try to view it in the preview pane. But
when I run the dataset generating the report data, there are no problems.
Does anybody know what the problem might be?
I'm in a tight place and would appreciate any fast responses.
Thanks a lot,
TaraDo you have a stored procedure or is the sql code inside the RDL?
If you put as much as possible on the SQL Server, you can run it
through Query Analyzer and look at query plans etc. It does sound like
you are passing a lot more data around than you need, so get all the
SQL code out of the RDL and see where that gets you.

BIDS doesn't install correctly...

hi, (this is also posted on the vstudio.general group)
i installed the SQL 2005 toolkit so i could design reports in VS 2005, with
the Business Intelligence project templates.
my VS 2005 professional is installed into C:\Program Files\Microsoft Visual
Studio 2005\, i can't remember if this was the default directory or not, i
suspect it is not because of some "assembly not found" errors when i attempt
to run the so-called "Business Intelligence Development Studio" (which
installed with a broken short-cut after installation). i fixed the broken
shortcut to point to the visual studio 2005 devenv.exe.
i then try to create a new BI project and get a message
"Could not load file or assembly Microsoft.ReportingServices.Designer
Version=9.0.242.0"
another user also encountered this problem and posted it here:
http://forums.microsoft.com/MSDN/Sho...65224&SiteID=1
i searched for the Microsoft.ReportingServices.Designer file and it is
located in
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
i copy it to C:\Program Files\Microsoft Visual Studio
2005\Common7\IDE\PrivateAssemblies
and then restart VS and lo and behold i get a different error message for
the next file that is missing. so i try copying the entire
PrivateAssemblies folder in to the 2005 directory and now i get "object
reference not set to instance of an object". ok so i'm chancing my arm
copying files around like this, but can anyone make sense of the MESS that
is BIDS? i have repaired both my VS 2005 installation and all SQL 2005
related software, to no avail.
i would suspect that re-installing VS into the vs 8 directory (not the 2005
directory) would solve the problem but i would hate to waste all that time
uninstalling and reinstalling VS just because BIDS has a big installation
bug.
thanks for any help
tim mackey.
after i copied the PrivateAssemblies folder on top of my vS 2005 folder, it
got a bit worse (understandably) so i decided to do a repair. now the BI
projects work fine.
i'm still convinced there is a bug in BIDS integration with existing VS 2005
installations.
tim
"Tim_Mac" <tim.mackey@.community.nospam> wrote in message
news:e%23C%23f6r7GHA.3340@.TK2MSFTNGP04.phx.gbl...
> hi, (this is also posted on the vstudio.general group)
> i installed the SQL 2005 toolkit so i could design reports in VS 2005,
> with
> the Business Intelligence project templates.
> my VS 2005 professional is installed into C:\Program Files\Microsoft
> Visual
> Studio 2005\, i can't remember if this was the default directory or not, i
> suspect it is not because of some "assembly not found" errors when i
> attempt
> to run the so-called "Business Intelligence Development Studio" (which
> installed with a broken short-cut after installation). i fixed the broken
> shortcut to point to the visual studio 2005 devenv.exe.
> i then try to create a new BI project and get a message
> "Could not load file or assembly Microsoft.ReportingServices.Designer
> Version=9.0.242.0"
> another user also encountered this problem and posted it here:
> http://forums.microsoft.com/MSDN/Sho...65224&SiteID=1
> i searched for the Microsoft.ReportingServices.Designer file and it is
> located in
> C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
> i copy it to C:\Program Files\Microsoft Visual Studio
> 2005\Common7\IDE\PrivateAssemblies
> and then restart VS and lo and behold i get a different error message for
> the next file that is missing. so i try copying the entire
> PrivateAssemblies folder in to the 2005 directory and now i get "object
> reference not set to instance of an object". ok so i'm chancing my arm
> copying files around like this, but can anyone make sense of the MESS that
> is BIDS? i have repaired both my VS 2005 installation and all SQL 2005
> related software, to no avail.
> i would suspect that re-installing VS into the vs 8 directory (not the
> 2005
> directory) would solve the problem but i would hate to waste all that time
> uninstalling and reinstalling VS just because BIDS has a big installation
> bug.
> thanks for any help
> tim mackey.
>
>

BI Development Studio Licensing and VS Express Edition

If we have a fully functional and Licensed Report Server 2005, can we allow
people using Visual Studio Express to develop reports?
I our shop we have two types of report developers, The first type is the
full blast developer that has the full Visual Studio product. The second
type does scripting and some light programming using the express products.
ThanksRS 2000 and RS 2005 are totally different in this respect. RS 2000 required
VS to install the designer into. RS 2005 will use VS if it is there but it
is not required. It will install its own copy if there is no VS. What this
means is that there is no dependency from either a physical or a licensing
perspective. VS is not needed for RS 2005 designer.
My guess is if VS Express is there it will install with it but that is just
a guess. As far as allowing, from a licensing perspecitve there is no
problem. Will it work, my guess is yes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hpux9@.nospam.nospam> wrote in message
news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> If we have a fully functional and Licensed Report Server 2005, can we
> allow
> people using Visual Studio Express to develop reports?
> I our shop we have two types of report developers, The first type is the
> full blast developer that has the full Visual Studio product. The second
> type does scripting and some light programming using the express products.
> Thanks|||Bruce,
Thanks for the reply. I have installed RS 2005 designer on 2 workstations.
Workstation 1 has a licensed copy of VS2005, the install integrated with VS
2005 as expected.
The second PC had a copy of C# Express. On this box the install dropped
down a copy of VS that only had the BI project types (which is good!).
The only issue I see is that I had to enter the SQL 2005 license key (in
both cases) to get to the screen where I selected RS 2005 designer. If the
designer is trully "free" how am I going to get the software to the
developers?
Thanks!
"Bruce L-C [MVP]" wrote:
> RS 2000 and RS 2005 are totally different in this respect. RS 2000 required
> VS to install the designer into. RS 2005 will use VS if it is there but it
> is not required. It will install its own copy if there is no VS. What this
> means is that there is no dependency from either a physical or a licensing
> perspective. VS is not needed for RS 2005 designer.
> My guess is if VS Express is there it will install with it but that is just
> a guess. As far as allowing, from a licensing perspecitve there is no
> problem. Will it work, my guess is yes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <hpux9@.nospam.nospam> wrote in message
> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> > If we have a fully functional and Licensed Report Server 2005, can we
> > allow
> > people using Visual Studio Express to develop reports?
> >
> > I our shop we have two types of report developers, The first type is the
> > full blast developer that has the full Visual Studio product. The second
> > type does scripting and some light programming using the express products.
> >
> > Thanks
>
>|||The install comes via the SQL Server 2005 CD, which requires a license key.
I don't see any way around this. You don't need additional server licenses
to install the design tool but you do need to be able to run the setup from
the CD.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hpux9@.nospam.nospam> wrote in message
news:537D168E-4133-4D41-873A-204E89902F83@.microsoft.com...
> Bruce,
> Thanks for the reply. I have installed RS 2005 designer on 2
> workstations.
> Workstation 1 has a licensed copy of VS2005, the install integrated with
> VS
> 2005 as expected.
> The second PC had a copy of C# Express. On this box the install dropped
> down a copy of VS that only had the BI project types (which is good!).
> The only issue I see is that I had to enter the SQL 2005 license key (in
> both cases) to get to the screen where I selected RS 2005 designer. If
> the
> designer is trully "free" how am I going to get the software to the
> developers?
> Thanks!
> "Bruce L-C [MVP]" wrote:
>> RS 2000 and RS 2005 are totally different in this respect. RS 2000
>> required
>> VS to install the designer into. RS 2005 will use VS if it is there but
>> it
>> is not required. It will install its own copy if there is no VS. What
>> this
>> means is that there is no dependency from either a physical or a
>> licensing
>> perspective. VS is not needed for RS 2005 designer.
>> My guess is if VS Express is there it will install with it but that is
>> just
>> a guess. As far as allowing, from a licensing perspecitve there is no
>> problem. Will it work, my guess is yes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <hpux9@.nospam.nospam> wrote in message
>> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
>> > If we have a fully functional and Licensed Report Server 2005, can we
>> > allow
>> > people using Visual Studio Express to develop reports?
>> >
>> > I our shop we have two types of report developers, The first type is
>> > the
>> > full blast developer that has the full Visual Studio product. The
>> > second
>> > type does scripting and some light programming using the express
>> > products.
>> >
>> > Thanks
>>|||Bruce,
There are some features that you will not be able to use if you only
develop using BIDS though from what I have heard. What about custom code?
Custom assemblies? Is BIDS a fully functional replacement for developing
robust reports that need major customization (functions, code, assemblies)?
I need to know this. As far as I can see ... it will only install a BI
project type so where do you test custom code for example? I cant create a
custom assembly that is shared across all reports using BIDS alone. If I am
misunderstanding ... great. If I am not ... then I think it is important to
make sure people know that they will be losing function if they just go with
BIDS.
"Bruce L-C [MVP]" wrote:
> RS 2000 and RS 2005 are totally different in this respect. RS 2000 required
> VS to install the designer into. RS 2005 will use VS if it is there but it
> is not required. It will install its own copy if there is no VS. What this
> means is that there is no dependency from either a physical or a licensing
> perspective. VS is not needed for RS 2005 designer.
> My guess is if VS Express is there it will install with it but that is just
> a guess. As far as allowing, from a licensing perspecitve there is no
> problem. Will it work, my guess is yes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <hpux9@.nospam.nospam> wrote in message
> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> > If we have a fully functional and Licensed Report Server 2005, can we
> > allow
> > people using Visual Studio Express to develop reports?
> >
> > I our shop we have two types of report developers, The first type is the
> > full blast developer that has the full Visual Studio product. The second
> > type does scripting and some light programming using the express products.
> >
> > Thanks
>
>|||BIDS is for designing reports. You can do code behind reports but you cannot
do custom assemblies. If you do that you need VB.Net (or C# etc). A whole
lot of people are desinging reports only. Previously it was a big hassle,
they would be installing VS just for the report designer. If they are doing
that then they would not be doing anything you are talking about.
I disagree they are losing functionality. RS 2000 had to have some product
installed that had VS to get the designer installed. The designer previously
did not give you the tools to do anything that you mentioned (create custom
assemblies for example). Obviously if you are creating your own web pages
then you need a designer to do so. If you are creating your own custom
assemblies ditto. However, most people are not doing that (creating custom
assemblies).
There are two markets. People who are tightly integrating into their own app
or are integrating in their own data extensions or authentication. I'd say
the vast majority are not doing that. The others are using Report Manager
portal as is.
Obviously you are not doing that. Your type of development is why VS 2005
has the new controls. Note these controls do not come with RS 2005, you have
to purchase VS 2005 to get these (or VB.Net 2005 etc). Just for the controls
anyone integrating with their own app should get VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:94B2AA1F-AC25-4B6C-A29C-FD268445CA99@.microsoft.com...
> Bruce,
> There are some features that you will not be able to use if you only
> develop using BIDS though from what I have heard. What about custom code?
> Custom assemblies? Is BIDS a fully functional replacement for developing
> robust reports that need major customization (functions, code,
> assemblies)?
> I need to know this. As far as I can see ... it will only install a BI
> project type so where do you test custom code for example? I cant create
> a
> custom assembly that is shared across all reports using BIDS alone. If I
> am
> misunderstanding ... great. If I am not ... then I think it is important
> to
> make sure people know that they will be losing function if they just go
> with
> BIDS.
> "Bruce L-C [MVP]" wrote:
>> RS 2000 and RS 2005 are totally different in this respect. RS 2000
>> required
>> VS to install the designer into. RS 2005 will use VS if it is there but
>> it
>> is not required. It will install its own copy if there is no VS. What
>> this
>> means is that there is no dependency from either a physical or a
>> licensing
>> perspective. VS is not needed for RS 2005 designer.
>> My guess is if VS Express is there it will install with it but that is
>> just
>> a guess. As far as allowing, from a licensing perspecitve there is no
>> problem. Will it work, my guess is yes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <hpux9@.nospam.nospam> wrote in message
>> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
>> > If we have a fully functional and Licensed Report Server 2005, can we
>> > allow
>> > people using Visual Studio Express to develop reports?
>> >
>> > I our shop we have two types of report developers, The first type is
>> > the
>> > full blast developer that has the full Visual Studio product. The
>> > second
>> > type does scripting and some light programming using the express
>> > products.
>> >
>> > Thanks
>>

BI Dev Studio Licensing

I have a client that we're hosting a website for and we have a few reports
that we've done for them. They're wanting to create and publish their own
reports now and I'm wondering what to buy. They picked up Visual Studio Standard
Edition because on the MSDN site it says Standard does Reporting Services,
but after installing it, there's no Reporting Services Project type. I tried
having them install the client tools for SQL 2005 but the installer said
Reporting Services tools were already installed, not making much sense. How
exactly do I get them the BI Development Studio and does that require another
SQL 2005 license?SQL Server 2005 is licensed by the Server. There is no license for the
development tools. Unlike RS 2000, it ships with a version of VS if it is
not installed. If you have VS 2005 installed then it will install into that.
It doesn't make sense that it says the tools are already installed. I have
VS 2005 (because I needed VB.Net) and then installed VS 2005 BI on top of
that. VS 2005 has controls for Reporting Services IF you are creating your
own website or windows app. If all you want to do is create reports what you
want to do is install the BI client tools found on the SQL Server 2005 CD.
They can uninstall VS and any BI tools they find and then try again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Josh Belden" <joshuabelden@.hotmail.com> wrote in message
news:dee73200137b98c7f6131ce52f7c@.news.microsoft.com...
>I have a client that we're hosting a website for and we have a few reports
>that we've done for them. They're wanting to create and publish their own
>reports now and I'm wondering what to buy. They picked up Visual Studio
>Standard Edition because on the MSDN site it says Standard does Reporting
>Services, but after installing it, there's no Reporting Services Project
>type. I tried having them install the client tools for SQL 2005 but the
>installer said Reporting Services tools were already installed, not making
>much sense. How exactly do I get them the BI Development Studio and does
>that require another SQL 2005 license?
>

BI- Collaboration and reports

I would like to get ideas on how how to enable report users not only
just view reports but also take action after viewing a report by
collaborating with collegues. Here's a use case-
- A project mangager (PM) logs into a portal and view a projects
status report listing current status of all projects managed by him.
- He finds that one of the projects is falling behind due to a pending
task that Peter is working on.
******Collaboration piece******
- In the portal itself the PM enter in a comment for Peter to clarify
the task's status.
- Peter logs into the portal and sees the PMs' comments. In response
he adds a comment that his task completion is dependent on the the
CEO approving a pending PO.
- PM logs into the portal opens the same report and sees Peters
comments. He updates his weekly project issues report to highlight
this dependency.
I have seem Microsoft Performance Point demos that exibit similar
collaboration features. I am not sure if the collaboration piece
requires Performance Point or is it a Sharepoint feature. Any ideas on
how to implement, what technologies to use would be appreciated.
Regards,
KenIt is as you say a feature of PerformancePoint Server.
You could also check out Analyzer by StrategyCompanion.
"Ken" <raidken@.yahoo.com> wrote in message
news:3dfe603c-e258-40c4-939a-8405951dbcd7@.p73g2000hsd.googlegroups.com...
>I would like to get ideas on how how to enable report users not only
> just view reports but also take action after viewing a report by
> collaborating with collegues. Here's a use case-
> - A project mangager (PM) logs into a portal and view a projects
> status report listing current status of all projects managed by him.
> - He finds that one of the projects is falling behind due to a pending
> task that Peter is working on.
> ******Collaboration piece******
> - In the portal itself the PM enter in a comment for Peter to clarify
> the task's status.
> - Peter logs into the portal and sees the PMs' comments. In response
> he adds a comment that his task completion is dependent on the the
> CEO approving a pending PO.
> - PM logs into the portal opens the same report and sees Peters
> comments. He updates his weekly project issues report to highlight
> this dependency.
> I have seem Microsoft Performance Point demos that exibit similar
> collaboration features. I am not sure if the collaboration piece
> requires Performance Point or is it a Sharepoint feature. Any ideas on
> how to implement, what technologies to use would be appreciated.
> Regards,
> Ken|||Ken,
If this already exists in your portal you can add hyper links to you report.
AK Code Rat.
"Ken" wrote:
> I would like to get ideas on how how to enable report users not only
> just view reports but also take action after viewing a report by
> collaborating with collegues. Here's a use case-
> - A project mangager (PM) logs into a portal and view a projects
> status report listing current status of all projects managed by him.
> - He finds that one of the projects is falling behind due to a pending
> task that Peter is working on.
> ******Collaboration piece******
> - In the portal itself the PM enter in a comment for Peter to clarify
> the task's status.
> - Peter logs into the portal and sees the PMs' comments. In response
> he adds a comment that his task completion is dependent on the the
> CEO approving a pending PO.
> - PM logs into the portal opens the same report and sees Peters
> comments. He updates his weekly project issues report to highlight
> this dependency.
> I have seem Microsoft Performance Point demos that exibit similar
> collaboration features. I am not sure if the collaboration piece
> requires Performance Point or is it a Sharepoint feature. Any ideas on
> how to implement, what technologies to use would be appreciated.
> Regards,
> Ken
>

Between date selection

Hi,

I have the following situation.

I want to create reports with a start date parameter and an end date parameter

In my query i use "where date between @.startdate and @.enddate"

i configure my parameters so i get a nice calendar when i generate the report.

the problem is when i select for example a date starting 1 april 2007 and enddate 10 april 2007,

the result in my report gives me only the data from 1 until 9 april and not until 10.

in my database the date is stored as a date time (10/04/2007 17:25:30).

Any suggestion how i can solve my problem?

Greetings

Vinnie

Hello Vinnie,

The problem is that your database stores the time with your date and when you select a date in the date picker, it doesn't have a tme, so anything after midnight gets excluded. Try this as your where clause:

where date >= @.startdate and date < dateadd(d, 1, @.enddate)

Hope this helps.

Jarret

|||

Hi Vinnie,

When I come across this I normally use a conversion in my query:

where convert(varchar(25),date,101) between @.startdate and @.enddate

The conversion eliminates the time from the database field and will pull back all rows with the date portion between the start and end dates.

Simone

|||

Do you have a date picker control on your reporting website, so that instead of the user having to manually input the date in the correct format, they are given a control to pick the date ranges?

(Like datetimepicker control in C#)

Please let me know as that is what I need to do.

|||

Yes I do. You need to change the data type of the parameter in the Report to datetime. Go to "Report" then "Report Parameters" Select the parameter from the list on the left and change the data type to DateTime. This should automatically give the date control.

Simone

Bestpractice for ReportingServices 2005

Hello All,

I am working on ReportingServices 2005 and embading the reports in ASP.NET using ReportViewer.

I would like to know Best Practice for this above.

Like Header, Footer, Logo, Report Run time, ReportName, Start and EndDate, Width (on browser and while printing)
PageCount, MasterPages for ReportingServices 2005

Also on the Web Site(ASP.NET with AJAX ), how to navigate to these reports, like Menu or TreeView

Is there any BestPractice or StarterKit for .Net 2.0?

Here are useful links

http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx

http://msdn2.microsoft.com/en-us/library/ms159162.aspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx|||

Thanks for the reply.

Could you please point me to, where I can see live demo/working copy/starter kit to get a feel of the Bestpractice.

Thanks in Advance.

|||

Hi,

Check this link too -

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#underline4HyperlinkAction

Best way to view reports from a webpage

I can view a report created in SSRS by using a url or by using an Reportviewer control in asp.net 2.0 what is the best way to view reports from a webpage?

you can use the report viewer control in your web page and render the reports throught it for more info read this article

http://www.gotreportviewer.com/

Best Way to 'Program' for SRS

My background is as a Java programmer.
I am using SRS to create some reports. I am having a hard time getting used
to only dealing with the output from the database server. I'm used to having
access to objects, methods, etc...
I am trying to determine if I am better off just writing stored procedures
or if there is some way to use a .Net language (perhaps C#).
My data needs a fair amount of processing after it comes out of the database
before it is ready for display.
For instance, I need to get a row, perform some calculations, update another
row and then display... I think I could get it done in a stored proc, but it
still seems like a limited environment and a lot of what I need seems to
require cursors, which I am told are expensive.
So... Any comments on the best way to attack this?
Can I use C# to sit between my database and SRS? What kind of output would
my C# classes send to SRS?Hunter,
I would gravitate toward doing as much as possible data massaging at the
data source level. It will be less expensive than doing it in code. RS
allows you to use expressions where the field values can be changed before
displayed on the report but in your case this may not be enough. Another way
you can tackle this is to create a custom data extension which will get the
dataset, pre-process it, and return it to the report. Mine ADO.NET dataset
extension could get you started.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:7D8F6391-A8BB-49A8-B279-7EFF622398B9@.microsoft.com...
> My background is as a Java programmer.
> I am using SRS to create some reports. I am having a hard time getting
used
> to only dealing with the output from the database server. I'm used to
having
> access to objects, methods, etc...
> I am trying to determine if I am better off just writing stored procedures
> or if there is some way to use a .Net language (perhaps C#).
> My data needs a fair amount of processing after it comes out of the
database
> before it is ready for display.
> For instance, I need to get a row, perform some calculations, update
another
> row and then display... I think I could get it done in a stored proc, but
it
> still seems like a limited environment and a lot of what I need seems to
> require cursors, which I am told are expensive.
> So... Any comments on the best way to attack this?
> Can I use C# to sit between my database and SRS? What kind of output would
> my C# classes send to SRS?|||I agree with Leo... If there are common functions, etc, do these in views
or in the sql for your data source. Especially when you do views, these
expressions can be used by many reports, ( like formatting a name, or date,
or taking several values and making some business calculation). You can
write code in each report using VB, and that is OK for small things, but the
code is not sharable across many reports except though copy/paste. Which
leaves writing a customer assembly, and referencing it in reports. This
allows for sharing a single code base of common functions across many
reports, but increases the level of complexity and management...
hope this helps...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:7D8F6391-A8BB-49A8-B279-7EFF622398B9@.microsoft.com...
> My background is as a Java programmer.
> I am using SRS to create some reports. I am having a hard time getting
used
> to only dealing with the output from the database server. I'm used to
having
> access to objects, methods, etc...
> I am trying to determine if I am better off just writing stored procedures
> or if there is some way to use a .Net language (perhaps C#).
> My data needs a fair amount of processing after it comes out of the
database
> before it is ready for display.
> For instance, I need to get a row, perform some calculations, update
another
> row and then display... I think I could get it done in a stored proc, but
it
> still seems like a limited environment and a lot of what I need seems to
> require cursors, which I am told are expensive.
> So... Any comments on the best way to attack this?
> Can I use C# to sit between my database and SRS? What kind of output would
> my C# classes send to SRS?