report parameter order

hi,
after changing the order of my report parameters (in this example test)
in the menue via the up and down arrow I get the following error
message:
an error occured during local processing. an error occured during
report processing. the value expression for the query parameter 'date'
contains an error: the expression referenced a non-existing parameter
in the report parameters collection.
anybody knows how to do this?
thanksIt sounds like you have either:
A) deleted a parameter which was there before, or more likely
B) changed the sequence required for cascading parameters, i.e. parameters
where one value depends on another one previously entered. It is probably
something to do with one of your report parameters' 'available values' or
'default values' definitions.
HTH,
Magendo_man
"florian" wrote:
> hi,
> after changing the order of my report parameters (in this example test)
> in the menue via the up and down arrow I get the following error
> message:
> an error occured during local processing. an error occured during
> report processing. the value expression for the query parameter 'date'
> contains an error: the expression referenced a non-existing parameter
> in the report parameters collection.
> anybody knows how to do this?
> thanks
>|||You're right I got this error msg. with cascading parameters. The
hierachie goes like this: A-->B-->C Originally I only included A and C
in my parameters but B was missing. So I added B but I didn't like it
to occure as the last report parameter so I wanted to change the
position and then I got the error msg. I get the same error when I
modifie the rdl file and swith the Report Parameters.
Any ideas instead of writing the whole report once again?
magendo_man schrieb:
> It sounds like you have either:
> A) deleted a parameter which was there before, or more likely
> B) changed the sequence required for cascading parameters, i.e. parameters
> where one value depends on another one previously entered. It is probably
> something to do with one of your report parameters' 'available values' or
> 'default values' definitions.
> HTH,
> Magendo_man
> "florian" wrote:
> > hi,
> >
> > after changing the order of my report parameters (in this example test)
> > in the menue via the up and down arrow I get the following error
> > message:
> >
> > an error occured during local processing. an error occured during
> > report processing. the value expression for the query parameter 'date'
> > contains an error: the expression referenced a non-existing parameter
> > in the report parameters collection.
> >
> > anybody knows how to do this?
> >
> > thanks
> >
> >|||Just add parameter B back in to Report Parameters in 2nd position.
"florian" wrote:
> You're right I got this error msg. with cascading parameters. The
> hierachie goes like this: A-->B-->C Originally I only included A and C
> in my parameters but B was missing. So I added B but I didn't like it
> to occure as the last report parameter so I wanted to change the
> position and then I got the error msg. I get the same error when I
> modifie the rdl file and swith the Report Parameters.
> Any ideas instead of writing the whole report once again?
>
> magendo_man schrieb:
> > It sounds like you have either:
> > A) deleted a parameter which was there before, or more likely
> > B) changed the sequence required for cascading parameters, i.e. parameters
> > where one value depends on another one previously entered. It is probably
> > something to do with one of your report parameters' 'available values' or
> > 'default values' definitions.
> >
> > HTH,
> > Magendo_man
> >
> > "florian" wrote:
> >
> > > hi,
> > >
> > > after changing the order of my report parameters (in this example test)
> > > in the menue via the up and down arrow I get the following error
> > > message:
> > >
> > > an error occured during local processing. an error occured during
> > > report processing. the value expression for the query parameter 'date'
> > > contains an error: the expression referenced a non-existing parameter
> > > in the report parameters collection.
> > >
> > > anybody knows how to do this?
> > >
> > > thanks
> > >
> > >
>|||do mean at the data view or where?
magendo_man schrieb:
> Just add parameter B back in to Report Parameters in 2nd position.
> "florian" wrote:
> > You're right I got this error msg. with cascading parameters. The
> > hierachie goes like this: A-->B-->C Originally I only included A and C
> > in my parameters but B was missing. So I added B but I didn't like it
> > to occure as the last report parameter so I wanted to change the
> > position and then I got the error msg. I get the same error when I
> > modifie the rdl file and swith the Report Parameters.
> >
> > Any ideas instead of writing the whole report once again?
> >
> >
> > magendo_man schrieb:
> >
> > > It sounds like you have either:
> > > A) deleted a parameter which was there before, or more likely
> > > B) changed the sequence required for cascading parameters, i.e. parameters
> > > where one value depends on another one previously entered. It is probably
> > > something to do with one of your report parameters' 'available values' or
> > > 'default values' definitions.
> > >
> > > HTH,
> > > Magendo_man
> > >
> > > "florian" wrote:
> > >
> > > > hi,
> > > >
> > > > after changing the order of my report parameters (in this example test)
> > > > in the menue via the up and down arrow I get the following error
> > > > message:
> > > >
> > > > an error occured during local processing. an error occured during
> > > > report processing. the value expression for the query parameter 'date'
> > > > contains an error: the expression referenced a non-existing parameter
> > > > in the report parameters collection.
> > > >
> > > > anybody knows how to do this?
> > > >
> > > > thanks
> > > >
> > > >
> >
> >|||In Layout view select from the menu Report> Report Parameters..
You should then be able to add back in your deleted parameter and move it in
to the correct position.
~ Magendo_man
"florian" wrote:
> do mean at the data view or where?
>
> magendo_man schrieb:
> > Just add parameter B back in to Report Parameters in 2nd position.
> >
> > "florian" wrote:
> >
> > > You're right I got this error msg. with cascading parameters. The
> > > hierachie goes like this: A-->B-->C Originally I only included A and C
> > > in my parameters but B was missing. So I added B but I didn't like it
> > > to occure as the last report parameter so I wanted to change the
> > > position and then I got the error msg. I get the same error when I
> > > modifie the rdl file and swith the Report Parameters.
> > >
> > > Any ideas instead of writing the whole report once again?
> > >
> > >
> > > magendo_man schrieb:
> > >
> > > > It sounds like you have either:
> > > > A) deleted a parameter which was there before, or more likely
> > > > B) changed the sequence required for cascading parameters, i.e. parameters
> > > > where one value depends on another one previously entered. It is probably
> > > > something to do with one of your report parameters' 'available values' or
> > > > 'default values' definitions.
> > > >
> > > > HTH,
> > > > Magendo_man
> > > >
> > > > "florian" wrote:
> > > >
> > > > > hi,
> > > > >
> > > > > after changing the order of my report parameters (in this example test)
> > > > > in the menue via the up and down arrow I get the following error
> > > > > message:
> > > > >
> > > > > an error occured during local processing. an error occured during
> > > > > report processing. the value expression for the query parameter 'date'
> > > > > contains an error: the expression referenced a non-existing parameter
> > > > > in the report parameters collection.
> > > > >
> > > > > anybody knows how to do this?
> > > > >
> > > > > thanks
> > > > >
> > > > >
> > >
> > >
>sql

