Passing variable from code to Reporting Services Subscriptions

Agweet

Hi, i was wondering if someone could help me, i am trying to send a parameter to a report to create subscriptions. the parameter datatype on the report is set to an Integer Value...now the report parameter value in code can only accept string values...how can i pass my parameter from code as a integer?

living life on the flip side

Henry Minute

What, if anything, does this have to do with C#? What sort of Report? Crystal? SSRS? What?? How can you expect anyone to answer this?

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Agweet

Hi, sorry for the late reply, firstly: this has alot todo with C# seeing as i want to pass the parametervalue from C# to Reporting Services and then secondly: i stated in my subject and i Quote "Passing variable from code to Reporting Services Subscriptions"!

living life on the flip side

Henry Minute

In that case investigate Int32.TryParse(string,Int32) and its relations.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Agweet

Hi Henry, umm...sorry but i dont follow, i used this Int32.TryParse(Session["Accounts"],Int32) but i get an error on the last Int32: 'int' is a 'type' but is used like a 'variable' can i maybe ask you t0o provide me with a sample on how to achieve this method? thnaks in advance

living life on the flip side

Henry Minute

try this:

// field to hold the conversion, if it works
Int32 result;
// test to make sure the text converts to an integer
if (Int32.TryParse(Session\["Accounts"\], out result))
{
    // ok we got an int so....
    // pass result as the parameter to your report
}
else
{
    MessageBox.Show("Session\[Accounts\] is not convertible to an Int32");
}

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”