Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Is SSRS using VB behind the scenes? (!=programmingQuestion)

Is SSRS using VB behind the scenes? (!=programmingQuestion)

Scheduled Pinned Locked Moved The Lounge
helpsql-serversysadminquestion
5 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    kmoorevs
    wrote on last edited by
    #1

    My cohort has created some reports and datasets in SSRS 2016 on her computer and asked me to post them on the server. No problem, we've done this many times with SSRS 2012/14, piece of cake...except it's never that easy is it? Uploading the datasets worked fine, but all three reports fail with an error (something about compiling expressions) that it can't find a file from the temp folder. :wtf: ...in each case, the file extension is .vb! :laugh: Her suggestion is for me to send screenshots so that she can find the missing temp files on her laptop and assuming they are still there, send them to me so I can put them in the server temp folder and get the reports loaded. :omg: Oh well, here goes nothing... Btw, googling for the error doesn't show too many results. Is everyone staying on 2014? Also, yes, I already tried rebooting!

    "Go forth into the source" - Neal Morse

    K L G 3 Replies Last reply
    0
    • K kmoorevs

      My cohort has created some reports and datasets in SSRS 2016 on her computer and asked me to post them on the server. No problem, we've done this many times with SSRS 2012/14, piece of cake...except it's never that easy is it? Uploading the datasets worked fine, but all three reports fail with an error (something about compiling expressions) that it can't find a file from the temp folder. :wtf: ...in each case, the file extension is .vb! :laugh: Her suggestion is for me to send screenshots so that she can find the missing temp files on her laptop and assuming they are still there, send them to me so I can put them in the server temp folder and get the reports loaded. :omg: Oh well, here goes nothing... Btw, googling for the error doesn't show too many results. Is everyone staying on 2014? Also, yes, I already tried rebooting!

      "Go forth into the source" - Neal Morse

      K Offline
      K Offline
      Kyle Moyer
      wrote on last edited by
      #2

      We use SSRS here, and I can't say I've ever seen that error. It sounds more like your SSRS server is borked, if it can't compile the expressions in the report. Or, perhaps that the reports are written for a newer version of SSRS than you have on your report server, and the report is using some operator or function the server doesn't recognize. (Remember, MS error messages are disingenuous at best, and outright lies at worst...) To answer your primary question though, yeah, SRRS uses VB. A quick look at the expression editor makes it pretty obvious (the Operators->Logical/Bitwise list is 'And', 'Not', 'Or', etc, instead of '&&', '!', '||', and so on...) Best of luck resolving your issue. In my experience, SSRS can be a bit of an elephant to get fixed when it decides it doesn't want to work properly...

      L 1 Reply Last reply
      0
      • K Kyle Moyer

        We use SSRS here, and I can't say I've ever seen that error. It sounds more like your SSRS server is borked, if it can't compile the expressions in the report. Or, perhaps that the reports are written for a newer version of SSRS than you have on your report server, and the report is using some operator or function the server doesn't recognize. (Remember, MS error messages are disingenuous at best, and outright lies at worst...) To answer your primary question though, yeah, SRRS uses VB. A quick look at the expression editor makes it pretty obvious (the Operators->Logical/Bitwise list is 'And', 'Not', 'Or', etc, instead of '&&', '!', '||', and so on...) Best of luck resolving your issue. In my experience, SSRS can be a bit of an elephant to get fixed when it decides it doesn't want to work properly...

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        Kyle Moyer wrote:

        To answer your primary question though, yeah, SRRS uses VB. A quick look at the expression editor makes it pretty obvious

        That's just syntax; does not say which enginge is used.

        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

        1 Reply Last reply
        0
        • K kmoorevs

          My cohort has created some reports and datasets in SSRS 2016 on her computer and asked me to post them on the server. No problem, we've done this many times with SSRS 2012/14, piece of cake...except it's never that easy is it? Uploading the datasets worked fine, but all three reports fail with an error (something about compiling expressions) that it can't find a file from the temp folder. :wtf: ...in each case, the file extension is .vb! :laugh: Her suggestion is for me to send screenshots so that she can find the missing temp files on her laptop and assuming they are still there, send them to me so I can put them in the server temp folder and get the reports loaded. :omg: Oh well, here goes nothing... Btw, googling for the error doesn't show too many results. Is everyone staying on 2014? Also, yes, I already tried rebooting!

          "Go forth into the source" - Neal Morse

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          If you'd said "Excel", I'd be thinking about a custom macro file. Might not have any actual content, but if it is referenced from the project, it needs to be there.

          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

          1 Reply Last reply
          0
          • K kmoorevs

            My cohort has created some reports and datasets in SSRS 2016 on her computer and asked me to post them on the server. No problem, we've done this many times with SSRS 2012/14, piece of cake...except it's never that easy is it? Uploading the datasets worked fine, but all three reports fail with an error (something about compiling expressions) that it can't find a file from the temp folder. :wtf: ...in each case, the file extension is .vb! :laugh: Her suggestion is for me to send screenshots so that she can find the missing temp files on her laptop and assuming they are still there, send them to me so I can put them in the server temp folder and get the reports loaded. :omg: Oh well, here goes nothing... Btw, googling for the error doesn't show too many results. Is everyone staying on 2014? Also, yes, I already tried rebooting!

            "Go forth into the source" - Neal Morse

            G Offline
            G Offline
            Gary Wheeler
            wrote on last edited by
            #5

            SSRS = selective serotonin re-uptake supplement?

            Software Zen: delete this;

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups