Showing posts with label required. Show all posts
Showing posts with label required. Show all posts

Friday, March 30, 2012

parameter passing with blanks - help required

Hi,

I am having a curious problem with parameter passing between

reports. I have 2 reports the first report gives employee name, Department and

in the second report I have employee details. If the user clicks on the

Employee name in the First report it should go to the second report and display

the details. My problem comes if suppose the employee name is “Don King”when the parameter gets passed it does not recognize

the space between thename and throws

an error saying King not recognized.

Would appreciate if anybody could suggest as to how I can

pass the name with spaces in the report parameters.

Thanks and regards

PMNJPassing parameter with space to Jump to report and a subreport work fine. How are you passing this parameter around?|||am passing the parameter thru the report parameter

regards
PMNJ|||I'm having the same problem. I've also got a parameter which can be one word, of more than one word, sometimes with a comma in it. I'm passing the parameter, like PMNJ, thru the report parameter.

Has someone solved this problem?|||I reiterate Brad's question. How are you passing the parameter? Are you using Jump to Report? Are you parsing together a URL link? More details.|||Sorry, here is the info you requested.

I'm passing the parameter (along with another one) with the report parameter, orinating from a jump to report link.
The parameter is correctly displayed when using a textbox and a expression with the parameter in it.
But, when using this parameter in the MDX query for the dataset it doesn't work when the parameter consists of more than one word, i.e. there are spaces (blanks) in it.

If you need more details, please say so, I'll be happy to supply them.

parameter passing with blanks - help required

Hi,

I am having a curious problem with parameter passing between

reports. I have 2 reports the first report gives employee name, Department and

in the second report I have employee details. If the user clicks on the

Employee name in the First report it should go to the second report and display

the details. My problem comes if suppose the employee name is “Don King”when the parameter gets passed it does not recognize

the space between thename and throws

an error saying King not recognized.

Would appreciate if anybody could suggest as to how I can

pass the name with spaces in the report parameters.

Thanks and regards

PMNJPassing parameter with space to Jump to report and a subreport work fine. How are you passing this parameter around?|||am passing the parameter thru the report parameter

regards
PMNJ|||I'm having the same problem. I've also got a parameter which can be one word, of more than one word, sometimes with a comma in it. I'm passing the parameter, like PMNJ, thru the report parameter.

Has someone solved this problem?|||I reiterate Brad's question. How are you passing the parameter? Are you using Jump to Report? Are you parsing together a URL link? More details.|||Sorry, here is the info you requested.

I'm passing the parameter (along with another one) with the report parameter, orinating from a jump to report link.
The parameter is correctly displayed when using a textbox and a expression with the parameter in it.
But, when using this parameter in the MDX query for the dataset it doesn't work when the parameter consists of more than one word, i.e. there are spaces (blanks) in it.

If you need more details, please say so, I'll be happy to supply them.

Wednesday, March 28, 2012

parameter limiting