Report not rending via web service

I'm somewhat new to reporting services and have used a web service call to
render my reports in my asp.net applications in the past. All the reports
thus far have been Excel, and I've used the same method for calling these
reports from some sample code I found online. This has worked great up till
now.
I have a report I want to render in PDF. I've plugged in the correct values
in my code and the browser will try and download the PDF but returns a "File
is damaged and could not be displayed". I tried rending in Excel and I get
"This file is not in a recognizable format". I've compared my code to past
projects and everything looks good. The only difference with this report is
I used a list control with textboxes instead of a table which I've used on
all past reports. If anyone has a suggestion on what causes these error
message, please reply. Thanks.I figured it out. There was a <httpModules> tag in my web.config that was
causing this problem. I built another project to call my report with a
"clean" web.config and it works fine.
"jweesies" wrote:
> I'm somewhat new to reporting services and have used a web service call to
> render my reports in my asp.net applications in the past. All the reports
> thus far have been Excel, and I've used the same method for calling these
> reports from some sample code I found online. This has worked great up till
> now.
> I have a report I want to render in PDF. I've plugged in the correct values
> in my code and the browser will try and download the PDF but returns a "File
> is damaged and could not be displayed". I tried rending in Excel and I get
> "This file is not in a recognizable format". I've compared my code to past
> projects and everything looks good. The only difference with this report is
> I used a list control with textboxes instead of a table which I've used on
> all past reports. If anyone has a suggestion on what causes these error
> message, please reply. Thanks.