I have a few required parameters listed at the top of a report. I want to
make it where when one parameter is chosen in the drop down menu, the other
parameter(s) limit their choices accordingly. I can't seem to find a way to
do this though.
Any help would be great. Thanks.Use the first parameter in the SQL for the second
"scraejtp" wrote:
> I have a few required parameters listed at the top of a report. I want to
> make it where when one parameter is chosen in the drop down menu, the other
> parameter(s) limit their choices accordingly. I can't seem to find a way to
> do this though.
> Any help would be great. Thanks.
>|||Don't think I follow. This is at the top of a report, there are 4 parameters
they need to specify. I want it to somehow update the list of the other drop
down parameters when they choose one.
For example at the top of a report they will have a parameter "Automaker",
and it will have Ford, GM. Then another parameter at the top called "cars"
and it will contain neon, mustang, corvette, f150. When they pick Ford under
automatker, I want the other parameter drop down to only show the mustang and
f150 without going to a different report.
"Antoon" wrote:
> Use the first parameter in the SQL for the second
> "scraejtp" wrote:
> > I have a few required parameters listed at the top of a report. I want to
> > make it where when one parameter is chosen in the drop down menu, the other
> > parameter(s) limit their choices accordingly. I can't seem to find a way to
> > do this though.
> > Any help would be great. Thanks.
> >
> >|||Base the dependent parameters on queries. Then have the SQL for the query
use the report parameter value to define the list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> Don't think I follow. This is at the top of a report, there are 4
> parameters
> they need to specify. I want it to somehow update the list of the other
> drop
> down parameters when they choose one.
> For example at the top of a report they will have a parameter "Automaker",
> and it will have Ford, GM. Then another parameter at the top called "cars"
> and it will contain neon, mustang, corvette, f150. When they pick Ford
> under
> automatker, I want the other parameter drop down to only show the mustang
> and
> f150 without going to a different report.
> "Antoon" wrote:
>> Use the first parameter in the SQL for the second
>> "scraejtp" wrote:
>> > I have a few required parameters listed at the top of a report. I want
>> > to
>> > make it where when one parameter is chosen in the drop down menu, the
>> > other
>> > parameter(s) limit their choices accordingly. I can't seem to find a
>> > way to
>> > do this though.
>> > Any help would be great. Thanks.
>> >
>> >|||Got it. Thanks.
"Bruce L-C [MVP]" wrote:
> Base the dependent parameters on queries. Then have the SQL for the query
> use the report parameter value to define the list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > Don't think I follow. This is at the top of a report, there are 4
> > parameters
> > they need to specify. I want it to somehow update the list of the other
> > drop
> > down parameters when they choose one.
> >
> > For example at the top of a report they will have a parameter "Automaker",
> > and it will have Ford, GM. Then another parameter at the top called "cars"
> > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > under
> > automatker, I want the other parameter drop down to only show the mustang
> > and
> > f150 without going to a different report.
> >
> > "Antoon" wrote:
> >
> >> Use the first parameter in the SQL for the second
> >>
> >> "scraejtp" wrote:
> >>
> >> > I have a few required parameters listed at the top of a report. I want
> >> > to
> >> > make it where when one parameter is chosen in the drop down menu, the
> >> > other
> >> > parameter(s) limit their choices accordingly. I can't seem to find a
> >> > way to
> >> > do this though.
> >> > Any help would be great. Thanks.
> >> >
> >> >
>
>|||Also, I forgot to mention, it works completely in the preview without any
issues.
"scraejtp" wrote:
> Got it. Thanks.
> "Bruce L-C [MVP]" wrote:
> > Base the dependent parameters on queries. Then have the SQL for the query
> > use the report parameter value to define the list.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> > news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > > Don't think I follow. This is at the top of a report, there are 4
> > > parameters
> > > they need to specify. I want it to somehow update the list of the other
> > > drop
> > > down parameters when they choose one.
> > >
> > > For example at the top of a report they will have a parameter "Automaker",
> > > and it will have Ford, GM. Then another parameter at the top called "cars"
> > > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > > under
> > > automatker, I want the other parameter drop down to only show the mustang
> > > and
> > > f150 without going to a different report.
> > >
> > > "Antoon" wrote:
> > >
> > >> Use the first parameter in the SQL for the second
> > >>
> > >> "scraejtp" wrote:
> > >>
> > >> > I have a few required parameters listed at the top of a report. I want
> > >> > to
> > >> > make it where when one parameter is chosen in the drop down menu, the
> > >> > other
> > >> > parameter(s) limit their choices accordingly. I can't seem to find a
> > >> > way to
> > >> > do this though.
> > >> > Any help would be great. Thanks.
> > >> >
> > >> >
> >
> >
> >|||Ok, I got it to work, except for one small thing. Now when the screen opens
you have your choices like you should. If you chose a different parameter
than the one it opens with the list does not change accordingly. BUT if you
click anywhere on the screen first, and then change the parameter it will
change the list accordingly. And it only takes the one click and then you can
change the first parameter as many times as you like and it will change
accordingly. It is like it isn't updating until the screen is reselected. Any
insights?
"Bruce L-C [MVP]" wrote:
> Base the dependent parameters on queries. Then have the SQL for the query
> use the report parameter value to define the list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "scraejtp" <scraejtp@.discussions.microsoft.com> wrote in message
> news:C59CD7D4-7966-402F-B770-1EA9817713A3@.microsoft.com...
> > Don't think I follow. This is at the top of a report, there are 4
> > parameters
> > they need to specify. I want it to somehow update the list of the other
> > drop
> > down parameters when they choose one.
> >
> > For example at the top of a report they will have a parameter "Automaker",
> > and it will have Ford, GM. Then another parameter at the top called "cars"
> > and it will contain neon, mustang, corvette, f150. When they pick Ford
> > under
> > automatker, I want the other parameter drop down to only show the mustang
> > and
> > f150 without going to a different report.
> >
> > "Antoon" wrote:
> >
> >> Use the first parameter in the SQL for the second
> >>
> >> "scraejtp" wrote:
> >>
> >> > I have a few required parameters listed at the top of a report. I want
> >> > to
> >> > make it where when one parameter is chosen in the drop down menu, the
> >> > other
> >> > parameter(s) limit their choices accordingly. I can't seem to find a
> >> > way to
> >> > do this though.
> >> > Any help would be great. Thanks.
> >> >
> >> >
>
>

Monday, March 26, 2012

Parameter error

Why do I keep getting this error:

"A number is required here"

I am trying to prompt the user of the report for the a Billing ID, which will refresh the contents of the report.

I am using exactly the same technique and method which is illustrated in the manual:

{VW_BillingItemsConsolidated.BillingAddressID}={?billingID}

Where {VW_BillingItemsConsolidated.BillingAddressID} is the table field and {?billingID} is the forumla I have created.

RegardsNow I have changed the "Parameter Field" "Value Type" to take numerical data the error is no longer showing. Still though, when I enter a number the information on the report doesn't change to reflect that customer. Where am I going wrong?|||I just keeo getting "False" in the field which is inserted onto the report.|||What is the datatype of VW_BillingItemsConsolidated.BillingAddressID?
It should work correctly

Monday, March 12, 2012

Paging using Web Service

To get the UI we required, we built a custom .NET front end that
communicates directly with the MSRS web service. Paging (e.g. a break in the
data at a certain point with some indicator for the "next" page) does not
seem to work once you take this approach. Anyone figured this out?Hi Sean,
> To get the UI we required, we built a custom .NET front end that
> communicates directly with the MSRS web service. Paging (e.g. a break in the
[...]
>does not seem to work once
What doesn't work?
I used the same approch. My user control calls RS webservice with parameter "Section" of device settings so I can _read_ report section by section.
There is only a little problem... there is no way... perhaps is better to say I don't find any way to known How many sections I must paging :o
HTH M.rkino
--
Marco Barzaghi - [MVP - MCP]
http://mvp.support.microsoft.com - http://italy.mvps.org
UGIDotNet - User Group Italiano .NET, http://www.ugidotnet.org
Read my WebLog: http://www.ugidotnet.org/436.blog

Friday, March 9, 2012

Paging

Is there any way to implement a paging scheme such that only the required records are transferred from SQL Server to the asp.net app?

The only support I can find such as the DataAdaptor.Fill will bring all the records back from SQL Server and then create the page...

This obviously still takes time and memory based on the entire query, not the page size.

Any ideas?Hi,

You can use a temporary table via stored proc in SQL Server. Seehere andhere.

Another approach is to use SELECT TOP, seehere.

A.|||Thanks... Very useful...

Having a fully dynamic query built up in asp.net, without necessarily being from a single table and having unknown (in advance) columns, without always having a primary key I'm not sure that I will be able to adapt one of these without doing some major work on my system.