Report Manager indicates mail was went but it's not delivered

Hope someone can give a hint how to resolve this issue. RS manager indicates
the report was sent via e-mail, but the mail is not received by the
recipients.
The wierd thing is that manually putting a file in the SMTP Pickup folder
like the one below. it works fine. File is sent and received just fine.
From: sender@.email
To: recipient@.email
Subject: Testing SMTP
This is a manual SMTP test
If I drop a report file created by Reporting Services (no attachment just
send the link). The file is pick it up by SMTP, but no mail is received.
SMTP & RS logs indicates the mail was sent sucessfully.
What's going on?
ThanksI'm having the same problem on a Windows Server 2003 with RS and SP1
installed. Logs indicate the message was sent successfully but nothing ever
arrives. Advice would be greatly appreciated.
"David Nevarez" <DavidNevarez@.discussions.microsoft.com> wrote in message
news:A9DF5133-1B9E-413E-8C19-AD17C7AAF088@.microsoft.com...
> Hope someone can give a hint how to resolve this issue. RS manager
indicates
> the report was sent via e-mail, but the mail is not received by the
> recipients.
> The wierd thing is that manually putting a file in the SMTP Pickup folder
> like the one below. it works fine. File is sent and received just fine.
> From: sender@.email
> To: recipient@.email
> Subject: Testing SMTP
> This is a manual SMTP test
> If I drop a report file created by Reporting Services (no attachment just
> send the link). The file is pick it up by SMTP, but no mail is received.
> SMTP & RS logs indicates the mail was sent sucessfully.
> What's going on?
> Thanks|||Hi Mark,
I found your post in the forum at searching some solutions for my problem,
what is the same like you had.
Did you found a solution? Thank you
"Mark" wrote:
> I'm having the same problem on a Windows Server 2003 with RS and SP1
> installed. Logs indicate the message was sent successfully but nothing ever
> arrives. Advice would be greatly appreciated.
>
> "David Nevarez" <DavidNevarez@.discussions.microsoft.com> wrote in message
> news:A9DF5133-1B9E-413E-8C19-AD17C7AAF088@.microsoft.com...
> > Hope someone can give a hint how to resolve this issue. RS manager
> indicates
> > the report was sent via e-mail, but the mail is not received by the
> > recipients.
> >
> > The wierd thing is that manually putting a file in the SMTP Pickup folder
> > like the one below. it works fine. File is sent and received just fine.
> > From: sender@.email
> > To: recipient@.email
> > Subject: Testing SMTP
> >
> > This is a manual SMTP test
> >
> > If I drop a report file created by Reporting Services (no attachment just
> > send the link). The file is pick it up by SMTP, but no mail is received.
> >
> > SMTP & RS logs indicates the mail was sent sucessfully.
> >
> > What's going on?
> >
> > Thanks
>
>|||Hi David,
I found your post in the forum at searching some solutions for my problem,
what is the same like you had.
Did you found a solution? Thank you
"David Nevarez" wrote:
> Hope someone can give a hint how to resolve this issue. RS manager indicates
> the report was sent via e-mail, but the mail is not received by the
> recipients.
> The wierd thing is that manually putting a file in the SMTP Pickup folder
> like the one below. it works fine. File is sent and received just fine.
> From: sender@.email
> To: recipient@.email
> Subject: Testing SMTP
> This is a manual SMTP test
> If I drop a report file created by Reporting Services (no attachment just
> send the link). The file is pick it up by SMTP, but no mail is received.
> SMTP & RS logs indicates the mail was sent sucessfully.
> What's going on?
> Thanks